Hi, I've got an Oracle xa datasource configured in my application. The datasource configuration file looks like this:
| <datasources> | <xa-datasource> | <jndi-name>jdbc/myDataSource</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:@hostname:1521:systao</xa-datasource-property> | <xa-datasource-property name="User">user</xa-datasource-property> | <xa-datasource-property name="Password">password</xa-datasource-property> | <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool --> | <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name--> | <!-- Checks the Oracle error codes and messages for fatal errors --> | <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> | <!-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa --> | <no-tx-separate-pools/> | </xa-datasource> | | <mbean code="org.jboss.resource.adapter.jdbc.xa.oracle.OracleXAExceptionFormatter" | name="jboss.jca:service=OracleXAExceptionFormatter"> | <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends> | </mbean> | | </datasources> | I've successfully deployed this datasource in my jboss 3.2.3 installation in a W2k box. Everything works. Nevertheless, If i deploy the application to a jboss3.2.3 in a Linux box the datasource is correctly deployed, the application is correctly deployed, but when I access an EJB (from a Servlet) I get the following Exception: | org.jboss.tm.JBossTransactionRolledbackException: null; nested exception is: | org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=basictest.e-mm.com//21, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (oracle.jdbc.xa.OracleXAException); - nested throwable: (org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=basictest.e-mm.com//21, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (oracle.jdbc.xa.OracleXAException)) | at org.jboss.ejb.plugins.TxInterceptorCMT.throwJBossException(TxInterceptorCMT.java:489) | at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:403) | at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:277) | at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128) | at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118) | at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) | at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) | at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331) | at org.jboss.ejb.Container.invoke(Container.java:700) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | Could anyone give me some light of what is it happening? Thanks in advance. P. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3833780#3833780 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3833780 ------------------------------------------------------- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
