salut ;
je suis en cours de développement d'une application JEE , avec hibernate et mysql , en totale l'application fonctionne correctement sauf dans certaine jours elle me génère une erreur voici la portion du log :
Code:
-------------sessionCreated---------------2011-10-23 18:00:58
23 oct. 2011 18:05:37 org.apache.coyote.http11.Http11Protocol pause
INFO: Suspension de Coyote HTTP/1.1 sur http-8180
23 oct. 2011 18:05:38 org.apache.catalina.core.StandardService stop
INFO: Arrêt du service Catalina
-------------contextDestroyed---------------2011-10-23 18:05:38
23 oct. 2011 18:05:39 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 1 instance(s) to be deallocated
23 oct. 2011 18:05:40 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 1 instance(s) to be deallocated
23 oct. 2011 18:05:41 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 1 instance(s) to be deallocated
23 oct. 2011 18:05:41 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 6 instance(s) to be deallocated
23 oct. 2011 18:05:42 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 6 instance(s) to be deallocated
23 oct. 2011 18:05:43 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 6 instance(s) to be deallocated
23 oct. 2011 18:05:43 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 6 instance(s) to be deallocated
23 oct. 2011 18:05:45 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 6 instance(s) to be deallocated
23 oct. 2011 18:05:46 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 6 instance(s) to be deallocated
23 oct. 2011 18:05:46 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 1 instance(s) to be deallocated
23 oct. 2011 18:05:47 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 1 instance(s) to be deallocated
23 oct. 2011 18:05:48 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 1 instance(s) to be deallocated
23 oct. 2011 18:05:48 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 6 instance(s) to be deallocated
23 oct. 2011 18:05:49 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 6 instance(s) to be deallocated
23 oct. 2011 18:05:50 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 6 instance(s) to be deallocated
23 oct. 2011 18:05:50 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 1 instance(s) to be deallocated
23 oct. 2011 18:05:51 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 1 instance(s) to be deallocated
23 oct. 2011 18:05:52 org.apache.catalina.core.StandardWrapper unload
INFO: Waiting for 1 instance(s) to be deallocated
-------------contextDestroyed---------------2011-10-23 18:05:52
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
at big.commun.data.BigObjet.getSession(BigObjet.java:1838)
at big.commun.auth.BigAuth.getSession(BigAuth.java:73)
at big.commun.auth.BigAuth.SelectUserPermission(BigAuth.java:147)
at big.commun.auth.BigAuthAction.processRequest(BigAuthAction.java:58)
at auth.AuthAction.processRequest(AuthAction.java:22)
at big.commun.data.BigActionServer.doPost(BigActionServer.java:251)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
... 24 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
... 27 more
3 août 2011 12:51:18 org.apache.catalina.core.StandardContext reload
INFO: Le rechargement de ce contexte a démarré
Moi je pense que la session de hibernate essaye de connecter à la base de doonée alors que contnaire de Tomcat est arrêté .J'ai voulu provoquer l'erreur mais sans succès .
Si vous pouvez m’éclairer le cas svp ..
merci