Pessoal, estou usando o vraptor com mysql e hibernate e quando coloco em um servidor(container é o tomcat) que temos para homologar na empresa onde trabalho, após algum tempo sem usar à aplicação acontece o seguinte erro.
com.mysql.jdbc.exceptions.jdbc4.MySqlNonTransientConnectionException. No operations allowed after connection closed. Connection was implicity closed by the driver
mude esses valores pro que fizer mais sentido na sua aplicação…
existem mais configurações possíveis, dá uma pesquisada
adriano.caldeira
Valeu Lucas.
leonardofl
Olá!
Eu estou com o mesmo problema e tentei fazer oq vc disse, mas sem sucesso.
Baixei o c3po em http://sourceforge.net/projects/c3p0/, copiei os três jars pro web-inf/lib do meu projeto e ao iniciar o tomcat obtive o seguinte erro:
O stack trace anexo é do meu erro em deploy, sem tentar usar o c3po…
tentando usar o c3po conforme vc disse:
SEVERE:WSSERVLET11:failedtoparseruntimedescriptor:org.hibernate.HibernateException:Couldnotinstantiateconnectionprovider:org.hibernate.connection.C3P0ConnectionProvider"org.hibernate.HibernateException: Could not instantiate connection provider: org.hibernate.connection.C3P0ConnectionProvider"atorg.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:100)atorg.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:79)atorg.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:425)atorg.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:89)atorg.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119)atorg.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115)atorg.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339)atorg.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)atbr.usp.wikilibras.ws.SignDictionaryWS.<init>(SignDictionaryWS.java:24)atsun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod)atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)atjava.lang.reflect.Constructor.newInstance(Constructor.java:532)atjava.lang.Class.newInstance0(Class.java:372)atjava.lang.Class.newInstance(Class.java:325)atcom.sun.xml.ws.api.server.InstanceResolver.createNewInstance(InstanceResolver.java:215)atcom.sun.xml.ws.api.server.InstanceResolver.createDefault(InstanceResolver.java:180)atcom.sun.xml.ws.server.EndpointFactory.createEndpoint(EndpointFactory.java:123)atcom.sun.xml.ws.api.server.WSEndpoint.create(WSEndpoint.java:467)atcom.sun.xml.ws.transport.http.DeploymentDescriptorParser.parseAdapters(DeploymentDescriptorParser.java:253)atcom.sun.xml.ws.transport.http.DeploymentDescriptorParser.parse(DeploymentDescriptorParser.java:147)atcom.sun.xml.ws.transport.http.servlet.WSServletContextListener.contextInitialized(WSServletContextListener.java:108)atorg.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)atorg.apache.catalina.core.StandardContext.start(StandardContext.java:4630)atorg.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)atorg.apache.catalina.core.StandardHost.start(StandardHost.java:785)atorg.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)atorg.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)atorg.apache.catalina.core.StandardService.start(StandardService.java:519)atorg.apache.catalina.core.StandardServer.start(StandardServer.java:710)atorg.apache.catalina.startup.Catalina.start(Catalina.java:581)atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)atjava.lang.reflect.Method.invoke(Method.java:616)atorg.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)atorg.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)02/11/201012:56:45org.apache.catalina.core.StandardContextlistenerStartSEVERE:Exceptionsendingcontextinitializedeventtolistenerinstanceofclasscom.sun.xml.ws.transport.http.servlet.WSServletContextListenercom.sun.xml.ws.transport.http.servlet.WSServletException:WSSERVLET11:failedtoparseruntimedescriptor:org.hibernate.HibernateException:Couldnotinstantiateconnectionprovider:org.hibernate.connection.C3P0ConnectionProvider" at com.sun.xml.ws.transport.http.servlet.WSServletContextListener.contextInitialized(WSServletContextListener.java:118) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:785) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445) at org.apache.catalina.core.StandardService.start(StandardService.java:519) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:581) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)Caused by: org.hibernate.HibernateException: Could not instantiate connection provider: org.hibernate.connection.C3P0ConnectionProvider"atorg.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:100)atorg.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:79)atorg.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:425)atorg.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:89)atorg.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119)atorg.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115)atorg.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339)atorg.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)atbr.usp.wikilibras.ws.SignDictionaryWS.<init>(SignDictionaryWS.java:24)atsun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod)atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)atjava.lang.reflect.Constructor.newInstance(Constructor.java:532)atjava.lang.Class.newInstance0(Class.java:372)atjava.lang.Class.newInstance(Class.java:325)atcom.sun.xml.ws.api.server.InstanceResolver.createNewInstance(InstanceResolver.java:215)atcom.sun.xml.ws.api.server.InstanceResolver.createDefault(InstanceResolver.java:180)atcom.sun.xml.ws.server.EndpointFactory.createEndpoint(EndpointFactory.java:123)atcom.sun.xml.ws.api.server.WSEndpoint.create(WSEndpoint.java:467)atcom.sun.xml.ws.transport.http.DeploymentDescriptorParser.parseAdapters(DeploymentDescriptorParser.java:253)atcom.sun.xml.ws.transport.http.DeploymentDescriptorParser.parse(DeploymentDescriptorParser.java:147)atcom.sun.xml.ws.transport.http.servlet.WSServletContextListener.contextInitialized(WSServletContextListener.java:108)...15more
leonardofl
putz, agora q eu vi…
tinha uma aspa a mais no nome da classe