* Hi, i am working for a project which need to call the stateless session
bean (EJB) to receive data from DB in a JSP page.
*
*But for sometime, whne i visit this JSP page, it throw a HTTP ERROR 500
message, and the detail log*
javax.resource.ResourceException: This Managed Connection is not valid as the
phyiscal connection is not usable
at com.sun.gjc.spi.ManagedConnection.checkIfValid(ManagedConnection.java:612)
at
com.sun.gjc.spi.ManagedConnection.getLocalTransaction(ManagedConnection.java:398)
at
com.sun.enterprise.resource.ConnectorXAResource.getResourceHandle(ConnectorXAResource.java:232)
at
com.sun.enterprise.resource.ConnectorXAResource.start(ConnectorXAResource.java:124)
at
com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.enlistResource(J2EETransactionManagerOpt.java:159)
at
com.sun.enterprise.distributedtx.J2EETransactionManagerImpl.enlistComponentResources(J2EETransactionManagerImpl.java:563)
at
com.sun.enterprise.distributedtx.J2EETransactionManagerImpl.enlistComponentResources(J2EETransactionManagerImpl.java:404)
at com.sun.ejb.containers.BaseContainer.startNewTx(BaseContainer.java:3384)
at com.sun.ejb.containers.BaseContainer.preInvokeTx(BaseContainer.java:3304)
at com.sun.ejb.containers.BaseContainer.preInvoke(BaseContainer.java:1253)
at
com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:202)
at
com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke(EJBObjectInvocationHandlerDelegate.java:117)
at $Proxy26.getReportParm(Unknown Source)
at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:154)
at
com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:687)
at
com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:227)
at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1846)
at
com.sun.corba.ee.impl.protocol.SharedCDRClientRequestDispatcherImpl.marshalingComplete(SharedCDRClientRequestDispatcherImpl.java:183)
at
com.sun.corba.ee.impl.protocol.CorbaClientDelegateImpl.invoke(CorbaClientDelegateImpl.java:222)
at
com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.privateInvoke(StubInvocationHandlerImpl.java:192)
at
com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.invoke(StubInvocationHandlerImpl.java:152)
..................
*But once i refresh the page, the JSP work properly without the HTTP 500
ERROR . Then if the page idle for sometime, the ERROR comes out again.
*
*Following are the setting of my connection pool
*
*Initial and minimum pool size = 8
*
*max pool size = 8
*
*pool resize quantity = 2
*
*idle timeout = 300s
*
*Max wait time = 60000milliseconds
*
*connection validation = required
*
*validation method = table
*
*table name = sys.sysobjects
*
*on any failure = true
*
*Others are default*
*...............searched but seems not one could provide a solution. Thanks
if anyone can help.*
--
[Message sent by forum member 'rob1213']
View Post: http://forums.java.net/node/789028