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

Reply via email to