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

[Franck Garcia (JIRA)]

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: Manik Surtani


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.  


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira