0 Replies Latest reply on Aug 23, 2012 2:56 PM by srinivas neeluri

    Getting "org.hibernate.exception.GenericJDBCException: Cannot open connection"

    srinivas neeluri Newbie

      Hello Friends,

      i am getting below Error very frequently and need your help/suggestion to fix this.

       

      2012-08-23 16:47:24,763 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null

      2012-08-23 16:47:24,763 ERROR [JDBCExceptionReporter] Transaction is not active: tx=TransactionImple < ac, BasicAction: 3f969e4:9f33:50337907:15c013 status: ActionStatu

      s.ABORTED >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 3f969e4:9f33:50337907:15c013 statu

      s: ActionStatus.ABORTED >)

      2012-08-23 16:47:25,857 INFO  [DefaultLoadEventListener] Error performing load command

      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.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)

              at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)

              at org.hibernate.loader.Loader.doQuery(Loader.java:673)

              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)

              at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)

              at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)

              at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)

              at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3042)

              at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)

              at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)

              at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)

              at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)

              at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)

              at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)

              at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)

              at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)

              at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:214)

              at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:184)

              at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:81)

              at $Proxy142.getEvent(Unknown Source)

              at com.ge.med.service.vasc.pds.event.DiagnosticJob.execute(DiagnosticJob.java:38)

              at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

              at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534)

      Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 3f969e4:9f33:50337907:15c013 status: ActionStatus.ABORTED >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 3f969e4:9f33:50337907:15c013 status: ActionStatus.ABORTED >)

              at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)

              at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)

              at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)

              ... 52 more

      Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 3f969e4:9f33:50337907:15c013 status: ActionStatus.ABORTED >

              at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:304)

              at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)

              at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)

              at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)

              ... 54 more