JBoss + Oracle XA Connection --> WARN : JBossResourceExcept

[mmbouallagui]

Hello,

I'm trying to configure a connection to my Oracle database under JBoss 4.0.4 GA. My application manages to connect to the database and can load the data from it. But I get frequently this error :

2007-03-29 15:45:38,531 WARN [org.jboss.resource.connectionmanager.TxConnectionManager] Error during tidyup org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@476914[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@1117cc0 handles=0 lastUse=1175175938468 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@1152c0e context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@ff6348 xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@1117cc0 txSync=null]
org.jboss.resource.JBossResourceException: xa tx only!
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.getLocalTransaction(XAManagedConnection.java:80)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.tidyup(TxConnectionManager.java:657)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.java:336)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed(TxConnectionManager.java:623)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:266)
at org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:129)



I've configured the xa-datasource by following the instructions given in the "start guide" from JBoss website :

******* oracle-xa-ds.xml ****

<xa-datasource>
<jndi-name>jdbc/MyDS</jndi-name>
<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:@localhost:1521:dev</xa-datasource-property>
<xa-datasource-property name="User">dev</xa-datasource-property>
<xa-datasource-property
name="Password">dev</xa-datasource-property>

<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<no-tx-separate-pools/>

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

<type-mapping>Oracle9i</type-mapping>

</xa-datasource>


<depends
optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager





****** jta-service (adding Pad= true) ***
<!-- The configurable Xid factory. For use with Oracle, set pad to
true -->

true






Does somebody have encountered this problem ? Please, tell me where i'm wrong.

Thanks a lot for your answer.

[weston.price]

Moving to the JCA forum.

[weston.price]

This indicates that you have a 'hanging' local transaction. How are you using the DataSource? Are you executing conn.begin() at any point?

[mmbouallagui]

Hi,

In fact, I get the DataSource object :

InitialContext initCtx = new InitialContext();
DataSource dsrc = (DataSource) initCtx.lookup(jndiName);

the I use : dsrc.getConnection in another method to use the connection. (It works without the warning with Jboss 3.2.7.)

Thanks for your answer

[weston.price]

Are you calling begin() at any point in using the connection? Something is leaving a hanging transaction and typically this results from using the local JDBC API in a managed context.

[mmbouallagui]

I've checked in the code. There's no begin() called. When the connection is needed, it uses the DataSource object returned by the getDataSource helper method whose the code was posted in my previous message.

Or did i put something wrong in my config ?

Thanks.