1 Reply Latest reply on Jan 23, 2006 4:27 AM by adrian.brock

    WrapperDataSource.getConnection() : Problems

    preddy

      Hi,
      I am using the following code to create a java.sql.Connection object.

      initCtx = new InitialContext();
      org.jboss.resource.adapter.jdbc.WrapperDataSource ds = (org.jboss.resource.adapter.jdbc.WrapperDataSource) initCtx.lookup(dataSource);
      Connection connection = ds.getConnection();

      But when creating the connection object (i.e at ds.getConnection() ), i am getting following exception:

      java.sql.SQLException: ORA-06550: line 1, column 13:
      PLS-00201: identifier 'JAVA_XA.XA_START_NEW' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored

      Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed; - nested throwable: (javax.resource.ResourceException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed)

      -------------------------------------------------------------------------

      Following is my XA Datasource xml file:

      datasources>
      xa-datasource>
      jndi-name>DataSource</jndi-name>
      track-connection-by-tx>true</track-connection-by-tx>
      isSameRM-override-value>false</isSameRM-override-value>
      xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
      xa-datasource-property name="URL">jdbc:oracle:thin:@IPAddress:1521:host</xa-datasource-property>
      xa-datasource-property name="User">scott</xa-datasource-property>
      xa-datasource-property name="Password">tiger</xa-datasource-property>
      no-tx-separate-pools/>

      !-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional)
      metadata>
      type-mapping>Oracle9i</type-mapping>
      /metadata> -->

      /xa-datasource>

      !--
      depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager
      /mbean> -->
      /datasources>

      Please help
      Thanks.