Closing a connection for you. Please close them yourself:

[cboucher]

I do not understand why I am getting the following exceptions.

I am using JBoss4.0RC1 with j2sdk1.4.1_03 on Windows XP. The code works fine with JBoss 3.0.4.

Code logic:

MDB
{
EJB = GetEJB();
EJB.doDataBaseStuff();
{
DS = GetDataSource();
Conn = DS.getConnection();
Conn.executeSQL();
Conn.close();
}
}

EJB is a stateless session bean with requires a Transaction.

13:39:48,760 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@1d18707
java.lang.Exception: STACKTRACE
at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:322)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:477)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:838)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
at com.appiq.service.system.database.ConnectionMgr.createConnection(ConnectionMgr.java:101)
at com.appiq.service.system.database.ConnectionMgr.createConnection(ConnectionMgr.java:59)
at com.appiq.service.base.BaseSessionBean.createConnection(BaseSessionBean.java:91)
at com.appiq.service.system.cmdProcessor.CmdProcessorBean.execute(CmdProcessorBean.java:161)
at com.appiq.service.system.cmdProcessor.CmdProcessorBean.execute(CmdProcessorBean.java:265)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:113)
at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:316)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:149)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:625)
at org.jboss.ejb.Container.invoke(Container.java:871)
at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:230)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
at $Proxy60.execute(Unknown Source)
at com.appiq.service.system.scheduler.SchedulerTask.updateSchedule(SchedulerTask.java:219)
at com.appiq.service.system.scheduler.SchedulerTask.run(SchedulerTask.java:100)
at java.util.TimerThread.mainLoop(Timer.java:432)
at java.util.TimerThread.run(Timer.java:382)
13:39:48,792 ERROR [TxConnectionManager] Error while closing connection handle!
org.jboss.resource.JBossResourceException: Error in delist!; - nested throwable: (java.lang.IllegalStateException: Already rolled back. TransactionImpl:XidImpl[FormatId=257, GlobalId=cboucher3/57, BranchQual=, localId=57])
at org.jboss.resource.connectionmanager.BaseConnectionManager2.rethrowAsResourceException(BaseConnectionManager2.java:102)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.delist(TxConnectionManager.java:481)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed(TxConnectionManager.java:519)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:300)
at org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:116)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.resource.connectionmanager.CachedConnectionManager.closeConnection(CachedConnectionManager.java:551)
at org.jboss.resource.connectionmanager.CachedConnectionManager.access$000(CachedConnectionManager.java:51)
at org.jboss.resource.connectionmanager.CachedConnectionManager$CloseConnectionSynchronization.afterCompletion(CachedConnectionManager.java:623)
at org.jboss.tm.TransactionImpl.doAfterCompletion(TransactionImpl.java:1418)
at org.jboss.tm.TransactionImpl.completeTransaction(TransactionImpl.java:1090)
at org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:385)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:449)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:325)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:149)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:625)
at org.jboss.ejb.Container.invoke(Container.java:871)
at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:230)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
at $Proxy60.execute(Unknown Source)
at com.appiq.service.system.scheduler.SchedulerTask.updateSchedule(SchedulerTask.java:219)
at com.appiq.service.system.scheduler.SchedulerTask.run(SchedulerTask.java:100)
at java.util.TimerThread.mainLoop(Timer.java:432)
at java.util.TimerThread.run(Timer.java:382)
Caused by: java.lang.IllegalStateException: Already rolled back. TransactionImpl:XidImpl[FormatId=257, GlobalId=cboucher3/57, BranchQual=, localId=57]
at org.jboss.tm.TransactionImpl.delistResource(TransactionImpl.java:446)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.delist(TxConnectionManager.java:474)
... 40 more
13:39:48,823 ERROR [LogInterceptor] RuntimeException in method: public abstract com.appiq.dbCommands.DBUpdateCommand com.appiq.service.system.cmdProcessor.CmdProcessor.execute(com.appiq.dbCommands.DBUpdateCommand) throws java.rmi.RemoteException,com.appiq.dataModel.exceptions.DataModelException,jav
.sql.SQLException:
java.util.ConcurrentModificationException
at java.util.HashMap$HashIterator.nextEntry(HashMap.java:762)
at java.util.HashMap$EntryIterator.next(HashMap.java:804)
at org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:97)
at com.appiq.service.system.cmdProcessor.CmdProcessorBean.execute(CmdProcessorBean.java:212)
at com.appiq.service.system.cmdProcessor.CmdProcessorBean.execute(CmdProcessorBean.java:265)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:113)
at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:316)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:149)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:625)
at org.jboss.ejb.Container.invoke(Container.java:871)
at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:230)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
at $Proxy60.execute(Unknown Source)
at com.appiq.service.system.scheduler.SchedulerTask.updateSchedule(SchedulerTask.java:219)
at com.appiq.service.system.scheduler.SchedulerTask.run(SchedulerTask.java:100)
at java.util.TimerThread.mainLoop(Timer.java:432)
at java.util.TimerThread.run(Timer.java:382)
13:39:48,870 INFO [STDOUT] java.rmi.ServerException: RuntimeException; nested exception is:
java.util.ConcurrentModificationException
13:39:48,870 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.handleException(LogInterceptor.java:361)
13:39:48,870 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
13:39:48,870 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
13:39:48,901 INFO [STDOUT] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:625)
13:39:48,901 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:871)
13:39:48,901 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)
13:39:48,901 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
13:39:48,901 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
13:39:48,901 INFO [STDOUT] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
13:39:48,901 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
13:39:48,901 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
13:39:48,901 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:230)
13:39:48,901 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
13:39:48,901 INFO [STDOUT] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
13:39:48,901 INFO [STDOUT] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
13:39:48,901 INFO [STDOUT] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
13:39:48,901 INFO [STDOUT] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
13:39:48,901 INFO [STDOUT] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97)
13:39:48,901 INFO [STDOUT] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
13:39:48,901 INFO [STDOUT] at $Proxy60.execute(Unknown Source)
13:39:48,901 INFO [STDOUT] at com.appiq.service.system.scheduler.SchedulerTask.updateSchedule(SchedulerTask.java:219)
13:39:48,901 INFO [STDOUT] at com.appiq.service.system.scheduler.SchedulerTask.run(SchedulerTask.java:100)
13:39:48,901 INFO [STDOUT] at java.util.TimerThread.mainLoop(Timer.java:432)
13:39:48,901 INFO [STDOUT] at java.util.TimerThread.run(Timer.java:382)
13:39:48,901 INFO [STDOUT] Caused by: java.util.ConcurrentModificationException
13:39:48,901 INFO [STDOUT] at java.util.HashMap$HashIterator.nextEntry(HashMap.java:762)
13:39:48,901 INFO [STDOUT] at java.util.HashMap$EntryIterator.next(HashMap.java:804)
13:39:48,901 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:97)
13:39:48,901 INFO [STDOUT] at com.appiq.service.system.cmdProcessor.CmdProcessorBean.execute(CmdProcessorBean.java:212)
13:39:48,901 INFO [STDOUT] at com.appiq.service.system.cmdProcessor.CmdProcessorBean.execute(CmdProcessorBean.java:265)
13:39:48,901 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
13:39:48,901 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
13:39:48,901 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
13:39:48,901 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
13:39:48,901 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
13:39:48,901 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
13:39:48,901 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
13:39:48,901 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:113)
13:39:48,901 INFO [STDOUT] at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51)
13:39:48,932 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
13:39:48,932 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
13:39:48,932 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:316)
13:39:48,932 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:149)
13:39:48,932 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128)
13:39:48,932 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
13:39:48,932 INFO [STDOUT] ... 22 more


