2 Replies Latest reply on Apr 28, 2004 9:06 PM by Andrew Tyson

    Ingres XA Datasource problems

    Andrew Tyson Newbie

      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

        • 1. Re: Ingres XA Datasource problems
          Luke Taylor Novice

          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.

          • 2. Re: Ingres XA Datasource problems
            Andrew Tyson Newbie

            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