Data base connection not alive for longer transactions in jboss wildfly

[ajay.jonna]

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:]

[wdfink]

Infinispan seems not the correc forum, move to WildFly

[wdfink]

I'm not sure about your use-case.

Did you start a transactional EJB and have it running for 2 hours?

Could you elaborate on this?

[ajay.jonna]

Yes, you are correct. Starting the EJB transaction, which takes around 2 hours to complete its conversion. Once converted then on words need to have data base operations to store the converted records.

[wdfink]

You need to set the transaction timeout like this

@TransactionTimeout(value = 10, unit = TimeUnit.SECONDS)

But a better solution is to use a method without Tx to collect the results and invoke another method annotated with Tx.REQUIRED to store it.

Note, you need to invoke the method with a proxy (like a different EJB) as with a direct Java method invocation the container is not involved and there is no transaction started.