4 Replies Latest reply on Oct 1, 2015 1:03 PM by Wolf-Dieter Fink

    Data base connection not alive for longer transactions in jboss wildfly

    ajay jonna Newbie

      Once connection established from EJB flow, I need to hit data base multiple time as per business operations. I am processing 1 GB flat file, which takes 2 hours. After processing if I am trying to store the records in DB. Then data base connection seems not able to establish due to long time.

      Tried increasing the time from 0 to 30000 minutes (30000), but result for me. I am getting the following error stack:

      10:26:04,217 ERROR [com.unisys.trans.shared.util.jdbc.DataBaseConnectionMngr] (default task-56) LOG_ID_1010 from com.unisys.trans.shared.util.jdbc.DataBaseConnectionMngr.createPreparedStatement(DataBaseConnectionMngr.java:313): java.sql.SQLException: Transaction cannot proceed STATUS_ROLLING_BACK
      at org
      .jboss.jca.adapters.jdbc.WrapperDataSource.checkTransactionActive(WrapperDataSource.java:274)
      at org
      .jboss.jca.adapters.jdbc.WrappedConnection.checkTransactionActive(WrappedConnection.java:1604)
      at org
      .jboss.jca.adapters.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:1619)
      at org
      .jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1593)
      at org
      .jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:398)
      at com
      .unisys.trans.shared.util.jdbc.StatementCreator.createPreparedStatement(StatementCreator.java:53) [sharedclient.jar:]
      at com
      .unisys.trans.shared.util.jdbc.DataBaseConnectionMngr.createPreparedStatement(DataBaseConnectionMngr.java:301) [sharedclient.jar:]
      at com
      .unisys.trans.shared.util.jdbc.FactoryFinderBase.setPreparedStatementForExistingFactory(FactoryFinderBase.java:253) [sharedclient.jar:]
      at com
      .unisys.trans.shared.util.jdbc.JDBCFactory.createPreparedJDBCStatement(JDBCFactory.java:114) [sharedclient.jar:]