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.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3918681#3918681
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3918681
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user