[v7] "You cannot add null parameters using addParamaters"

Vaadin 6 / 7 / 8
1

Can anyone give a hint on what this means?

I’ve started seeing this exception in my logs recently. Googling for it leads to a thread on StackOverflow where they talk about it:

https://stackoverflow.com/questions/25797095/vaadin-containerfilter-select-null-field

Anyway, it’s not clear enough for me.

Also, looking at the sources (https://github.com/vaadin/framework/blob/7.7/server/src/main/java/com/vaadin/data/util/sqlcontainer/query/generator/StatementHelper.java), I don’t see any “addParameters” method either on the place where it fails or in the entire Vaadin sources.

2

The exception is coming from the [addParameterValue()]
(https://github.com/vaadin/framework/blob/f1039e892ca4d40e7ed441264f1d35b30733d679/server/src/main/java/com/vaadin/data/util/sqlcontainer/query/generator/StatementHelper.java#L58-L67) method.

Looking at the callers’ code, passing null can happen when the like, between or comparator (equal, greater etc.) statement has no value. To me it looks like a broken query.