2 Replies Latest reply on Feb 5, 2010 2:47 AM by mamato

    DB Connection NOT restored

      Hi,

      I've an EJB3 application running on JBOSS 5.1

       

      A thread, every second, looks uf for my stateless session bean and invokes a method

      This method executes a query...

       

      If, when the system is up an running, the DB crashes and goes up again, my application seems to be unable to restore the connection.

       

      Is it normal ?

      Any idea ?

       

      2010-02-03 23:22:09,291 ERROR [it.mamato.ce.ejb.send.SenderTask] (Thread-1779) Exception javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
      2010-02-03 23:22:10,291 WARN  [org.hibernate.util.JDBCExceptionReporter] (Thread-1779) SQL Error: 0, SQLState: null
      2010-02-03 23:22:10,291 ERROR [org.hibernate.util.JDBCExceptionReporter] (Thread-1779) La connessione è chiusa.
      2010-02-03 23:22:10,291 ERROR [org.hibernate.ejb.AbstractEntityManagerImpl] (Thread-1779) Unable to mark for rollback on PersistenceException:
      java.lang.IllegalStateException: [com.arjuna.ats.internal.jta.transaction.arjunacore.nosuchtx] [com.arjuna.ats.internal.jta.transaction.arjunacore.nosuchtx] No such transaction!
      at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.setRollbackOnly(BaseTransaction.java:191)
      at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.setRollbackOnly(BaseTransactionManagerDelegate.java:123)
      at org.hibernate.ejb.AbstractEntityManagerImpl.markAsRollback(AbstractEntityManagerImpl.java:421)
      at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:576)
      at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
      at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)
      ....

       

      Thanks