Yay! We finally got this working!
I basically just renamed the oracle-jdbc2-service.xml to
"db2-jdbc2-service.xml". The issue was with the following differences from the
Oracle SQL in the jdbc2-service.xml file:
$ diff db2-jdbc2-service.xml oracle-jdbc2-service.xml
60c60
< DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM JMS_MESSAGES MESS WHERE
TXOP=? AND EXISTS (SELECT TXID FROM JMS_TRA
NSACTIONS TX WHERE TX.TXID = MESS.TXID)
---
> DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM JMS_MESSAGES MESS WHERE
> TXOP=:1 AND EXISTS (SELECT TXID FROM JMS_TR
ANSACTIONS TX WHERE TX.TXID = MESS.TXID)
70c70
< CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER NOT
NULL, PRIMARY KEY (TXID) )
---
> CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER, PRIMARY
> KEY (TXID) )
DB2 doesn't like the Oracle bind variable (":1") syntax, and primary key
columns must be declared "NOT NULL".
- Michael
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3872807#3872807
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3872807
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
