-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: Traboules with tocate and Hibernate sessions
PostPosted: Tue Nov 15, 2011 10:59 am 
Newbie

Joined: Mon Nov 14, 2011 4:37 am
Posts: 3
Hi ;
I am currently developing a JEE application with hibernate and mysql, in total the application works correctly except some days it generates an error this is the portion of the 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é


I think that hibernate session tries to connect to the database while a Tomcat container is stopped. I wanted to cause the error but without success.

If you can enlighten me please ..

thank you


Top
 Profile  
 
 Post subject: Re: Traboules with tocate and Hibernate sessions
PostPosted: Wed Nov 23, 2011 3:48 am 
Newbie

Joined: Wed Nov 23, 2011 3:05 am
Posts: 3
check your jdbc.url

_________________
上帝啊,带我走吧。


Top
 Profile  
 
 Post subject: Re: Traboules with tocate and Hibernate sessions
PostPosted: Wed Nov 23, 2011 5:23 pm 
Newbie

Joined: Mon Nov 14, 2011 4:37 am
Posts: 3
shenliuyang wrote:
check your jdbc.url

thanks for your response .
I read my jdbc.url from promerties file , this error is declenched in the end of a day at this time I try to resolve it .


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.