Chad

[adrian.brock]

That's because 3.0.4 didn't check for unclosed statements.

The CCME has already been fixed.

[cboucher]

Is there going to be a RC2 that has the ConcurrentModificationException fix in it?

Chad

[adrian.brock]

I don't know. The main release is due out in a couple of weeks.

If you want the old behaviour just add to your -ds.xml
<track-statements>false</track-statements>

But then you leak statements, see the FAQ.

[cboucher]

Thanks,

This should hold me over until the release comes out then I can remove the <track-statements>false</track-statements> code.

Chad

[ranjithpillai]

Hello,
My environment is Jboss-3.2.3 in HPUX.
I didn't understand the workaround discussed above. I guess after I call my connection factory.getConnection() and before I call my connection.close(), JBoss is closing the connection and throwing out these exceptions. If anyone could shed some light, I will deeply appreciate that.

Here are the exceptions:

16:45:02,769 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: com.sap.mw.jco.jra.JRA$ConnectionImpl@1c4eb
java.lang.Exception: STACKTRACE
at org.jboss.resource.connectionmanager.CachedConnectionManager.register
Connection(CachedConnectionManager.java:282)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
onnection(BaseConnectionManager2.java:506)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
nManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
at com.sap.mw.jco.jra.JRA$ConnectionFactoryImpl.getConnection(Unknown So
urce)
at com.sap.mw.jco.jra.JRA$ConnectionFactoryImpl.getConnection(Unknown So
urce)
at com.hp.globalops.ssa.plugin.erp.sap.internal.ManagedConnectionFactory
.getConnection(ManagedConnectionFactory.java:29)
at com.hp.globalops.ssa.plugin.erp.sap.internal.SAPAdapterLite.createInt
eraction(SAPAdapterLite.java:126)
at com.hp.globalops.ssa.plugin.erp.sap.internal.SAPAdapterLite.execute(S
APAdapterLite.java:110)
at com.hp.globalops.ssa.plugin.erp.sap.internal.SAPAdapterLite.invokeSer
vice(SAPAdapterLite.java:59)
at com.hp.globalops.ssa.plugin.erp.sap.dl.SAPAdapterDLBean.invokeService
(SAPAdapterDLBean.java:54)
at java.lang.reflect.Method.invoke(Native Method)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(S
tatelessSessionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo
ke(CachedConnectionInterceptor.java:185)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Stat
elessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInte
rceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep
torCMT.java:267)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:1
28)

Thanks,
Ranjith Pillai

[busjive]

I'm running 4.0.0RC2(200408271540) on the same project Chad's working on, and I'm getting Oracle cursor leaks. We do not have statement tracing disabled. Are there any known issues here?

Ken