Need help handling this exception

[nvish]

Hello everyone,

Here is the complete trace of the exception. I am using DBCP connection pool and looks like there is something wrong. Has anyone faced a similar problem.

Exception : java.lang.IllegalStateException: Pool not open
at org.apache.commons.pool.BaseObjectPool.assertOpen( BaseObjectPool.java:123)
at org.apache.commons.pool.impl.GenericObjectPool.bor rowObject(GenericObjectPool.java:767)
at org.apache.commons.dbcp.PoolingDataSource.getConne ction(PoolingDataSource.java:140)
at org.apache.commons.dbcp.BasicDataSource.getConnect ion(BasicDataSource.java:518)
at org.springframework.orm.hibernate.LocalDataSourceC onnectionProvider.getConnection(LocalDataSourceCon nectionProvider.java:65)
at net.sf.hibernate.impl.BatcherImpl.openConnection(B atcherImpl.java:278)
at net.sf.hibernate.impl.SessionImpl.connect(SessionI mpl.java:3264)
at net.sf.hibernate.impl.SessionImpl.connection(Sessi onImpl.java:3244)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStat ement(BatcherImpl.java:65)
at net.sf.hibernate.loader.Loader.prepareQueryStateme nt(Loader.java:704)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java :185)
at net.sf.hibernate.loader.Loader.doQueryAndInitializ eNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java: 950)
at net.sf.hibernate.loader.Loader.list(Loader.java:94 1)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTra nslator.java:834)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl .java:1512)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.jav a:39)
at org.springframework.orm.hibernate.HibernateTemplat e$23.doInHibernate(HibernateTemplate.java:402)
at org.springframework.orm.hibernate.HibernateTemplat e.execute(HibernateTemplate.java:150)
at org.springframework.orm.hibernate.HibernateTemplat e.executeFind(HibernateTemplate.java:170)
at org.springframework.orm.hibernate.HibernateTemplat e.findByNamedQuery(HibernateTemplate.java:399)
at com.dcx.mpi.mdvs.persistance.hibernateimpl._Hibern ateBaseDao.getAll(_HibernateBaseDao.java:38)
at java.lang.reflect.Method.invoke(Native Method)
at org.springframework.aop.framework.AopProxyUtils.in vokeJoinpointUsingReflection(AopProxyUtils.java:59 )
at org.springframework.aop.framework.ReflectiveMethod Invocation.invokeJoinpoint(ReflectiveMethodInvocat ion.java:149)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :118)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.invoke(TransactionInterceptor.jav a:169)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :138)
at org.springframework.aop.framework.JdkDynamicAopPro xy.invoke(JdkDynamicAopProxy.java:148)
at $Proxy4.getAll(Unknown Source)
at com.dcx.mpi.mdvs.biz.facade._BaseFacade.findAll(_B aseFacade.java:89)
at com.dcx.mpi.mdvs.web.action.DocumentAction.initiat eTransaction(DocumentAction.java:449)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.struts.actions.DispatchAction.dispatchM ethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(D ispatchAction.java:216)
at org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(Actio nServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.ServicingServletSt ate.service(StrictLifecycleServlet.java:333)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:76)
at org.springframework.orm.hibernate.support.OpenSess ionInViewFilter.doFilterInternal(OpenSessionInView Filter.java:117)
at org.springframework.web.filter.OncePerRequestFilte r.doFilter(OncePerRequestFilter.java:73)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapp er.doFilter(FilterInstanceWrapper.java:132)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:71)
at com.dcx.mpi.mdvs.web.filter.AuthenticationFilter.d oFilter(AuthenticationFilter.java:224)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapp er.doFilter(FilterInstanceWrapper.java:132)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:71)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:1064)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:598)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:206)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForwar d(WebAppInvoker.java:80)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleIn vocationHook(WebAppInvoker.java:214)
at com.ibm.ws.webcontainer.cache.invocation.CachedInv ocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.Cacheable InvocationContext.invoke(CacheableInvocationContex t.java:116)
at com.ibm.ws.webcontainer.srp.ServletRequestProcesso r.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDis patcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handle Request(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleReques t(HttpConnection.java:623)
at com.ibm.ws.http.HttpConnection.run(HttpConnection. java:457)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:672)

[karthi103]

It might be that your are not closing the session after opening it .
You might be using session.openSession() ,instead of session.getCurrentSession().
If you are using session.OpenSession(),then it seems we must explicitly close it .

Karthik

[karldmoore]

Have you tried searching for this, seems to be brought up a few times. The existing threads might be useful.
http://forum.springframework.org/showthread.php?t=14449