-
Bug
-
Resolution: Done
-
Major
-
4.1.0.Final
When trying to pre-load a cache from a jdbc db2 store, infinispan takes the maxEntries parameter of the eviction config to limit the number of rows fetched from the db.
SELECT DATA_COLUMN, ID_COLUMN FROM MY_LUCENE_IDX_luceneIndex FETCH FIRST ? ROWS ONLY
Unfortunatelly db2 seems to not accept SQL parameterization for the FETCH FIRST x CLAUSE
java.sql.SQLException: [SQL0104] Token ? was not valid. Valid tokens: ROW ROWS. Cause . . . . . :
A syntax error was detected at token ?. Token ? is not a valid token.
A partial list of valid tokens is ROW ROWS.