ISAM Error -144
843854Mar 5 2002 — edited Mar 5 2002Hi,
Can some one help me out why the following error is coming. I tried with the following options of Translation Isolation in my Connection object:
a. Read committed
b. Read Uncommited
c. Repeatable read
But still the error keep coming. The good thing is the required values are selected properly. But somehow i want to get rid of this error. Does any one had similar problem before??
Exception Occurred to get ResultSet : SELECT b.u_objpg FROM dbew13:doc_tl a, OUTER dbeu15:cchpg2_t b WHERE b.n_objid = a.n_object and a.n_doc_ser= ?
java.sql.SQLException: Could not position within a file via an index.
(-144)ISAM error: key value locked
java.lang.Throwable(java.lang.String)
java.lang.Exception(java.lang.String)
java.sql.SQLException(java.lang.String, java.lang.String, int)
void com.informix.jdbc.IfxSqli.errorDone()
void com.informix.jdbc.IfxSqli.receiveError()
void com.informix.jdbc.IfxSqli.receiveMessage()
void com.informix.jdbc.IfxSqli.sendStatementQuery(com.informix.jdbc.IfxStatement, boolean, com.informix.jdbc.IfxResultSetMetaData)
void com.informix.jdbc.IfxSqli.executeStatementQuery(java.sql.Statement, boolean, java.sql.ResultSetMetaData)
void com.informix.jdbc.IfxSqli.executeStatementQuery(java.sql.Statement, boolean)
void com.informix.jdbc.IfxResultSet.executeQuery(boolean)
java.sql.ResultSet com.informix.jdbc.IfxStatement.executeQueryImpl(boolean)
java.sql.ResultSet com.informix.jdbc.IfxPreparedStatement.executeQuery()
java.sql.ResultSet com.aexp.eaim.iu.isp.util.Dbcon.query(java.sql.PreparedStatement)
java.util.Vector com.aexp.eaim.iu.dconv.Deconversion.checkObjInCache2(int)
java.util.Vector com.aexp.eaim.iu.dconv.Deconversion.getObjInCache(int, int, int, int, int)
java.util.Vector com.aexp.eaim.iu.dconv.Deconversion.checkObjInCache12(int)
void com.aexp.eaim.iu.dconv.Deconversion.getIndexAndImage()
void com.aexp.eaim.iu.dconv.Deconversion.run()
Have a nice day!
Babu