[JBoss-user] Facing "xaRes not enlisted" problem in MDB.

[Benoit X. <be...@ya...>]

Hi

Sorry if this has been discussed previously.
We are using some Message Driven Beans that need direct access to DB (for mostly reading).

May be we are doing something wrong... Please help!!!

we acquire the database connection through JNDI
  DataSource ds = ctx.lookup("java:/DefaultDS");
  Connection con = ds.getConnection();

/// use it
  con.close();

the close() method SOMETIMES throws and exception:
java.lang.RuntimeException: Unable to deregister with TransactionManager:
java.lang.IllegalArgumentException: xaRes not enlisted
        at org.jboss.pool.jdbc.xa.XAConnectionFactory$2.closeConnection(Unknown Source)
        at org.jboss.pool.jdbc.xa.XAConnectionFactory$2.connectionClosed(Unknown Source)
        at org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl.clientConnectionClosed(Unknown Source)
        at org.jboss.pool.jdbc.xa.wrapper.XAClientConnection.close(Unknown Source)
        at
com.premier.cims.sbl.util.ServiceLocator.releaseReusableConnection(ServiceLocator.java:249)
        at com.premier.cims.sbl.persist.access.GetContract.get(GetContract.java:115)
        at com.premier.cims.sbl.persist.PersistBean.getEntityByKey(PersistBean.java:143)
        at java.lang.reflect.Method.invoke(Native Method)
        at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:542)
        at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:82)
        at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:138)
        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:347)
        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:100)
        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:127)
        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:170)
        at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:286)
        at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invoke(BaseLocalContainerInvoker.java:297)
        at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker$StatelessSessionProxy.invoke(BaseLocalContainerInvoker.java:507)
        at $Proxy18.getEntityByKey(Unknown Source)
        at com.premier.cims.sbl.mgr.FinderSessionBean.findByKey(FinderSessionBean.java:138)
  etc etc

Could anyone tell us how to acquire a database connection?
Can it be cached? Can the datasource be cached?

many thanks

Benoit.

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com