Getting java.sql.SQLException: ISAM error: record is locked in JBoss EAP 6
Issue
- Daily we have to restart the JBoss from a scheduled task. JBoss shuts down but does not start. So, we start it manually. We're getting the below error:
Caused by: java.sql.SQLException: Could not do a physical-order read to fetch next row.
at informix.jdbc.IfxSqli.a(IfxSqli.java:3631)
at informix.jdbc.IfxSqli.E(IfxSqli.java:3963)
at informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2693)
at informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2609)
at informix.jdbc.IfxSqli.a(IfxSqli.java:1828)
at informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1766)
at informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1697)
at informix.jdbc.IfxResultSet.a(IfxResultSet.java:209)
at informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1230)
at
informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:382)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79) [hibernate-core-4.2.18.Final-redhat-2.jar:4.2.18.Final-redhat-2]
... 103 more
Caused by: java.sql.SQLException: ISAM error: record is locked.
at informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413)
at informix.jdbc.IfxSqli.E(IfxSqli.java:3968)
... 113 more
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 6.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.