File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes Totally stuck , where to go now [Cannot open connection; javax.persistence.PersistenceException] Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Totally stuck , where to go now [Cannot open connection; javax.persistence.PersistenceException]" Watch "Totally stuck , where to go now [Cannot open connection; javax.persistence.PersistenceException]" New topic
Author

Totally stuck , where to go now [Cannot open connection; javax.persistence.PersistenceException]

shyam shridhar
Ranch Hand

Joined: Sep 15, 2006
Posts: 31
Hi,


I'm getting following connection error when I'm running my tomcat. I'm facing this problem since tomorrow afternoon...since then searching on google.. yet no luck.. Please help me

I'm using hibernate behind Jpa. Both persistence.xml and hibernate.cg.xml files are below for your consideration.

Error Message :-
...
Caused by: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: Cannot open connection; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:311)
at org.springframework.orm.jpa.aspectj.JpaExceptionTranslatorAspect.ajc$afterThrowing$org_springframework_orm_jpa_aspectj_JpaExceptionTranslatorAspect$1$18a1ac9(JpaExceptionTranslatorAspect.aj:15)
at com.iodinesoftware.rta.model.dao.impl.jpa.BaseJpaDao.findByQuery(BaseJpaDao.java:135)
at com.iodinesoftware.rta.model.impl.BaseServiceImpl.findByQuery(BaseServiceImpl.java:115)
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:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
at $Proxy47.findByQuery(Unknown Source)
at com.iodinesoftware.rta.security.authorization.RoleManagerImpl.getRole(RoleManagerImpl.java:80)
at com.iodinesoftware.rta.security.authorization.RoleManagerImpl.initialize(RoleManagerImpl.java:62)
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:597)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:340)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:293)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:130)
... 42 more
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1235)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1168)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:250)
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:597)
at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:310)
at $Proxy52.getResultList(Unknown Source)
... 60 more
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1596)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
at org.hibernate.loader.Loader.doList(Loader.java:2294)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2172)
at org.hibernate.loader.Loader.list(Loader.java:2167)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:448)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
... 66 more
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:78)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 80 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)
... 83 more
Apr 29, 2011 12:36:38 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Apr 29, 2011 12:36:38 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/rta-webclient] startup failed due to previous errors
Apr 29, 2011 12:36:38 PM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
Apr 29, 2011 12:36:38 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
SEVERE: The web application [/rta-webclient] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
Apr 29, 2011 12:36:38 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/rta-webclient] appears to have started a thread named [Dispatch-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@38a92aaa] but has failed to stop it. This is very likely to create a memory leak.
Apr 29, 2011 12:36:38 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/rta-webclient] appears to have started a thread named [Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@38a92aaa] but has failed to stop it. This is very likely to create a memory leak.
Apr 29, 2011 12:36:38 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/rta-webclient] appears to have started a thread named [Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@38a92aaa] but has failed to stop it. This is very likely to create a memory leak.
Apr 29, 2011 12:36:39 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Apr 29, 2011 12:36:39 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Apr 29, 2011 12:36:39 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/30 config=null
Apr 29, 2011 12:36:39 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 86771 ms
Exception in thread "Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@38a92aaa" Exception in thread "Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@38a92aaa" java.lang.NullPointerException
at com.mchange.v2.log.log4j.Log4jMLog$Log4jMLogger.isLoggable(Log4jMLog.java:255)
at com.mchange.v2.resourcepool.BasicResourcePool.decrementPendingAcquires(BasicResourcePool.java:421)
at com.mchange.v2.resourcepool.BasicResourcePool.access$900(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1887)
at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)
java.lang.NullPointerException
at com.mchange.v2.log.log4j.Log4jMLog$Log4jMLogger.isLoggable(Log4jMLog.java:255)
at com.mchange.v2.resourcepool.BasicResourcePool.decrementPendingAcquires(BasicResourcePool.java:421)
at com.mchange.v2.resourcepool.BasicResourcePool.access$900(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1887)
at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)




persistence.xml



hibernate.cfg.xml




-Shyam
Madhan Sundararajan Devaki
Ranch Hand

Joined: Mar 18, 2011
Posts: 312

Please list down the complete environment information. OS, JDK version, Application framework(s), MySQL, Hibernate, JPA, etc...


S.D. MADHAN
Not many get the right opportunity !
shyam shridhar
Ranch Hand

Joined: Sep 15, 2006
Posts: 31
Hi Madhan,

Followings are my system the env. details. Please let me know if you want any other information

OS : Windows 7
JDK : jdk 1.6.0_24
Eclipse Ide : Galilio (Helios Service Release 1)
Database : MySql Server 5.1
Maven2 : 2.2.1
Hibernate : 3.5.1-Final
JPA : 2.0-cr-1
Spring : 3.0.5.RELEASE
Server : Tomcat 6.0

Web application is part of multi module maven project. In a separate maven module junit test case are working fine

This problem sometimes came in the past also but resolved by commented/uncommented out c3p0 properties which is in hibernate.cfg.xml.

This time that solution is not working.


Thanks
-Shyam

shyam shridhar
Ranch Hand

Joined: Sep 15, 2006
Posts: 31
Hi,
My tomcat console showing following, might be helpful Thanks.

Madhan Sundararajan Devaki
Ranch Hand

Joined: Mar 18, 2011
Posts: 312

I believe it is high time you started using an JEE application server such as JBoss or GlassFish or WebLogic or Websphere. The reason being, you are using a JEE application framework but are using just a Servlet container server Tomcat. A JEE application server provides means to locate resources such as DB connection pools more reliably than a servlet container server.
shyam shridhar
Ranch Hand

Joined: Sep 15, 2006
Posts: 31
Thanks Madhan,

This is not a new existing project. Apart from that my current priority are different. After those I can discuss about moving to AS.

I appreciate if anybody help me to get out from this problem.


Thanks
-Shyam

shyam shridhar
Ranch Hand

Joined: Sep 15, 2006
Posts: 31
Oops I mean this is not a new project, an existing project.
shyam shridhar
Ranch Hand

Joined: Sep 15, 2006
Posts: 31
As the problem was on the my development machine, I have commented c3p0 in my hibernate.cfg.xml.
And now everything is working fine.



Thanks
-Shyam
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Totally stuck , where to go now [Cannot open connection; javax.persistence.PersistenceException]
 
Similar Threads
Spring Quartz Shutdown issue
I am connecting liferay communtiy edition 6.0.6 with postgresql 9.1 and using apache tomcat server6.
An attempt by a client to checkout a Connection has timed out.
jdbc connections not closing
Problems to connect to mysql with hibernate