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

[Trustin Lee (JIRA)]

    [ https://jira.jboss.org/browse/ISPN-698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12558899#action_12558899 ] 

Trustin Lee commented on ISPN-698:
----------------------------------

They are actually the same thing.  If your database type is DB2/400, you can simply specify DB2_390.  It would be nice if Infinispan can auto-detect 390 and 490, but it seems like there's no way to do that.  You always have to specify the database type manually for DB2 390 and 400, so I'm not sure adding DB2_400 makes much sense.

> 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.ALPHA4, 4.2.0.Final
>
>         Attachments: db2400.patch
>
>
> 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