[
https://jira.jboss.org/browse/ISPN-698?page=com.atlassian.jira.plugin.sys...
]
Trustin Lee resolved ISPN-698.
------------------------------
Fix Version/s: 4.2.0.BETA1
4.2.0.Final
(was: 5.0.0.BETA1)
(was: 5.0.0.Final)
Resolution: Done
Fix checked in to branches/4.2.x and trunk. Because there seem to be no definitive way to
determine the specific DB2 version (DB2 vs DB2 390 vs DB2 400), you have to call the
setDatabaseType("DB2_390") for the relevant CacheStoreConfig. Please confirm
and close.
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.
--
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