I'm trying to get a DB2 XA connection. I copied the db2-xa-ds.xml file into server/default/deploy. I also copied db2jcc.jar into server/default/lib (I'm using DB2 UDB 8.1, so I can't use db2java.zip). I edited my db2-xa-ds.xml file to look like this:
| <xa-datasource> | <jndi-name>jdbc/WPDS</jndi-name> | | <xa-datasource-class>com.ibm.db2.jcc.DB2XADataSource</xa-datasource-class> | | <xa-datasource-property name="URL">jdbc:db2://acio-wpdbs:50000/mh331b13</x> | <xa-datasource-property name="User">db2inst1</xa-datasource-property> | <xa-datasource-property name="Password">db2inst1</xa-datasource-property> | </xa-datasource> | When I try to use the connection, I get the following error: | SQLException occurred: Could not create connection; - nested throwable: | (com.ibm.db2.jcc.b.SQLException: Driver type 2 not enabled for XA | connections); - nested throwable: | (org.jboss.resource.JBossResourceException: Could not create connection; | - nested throwable: (com.ibm.db2.jcc.b.SQLException: Driver type 2 not | enabled for XA connections)) | So it defaulted to a Type 2 connection. DB2 Type 4 connections have XA ( I think) but I don't know how to set it. I've tried: <xa-datasource-property name="DriverType">4</xa-datasource-property> | But I got the same error. Anyone have this working?? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3852835#3852835 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3852835 ------------------------------------------------------- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
