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.
http://wiki.jboss.org/wiki/Wiki.jsp?page=JBossHelp
FAQ - and this is not the Oracle support forum.