Re: java.sql.SQLException: Could not position within a table

Posted in 2003

Paul Watson — Wed, 17 Sep 2003 10:06:31 +0100 — source: Usenet: comp.databases.informix

You've got a locking/concurreny problem, you'll need to increase the lock wait to something larger and/or look at the isolation level and/or review the application logic. What is the locking level on stockprice? shivas wrote: > > Hi, > > I have an application running on Tomcat on Windows 2000 and the > database is Informix running on a HP-UX box. > > Once in a while i get this exception.. > > java.sql.SQLException: Could not position within a table > (informix.stockprice). > at com.informix.jdbc.IfxSqli.errorDone(IfxSqli.java:3102) > at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:2982) > at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2066) > at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:1995) > at com.informix.jdbc.IfxSqli.sendStatementQuery(IfxSqli.java:1263) > at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1210) > at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1147) > at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:218) > at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:707) > at com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:230) > > Has anyone encoutered this problem before. Any sort of help will be > great!! > > Thanks > shivas -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #