2 Replies Latest reply on Oct 24, 2008 11:53 AM by Benito Juarez

    Transaction closed after constraints violation

    Benito Juarez Newbie

      Hello,


      after persisting an entity bean i got following error:


      Duplicate entry 'Hokkaido-houses-2890' for key 2


      It's ok, because i violated a constraint in the mysql database. The problem is, that the hibernate connection seems to be closed. The next flush-statement causes the following error:


      '17:24:01,562 ERROR JDBCExceptionReporter Transaction is not active: tx TransactionImple < ac, BasicAction: a964180:750:4900340b:1e70 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a964180:750:4900340b:1e70 status: ActionStatus.ABORT_ONLY >)
      17:24:01,562 ERROR STDERR org.hibernate.exception.GenericJDBCException: Cannot open connection
      '


      thx for help
      BJ