Oracle 9i XA and App server 5.1.0.1
mdroth
We're trying to get the oracle 9.2.0.4 XA driver to work with our
application under websphere 5.1.0.1. We have a few classes that load
under static initializers from other classes and lookup datasources
outside of the usual ejb/web/client channels. The classes are getting
shareable (the default) datasources and since some of them use the same
datasource and its JNDI name to create a connection, it seems as though
the classes keep getting a handle to a shared connection. The causes a
problem when the classes close the connection and the connection
manager tries to cleanup the connection and release it back to the
pool. This is the stack trace that we see.
[4/15/04 13:34:22:188 CDT] 5feeed2b MCWrapper E J2CA0081E: Method
cleanup failed while trying to execute method cleanup on
ManagedConnection
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl@6123ed43 from
resource com.nextjet.datasource.RoutingDataSource. Caught exception:
com.ibm.ws.exception.WsException: DSRA0080E: An exception was received
by the Data Store Adapter. See original exception message: Cannot call
'cleanup' on a ManagedConnection while it is still in a transaction..
at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:217)
at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:171)
at
com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:208)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:2508)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup(WSRdbManagedConnectionImpl.java:2243)
at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java:1161)
at
com.ibm.ejs.j2c.poolmanager.FreePool.returnToFreePool(FreePool.java:291)
at
com.ibm.ejs.j2c.poolmanager.PoolManager.release(PoolManager.java:1231)
at
com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:1668)
at
com.ibm.ejs.j2c.ConnectionEventListener.connectionClosed(ConnectionEventListener.java:209)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionClosedEvent(WSRdbManagedConnectionImpl.java:993)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.closeWrapper(WSJdbcConnection.java:493)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.java:126)
at
com.nextjet.routing.util.DataBaseUtility.closeDBConnection(DataBaseUtility.java:53)
at
com.nextjet.routing.vendor.SimpleVendorScheduleDataSource.createVendors(SimpleVendorScheduleDataSource.java:451)
at
com.nextjet.routing.vendor.SimpleVendorScheduleDataSource.<init>(SimpleVendorScheduleDataSource.java:33)
at
com.nextjet.routing.vendor.VendorScheduleGenerator.generateSchedule(VendorScheduleGenerator.java:38)
at
com.nextjet.routing.schedule.MasterSchedule.reloadVendorScheduleGenerator(MasterSchedule.java:344)
at
com.nextjet.routing.schedule.MasterSchedule.loadVendorScheduleStartup(MasterSchedule.java:335)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
at java.lang.reflect.Method.invoke(Method.java:386)
at
com.nextjet.reflect.ReflectiveInvoker.invoke(ReflectiveInvoker.java:26)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
at java.lang.reflect.Method.invoke(Method.java:386)
at com.nextjet.proxy.AsyncProxy.run(AsyncProxy.java:111)
Any one have any ideas?
--
mdroth
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message182946.html