Hello Adrian,
This is the behaviour that we are seeing:
1. Bring up the JBoss server
2. First two Session bean method invocation gives this error
a. First one is at:
2004-01-12 15:05:12,793 ERROR [STDERR] [ERROR]Connection handle is not
currently
associated with a ManagedConnection
2004-01-12 15:05:12,797 ERROR [STDERR] [Mon Jan 12 15:05:12 PST 2004][CALL
STACK
][6616830][java.sql.SQLException: Connection handle is not currently
associated
with a ManagedConnection
at
org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConn
ection.java:776)
at
org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(Wrappe
dConnection.java:206)
at com.plx.framework.sql.SQLProcessor.execute(SQLProcessor.java:241)
at
com.plx.efw.server.variable.VariableHelper.addValue(VariableHelper.java:3
68)
at
com.plx.efw.server.courier.CourierSessionBean.add(CourierSessionBean.java
:515)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
mpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(State
lessSessionContainer.java:683)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(C
achedConnectionInterceptor.java:185)
at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Stateles
sSessionInstanceInterceptor.java:72)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxIntercep
tor.java:84)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorC
MT.java:267)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java
:118)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFi
nderInterceptor.java:122)
b. Second one is at:
2004-01-12 15:05:13,618 ERROR [STDERR] [ERROR]Connection handle is not
currently
associated with a ManagedConnection
2004-01-12 15:05:13,622 ERROR [STDERR] [Mon Jan 12 15:05:13 PST 2004][CALL
STACK
][6616830][java.sql.SQLException: Connection handle is not currently
associated
with a ManagedConnection
at
org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConn
ection.java:776)
at
org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(Wrappe
dConnection.java:206)
at
com.plx.framework.sql.SQLProcessor.getResultSet(SQLProcessor.java:170)
at
com.plx.efw.server.courier.CourierSessionBean.getRuleSetName(CourierSessi
onBean.java:1597)
at
com.plx.efw.server.courier.CourierSessionBean.evaluateRuleSet(CourierSess
ionBean.java:1884)
at
com.plx.efw.server.courier.CourierSessionBean.add(CourierSessionBean.java
:558)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
mpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(State
lessSessionContainer.java:683)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(C
achedConnectionInterceptor.java:185)
at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Stateles
sSessionInstanceInterceptor.java:72)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxIntercep
tor.java:84)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorC
MT.java:267)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java
:118)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFi
nderInterceptor.java:122)
at
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionCo
ntainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:700)
at
org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFa
ctory.java:375)
at
org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSession
Proxy.java:83)
3. Rest all go fine..
The error does not re-appear until you re-start the server.
I looked through the code and could not find a reason why it should fail in
the first place.
Desperately looking for some help.
Thanks and Best Regards
MS
-----Original Message-----
From: Adrian Brock [mailto:[EMAIL PROTECTED]
Sent: Monday, January 12, 2004 9:55 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] JBoss 3.2.2/Oracle 9i - Connection handle is
not currently associ ated with a ManagedConnection (need some help)
This error message says you are trying to use a connection
that has being returned to the pool (the connection object you
get from the datasource is no longer associated with a real connection).
Regards,
Adrian
On Thu, 2004-01-08 at 20:50, Sasidharan, Manoj wrote:
> Hello All,
>
> We are trying to port our BEA Weblogic application to JBoss and are
> experiencing a new problem. The system gives the following exception. We
did
> review the code and could not see why this should happen.
>
> Any ideas or tips on what we should be looking for?
>
> Thanks in advance for your time and help.
>
> rgds
> MS
>
> 2003-12-29 19:29:43,313 WARN
> [org.jboss.resource.connectionmanager.TxConnectionManager] Prepare called
on
> a local tx. Use of local transactions on a jta transaction with more than
> one branch may result in inconsis
> tent data in some cases of failure.
> 2003-12-29 19:29:43,422 ERROR [STDERR] [Mon Dec 29 19:29:43 PST
> 2003][ERROR][9628012][Debug.java:333]: Connection handle is not currently
> associated with a ManagedConnection [SQL]: UPDATE test_tab_1
> SET str_1 = ? WHERE plx_courier_id = ?
> 2003-12-29 19:29:43,431 ERROR [STDERR] [ERROR]Connection handle is not
> currently associated with a ManagedConnection
> 2003-12-29 19:29:43,436 ERROR [STDERR] [Mon Dec 29 19:29:43 PST 2003][CALL
> STACK][9628012][java.sql.SQLException: Connection handle is not currently
> associated with a ManagedConnection at
>
org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnect
> ion.java:776)
> at
>
org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedCo
> nnection.java:206)
> at com.plx.framework.sql.SQLProcessor.execute(SQLProcessor.java:238)
> at
>
com.plx.efw.server.variable.VariableHelper.addValue(VariableHelper.java:365)
> at
>
com.plx.efw.server.courier.CourierSessionBean.add(CourierSessionBean.java:51
> 2)
> 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.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stateles
> sSessionContainer.java:683)
> at
>
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Cach
> edConnectionInterceptor.java:185)
> at
>
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSe
> ssionInstanceInterceptor.java:72)
> at
>
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor
> .java:84)
> at
>
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
> java:267)
> at
> org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
> at
>
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:11
> 8)
> at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
> at
>
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinde
> rInterceptor.java:122)
> at
>
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionConta
> iner.java:331)
> at
>
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionConta
> iner.java:331)
> at org.jboss.ejb.Container.invoke(Container.java:700)
> at
>
org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFacto
> ry.java:375)
> at
>
org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionPro
> xy.java:83)
> at $Proxy146.add(Unknown Source)
> at
>
com.plx.efw.common.command.CourierAddMapActSetCommand.executeCommand(Courier
> AddMapActSetCommand.java:154)
> at
> com.plx.efw.common.command.CourierCommand.execute(CourierCommand.java:70)
> at
>
com.plx.framework.command.CommandServer.executeCommand(CommandServer.java:91
> )
> at
> com.plx.framework.command.CommandServer.execute(CommandServer.java:66)
> at
>
com.plx.efw.server.command.EJBCommandServerBean.execute(EJBCommandServerBean
> .java:160)
> 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.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stateles
> sSessionContainer.java:683)
> at
>
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Cach
> edConnectionInterceptor.java:185)
> at
>
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSe
> ssionInstanceInterceptor.java:72)
> at
>
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor
> .java:84)
> at
>
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
> java:267)
> at
> org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
> at
>
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:11
> 8)
> at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
> at
>
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinde
> rInterceptor.java:122)
> at
>
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionConta
> iner.java:331)
> at org.jboss.ejb.Container.invoke(Container.java:700)
> at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
> at
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
> .java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at
>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispat
> cher.java:284)
> at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
> at
> org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:367)
> at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
> at
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
> .java:25)
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
--
xxxxxxxxxxxxxxxxxxxxxxxx
Adrian Brock
Director of Support
Back Office
JBoss Group, LLC
xxxxxxxxxxxxxxxxxxxxxxxx
-------------------------------------------------------
This SF.net email is sponsored by: Perforce Software.
Perforce is the Fast Software Configuration Management System offering
advanced branching capabilities and atomic changes on 50+ platforms.
Free Eval! http://www.perforce.com/perforce/loadprog.html
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
-------------------------------------------------------
This SF.net email is sponsored by: Perforce Software.
Perforce is the Fast Software Configuration Management System offering
advanced branching capabilities and atomic changes on 50+ platforms.
Free Eval! http://www.perforce.com/perforce/loadprog.html
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
