Hi,
We have exactly the same problem. We are using oc4j and toplink essential. EJB3 query query.getResultList() hangs up forever unless the container is bounced. As you said the issue is hard to duplicate but it happens a few of times. I wonder if you find the solution to this proble. Thanks in advance.
Scott
The stact trace is below:
Stack trace:
java.lang.Thread.sleep(Native Method)
oracle.toplink.essentials.internal.helper.ConcurrencyManager.releaseDeferredLock(ConcurrencyManager.java:414)
oracle.toplink.essentials.internal.identitymaps.CacheKey.releaseDeferredLock(CacheKey.java:332)
oracle.toplink.essentials.internal.descriptors.ObjectBuilder.buildObject(ObjectBuilder.java:599)
oracle.toplink.essentials.internal.descriptors.ObjectBuilder.buildWorkingCopyCloneNormally(ObjectBuilder.java:436)
oracle.toplink.essentials.internal.descriptors.ObjectBuilder.buildObjectInUnitOfWork(ObjectBuilder.java:406)
oracle.toplink.essentials.internal.descriptors.ObjectBuilder.buildObject(ObjectBuilder.java:372)
oracle.toplink.essentials.queryframework.ReportQueryResult.processItem(ReportQueryResult.java:205)
oracle.toplink.essentials.queryframework.ReportQueryResult.buildResult(ReportQueryResult.java:167)
oracle.toplink.essentials.queryframework.ReportQueryResult.<init>(ReportQueryResult.java:83)
oracle.toplink.essentials.queryframework.ReportQuery.buildObject(ReportQuery.java:579)
oracle.toplink.essentials.queryframework.ReportQuery.buildObjects(ReportQuery.java:628)
oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuery(ReportQuery.java:776)
oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2218)
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:346)
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:447)
com.evermind.server.ejb.persistence.NonTransactionalQuery.getResultList(NonTransactionalQuery.java:37)
gov.nih.rcdc.beantier.dashboard.session.DCProcessSessionBean.getAllCategories(DCProcessSessionBean.java:299)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
com.evermind.server.ejb.interceptor.joinpoint.EJBJoinPointImpl.invoke(EJBJoinPointImpl.java:35)
com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
com.evermind.server.ejb.interceptor.system.SetContextActionInterceptor.invoke(SetContextActionInterceptor.java:44)
com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
com.evermind.server.ejb.interceptor.system.TxSupportsInterceptor.invoke(TxSupportsInterceptor.java:37)
com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
com.evermind.server.ejb.InvocationContextPool.invoke(InvocationContextPool.java:55)
com.evermind.server.ejb.StatelessSessionEJBObject.OC4J_invokeMethod(StatelessSessionEJBObject.java:87)
DCProcessSession_LocalProxy_53ho591.getAllCategories(Unknown Source)
gov.nih.rcdc.beantier.dashboard.DCProcessServiceAdapter.getAllCategories(DCProcessServiceAdapter.java:233)
gov.nih.rcdc.webtier.actions.admin.dashboard.DashboardAdminImpl.getAllCategories(DashboardAdminImpl.java:160)
gov.nih.rcdc.webtier.actions.admin.dashboard.DashboardAdminImpl.init(DashboardAdminImpl.java:56)
gov.nih.rcdc.webtier.actions.admin.dashboard.DashboardAdminAction.init(DashboardAdminAction.java:109)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
gov.nih.rcdc.webtier.actions.KmdcDispatchAction.dispatchMethod(KmdcDispatchAction.java:243)
gov.nih.rcdc.webtier.actions.KmdcLookupDispatchAction.perform(KmdcLookupDispatchAction.java:147)
gov.nih.rcdc.webtier.actions.KmdcAction.perform(KmdcAction.java:82)
gov.nih.framework.webtier.actions.EraAction.execute(EraAction.java:122)
gov.nih.rcdc.webtier.actions.KmdcAction.execute(KmdcAction.java:49)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
gov.nih.rcdc.webtier.KMDCRequestProcessor.process(KMDCRequestProcessor.java:73)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
gov.nih.rcdc.webtier.filters.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:86)
com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
gov.nih.framework.webtier.filters.SingleSignOnFixLogoutFilter.doFilter(SingleSignOnFixLogoutFilter.java:64)
com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
oracle.security.jazn.oc4j.JAZNFilter.doFilter(JAZNFilter.java:436)
com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:619)
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
java.lang.Thread.run(Thread.java:595)
[Message sent by forum member 'yuzhe' (yuzhe)]
http://forums.java.net/jive/thread.jspa?messageID=342305