[CachedConnectionManager] Closing a connection for you. Plea

[ranjithpillai]

Hello,
My environment is Jboss-3.2.3 in HPUX.
I didn't understand the workaround discussed in the other thread for the same issue. 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

[adrian.brock]

Moderated: FAQ

[keanthian]

hi Ranjith,
I'm facing the same problem... did you found any solution? can you please share your solution with us? thanks

[ranjithpillai]

Sorry... didn't find a solution. Please share if you find some. I am working on something else now, may resume this after couple of weeks.
Ranjith Pillai

[keanthian]

hi Ranjith,
i had done some reading from JBoss just now, from what i understand. We hit
<<
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
>>
because we don't properly close our connection. This feature is provided by JBoss for us to track any connection leaking, we can choose to disable this option.

you can read more about this from http://www.jboss.org/wiki/Wiki.jsp?page=CreateAJDBCDataSource


By the way, do you mind post your source code on how to get the connection to database.

cheers..:-)