Ingres XA Datasource problems

[tysmeister]

Hi,

CA-Ingres comes bundled with a JDBC driver that supports XA connections. There is an informational site that provides explicit instructions for setting up
an <xa-datasource/> using JBoss 3.2.x and their JDBC driver.

http://support.ca.com/techbases/ingres/TEC317590.html

When I try and set this up however I get an exception thrown whenever I try and get a new connection from the the datasource handle. Please see the top of the exception stack below;

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Could not find accessor on XADataSource: ; - nested throwable: (java.lang.NoSuchMethodException: ca.edbc.jdbcx.EdbcXADataSource.setAutoCommitMode(java.lang.String)))
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:145)

Where does the setAutoCommit() method come from? Looking at the signature for the javax.sql.XADatasource interface from the J2SE 1.4.2 API this method is not part of the XADatasource interface.

I have no problems setting up a <local-trx-datasource/> using the same driver.

Thanks and regards,
Andrew

[luke_t]

There is a mistake in the CA example. The property should be AutocommitMode, not AutoCommitMode. This matches the method on the EdbcXADataSource class.

Doesn't inspire confidence that they actually got it working.

[tysmeister]

Hi Luke,

Many thanks for your reply. I have modified the resource as you suggested, however now I get the following error when trying to create an XA connection;

ca.edbc.util.EdbcEx: JDBC request is not supported.
at ca.edbc.util.EdbcEx.get(EdbcEx.java:195)
at ca.edbc.jdbc.EdbcConnect.dbms_connect(EdbcConnect.java:657)
at ca.edbc.jdbc.EdbcConnect.(EdbcConnect.java:356)
at ca.edbc.jdbcx.EdbcDataSource.getConnection(EdbcDataSource.java:442)
at ca.edbc.jdbcx.EdbcXADataSource.getXAConnection(EdbcXADataSource.java:200)
at ca.edbc.jdbcx.EdbcXADataSource.getXAConnection(EdbcXADataSource.java:166)
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:137)
... 4 more

I am using the latest (?) 1.9 version of the EDBC driver. The non-XA edbc driver works fine, so it appears to be something specific to the XA based driver.

Thanks and regards,
Andrew