2:16 a.m.
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
3:07 p.m.
New subject: [JBoss JIRA] Commented: (ISPN-698) DB2 - SQL Parameterization issue on FETCH FIRST ? clause
[
https://jira.jboss.org/browse/ISPN-698?page=com.atlassian.jira.plugin.sys...
]
Galder Zamarreño commented on ISPN-698:
---------------------------------------
Maybe you're using an old DB2 database?
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/c...
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
3:29 p.m.
New subject: [JBoss JIRA] Commented: (ISPN-698) DB2 - SQL Parameterization issue on FETCH FIRST ? clause
[
https://jira.jboss.org/browse/ISPN-698?page=com.atlassian.jira.plugin.sys...
]
Franck Garcia commented on ISPN-698:
------------------------------------
The FETCH FIRST x CLAUSE is present on my DB2 version (i/OS), I'm not contesting that.
What my driver does not like is the PreparedStatement.setInt(1, maxEntries) resulting in
an exception while PreparedStatement.executeQuery();
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
5:15 p.m.
New subject: [JBoss JIRA] Commented: (ISPN-698) DB2 - SQL Parameterization issue on FETCH FIRST ? clause
[
https://jira.jboss.org/browse/ISPN-698?page=com.atlassian.jira.plugin.sys...
]
Trustin Lee commented on ISPN-698:
----------------------------------
Check this out:
http://viewvc.jboss.org/cgi-bin/viewvc.cgi/hibernate/core/trunk/core/src/...
http://viewvc.jboss.org/cgi-bin/viewvc.cgi/hibernate/core/trunk/core/src/...
http://viewvc.jboss.org/cgi-bin/viewvc.cgi/hibernate/core/trunk/core/src/...
DB2 390/400 dialect extends DB2Dialect and overrides supportsVariableLimit() to return
false. It seems like fetch-first-clause cannot be parameterized in DB2 390 and 400.
Similar improvement needs to be made in TableManipulation.
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
9:03 p.m.
New subject: [JBoss JIRA] Updated: (ISPN-698) DB2 - SQL Parameterization issue on FETCH FIRST ? clause
[
https://jira.jboss.org/browse/ISPN-698?page=com.atlassian.jira.plugin.sys...
]
Manik Surtani updated ISPN-698:
-------------------------------
Assignee: Trustin Lee (was: Manik Surtani)
Fix Version/s: 5.0.0.BETA1
5.0.0.Final
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: 5.0.0.BETA1, 5.0.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
2:48 p.m.
New subject: [JBoss JIRA] Resolved: (ISPN-698) DB2 - SQL Parameterization issue on FETCH FIRST ? clause
[
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
4:31 p.m.
New subject: [JBoss JIRA] Updated: (ISPN-698) DB2 - SQL Parameterization issue on FETCH FIRST ? clause
[
https://jira.jboss.org/browse/ISPN-698?page=com.atlassian.jira.plugin.sys...
]
Franck Garcia updated ISPN-698:
-------------------------------
Attachment: db2400.patch
add DB2_400 as a new Database Type that doesn't support variable limit
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
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
11:23 p.m.
New subject: [JBoss JIRA] Commented: (ISPN-698) DB2 - SQL Parameterization issue on FETCH FIRST ? clause
[
https://jira.jboss.org/browse/ISPN-698?page=com.atlassian.jira.plugin.sys...
]
Franck Garcia commented on ISPN-698:
------------------------------------
Thank you for the change Trustin but my flavor of DB2 is 400. I've followed your code
with DB2_390 and attached a patch, could you make it available?
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
5:15 a.m.
New subject: [JBoss JIRA] Commented: (ISPN-698) DB2 - SQL Parameterization issue on FETCH FIRST ? clause
[
https://jira.jboss.org/browse/ISPN-698?page=com.atlassian.jira.plugin.sys...
]
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
3:40 p.m.
New subject: [JBoss JIRA] Commented: (ISPN-698) DB2 - SQL Parameterization issue on FETCH FIRST ? clause
[
https://jira.jboss.org/browse/ISPN-698?page=com.atlassian.jira.plugin.sys...
]
Franck Garcia commented on ISPN-698:
------------------------------------
Thank you. I find your advice strange but I will follow it. It's completely unnatural
for me using an IBM iSeries RDB to specify DB2_390 in the database type. Good Luck to
explain this in the doc.
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
4995
days inactive
5006
days old
infinispan-issues@lists.jboss.org
9 comments
4 participants
participants (4)
-
Franck Garcia (JIRA) -
Galder Zamarreño (JIRA)
-
Manik Surtani (JIRA)
-
Trustin Lee (JIRA)