0 Replies Latest reply on Nov 25, 2009 4:37 PM by M B

    Unusual DB related error? JBoss 4.2.3

    M B Newbie

      Morning all,

      We've got a system that uses EJB3 Entity Beans (so JPA and Hibernate), JBoss messaging 1.4.5 (manually upgraded from 1.4.2 due to known bugs with lost/jammed up messages) and JDBC connection to Oracle 9.2.0.8.

      For some reason we're unable to run the 1.4.5 JBoss Messaging version in our production environment... after a while, we get this error occurring repeatedly:

      2009-11-25 07:33:39,847 ERROR [STDERR] Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.loader.Loader.doQuery(Loader.java:673)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
      2009-11-25 07:33:39,847 ERROR [STDERR] at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
      2009-11-25 07:33:39,848 ERROR [STDERR] at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
      2009-11-25 07:33:39,848 ERROR [STDERR] at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
      2009-11-25 07:33:39,848 ERROR [STDERR] at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
      2009-11-25 07:33:39,848 ERROR [STDERR] at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
      2009-11-25 07:33:39,848 ERROR [STDERR] at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
      2009-11-25 07:33:39,848 ERROR [STDERR] at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
      2009-11-25 07:33:39,848 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:174)
      2009-11-25 07:33:39,848 ERROR [STDERR] ... 89 more
      2009-11-25 07:33:39,848 ERROR [STDERR] Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -53e461c2:9498:4b0bde99:260db status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -53e461c2:9498:4b0bde99:260db status: ActionStatus.ABORT_ONLY >)
      2009-11-25 07:33:39,848 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
      2009-11-25 07:33:39,848 ERROR [STDERR] at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)
      2009-11-25 07:33:39,848 ERROR [STDERR] at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
      2009-11-25 07:33:39,848 ERROR [STDERR] ... 107 more
      2009-11-25 07:33:39,848 ERROR [STDERR] Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -53e461c2:9498:4b0bde99:260db status: ActionStatus.ABORT_ONLY >
      2009-11-25 07:33:39,900 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:319)
      2009-11-25 07:33:39,900 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
      2009-11-25 07:33:39,900 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
      2009-11-25 07:33:39,900 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
      2009-11-25 07:33:39,900 ERROR [STDERR] ... 109 more

      I'm at a loss as to what to look at next. Any pointers/thoughts would be much appreciated.