Problema no usao de C3p0

0 respostas
jupysilva

Galera tenho um problema com um projeto aqui. Estou recebendo o seguinte exception:

com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool
	at com.mchange.v2.resourcepool.BasicResourcePool.ensureNotBroken(BasicResourcePool.java:920)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:191)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:170)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:172)
	at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:58)
	at net.sf.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:33)
	at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:289)
	at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3361)
	at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3321)
	at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:66)
	at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:779)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:265)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
	at net.sf.hibernate.loader.Loader.list(Loader.java:1024)
	at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
	at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1553)
	at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1530)
	at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1522)
	at mx.com.prosa.bdu.eai.common.GeneralDAO.listar(GeneralDAO.java:160)
	at mx.com.prosa.bdu.eai.seguridad.UsuarioDAO.listar(UsuarioDAO.java:78)
	at mx.com.prosa.bdu.dmn.seguridad.permiso.Permisos.recuperarPermisos(Permisos.java:157)
	at mx.com.prosa.bdu.dmn.seguridad.permiso.Permisos.cargar(Permisos.java:91)
	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:592)
	at mx.com.prosa.bdu.app.proceso.BusinessProcess.ejecutar(BusinessProcess.java:58)
	at mx.com.prosa.bdu.app.proceso.BusinessProcess.execute(BusinessProcess.java:88)
	at sun.reflect.GeneratedMethodAccessor601.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:592)
	at com.sun.enterprise.security.SecurityUtil$2.run(SecurityUtil.java:181)
	at java.security.AccessController.doPrivileged(Native Method)
	at com.sun.enterprise.security.application.EJBSecurityManager.doAsPrivileged(EJBSecurityManager.java:985)
	at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:186)
	at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2928)
	at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4019)
	at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:203)
	at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:120)
	at $Proxy194.execute(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor600.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:592)
	at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.privateInvoke(StubInvocationHandlerImpl.java:233)
	at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.invoke(StubInvocationHandlerImpl.java:152)
	at com.sun.corba.ee.impl.presentation.rmi.bcel.BCELStubBase.invoke(BCELStubBase.java:225)
	at mx.com.prosa.bdu.app.seguridad.manager._SeguridadManager_DynamicStub.execute(mx/com/prosa/bdu/app/seguridad/manager/_SeguridadManager_DynamicStub.java)
	at mx.com.prosa.bdu.app.seguridad.facade.SeguridadFacadeEJB.procesarComandoNoIdempotente(SeguridadFacadeEJB.java:266)
	at mx.com.prosa.bdu.app.seguridad.facade.SeguridadFacadeEJB.cargar(SeguridadFacadeEJB.java:214)
	at sun.reflect.GeneratedMethodAccessor989.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:592)
	at com.sun.enterprise.security.SecurityUtil$2.run(SecurityUtil.java:181)
	at java.security.AccessController.doPrivileged(Native Method)
	at com.sun.enterprise.security.application.EJBSecurityManager.doAsPrivileged(EJBSecurityManager.java:985)
	at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:186)
	at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2928)
	at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4019)
	at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:203)
	at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:120)
	at $Proxy158.cargar(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor599.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:592)
	at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.privateInvoke(StubInvocationHandlerImpl.java:233)
	at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.invoke(StubInvocationHandlerImpl.java:152)
	at com.sun.corba.ee.impl.presentation.rmi.bcel.BCELStubBase.invoke(BCELStubBase.java:225)
	at mx.com.prosa.bdu.app.seguridad.facade._SeguridadFacade_DynamicStub.cargar(mx/com/prosa/bdu/app/seguridad/facade/_SeguridadFacade_DynamicStub.java)
	at mx.com.prosa.bdu.gui.mantenimiento.seguridad.delegate.SeguridadDelegate.cargar(SeguridadDelegate.java:35)
	at mx.com.prosa.bdu.gui.acceso.action.AccesoAction.recuperarPermisos(AccesoAction.java:381)
	at mx.com.prosa.bdu.gui.acceso.action.AccesoAction.entrada(AccesoAction.java:163)
	at sun.reflect.GeneratedMethodAccessor973.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:592)
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
	at sun.reflect.GeneratedMethodAccessor271.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:592)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:292)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:325)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:208)
	at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:420)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:333)
	at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:91)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:197)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
	at mx.com.prosa.bdu.gui.common.BDUAuthorizationFilter.doFilter(BDUAuthorizationFilter.java:165)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFi|#]

Alguem pode me ajudar?

[]s

Jupy

Criado 15 de junho de 2010
Respostas 0
Participantes 1