|
JoinProcessor.java
Why the "?" is used in the fillArray(...). This causes the query to not to use dynamic filters. What I mean is for example the query "select tab.a_no, tab.b_no from table1 tab where tab.ids in ( :filter.filterParam )" gets changed to "select tab.a_no, tab.b_no from table1 tab where tab.ids in ( ? )". As the hqlQuery plan is cached, if I use the same query with different filter parameters, this goes for a toss, as it is hardcoded to "?" instead of ":filter.filterParam". So when I fire the same query with more filter parameters, the hardcoded "?" causes it to fail.
|