[infinispan-issues] [JBoss JIRA] Resolved: (ISPN-698) DB2 - SQL Parameterization issue on FETCH FIRST ? clause

DB2 - SQL Parameterization issue on FETCH FIRST ? clause -------------------------------------------------------- Key: ISPN-698 URL: https://jira.jboss.org/browse/ISPN-698 Project: Infinispan Issue Type: Bug Components: Loaders and Stores Affects Versions: 4.1.0.Final Environment: linux ubuntu 10.04 x386 32 bits hot spot jvm 1.6_018 DB2/400 (jdbc jtopen v 7.1) Reporter: Franck Garcia Assignee: Trustin Lee Fix For: 4.2.0.BETA1, 4.2.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.