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

Posted in 2003

Topics: Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues, Java & JDBC Development

shivas — 16 Sep 2003 22:32:03 -0700 — source: Usenet: comp.databases.informix

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

↪ replying to shivas

Gorazd Hribar Rajteric — Wed, 17 Sep 2003 09:50:19 +0200 — source: Usenet: comp.databases.informix

We experienced similar problem on IDS 7.31 on Solaris machines. There is no simple solution to this problem. You can try to increase lock waiting time (SET LOCK MODE TO WAIT 100 for example, or you can try dirty reading (SET ISOLATION TO DIRTY READ). Gorazd "shivas" <shivasj@mindtree.com> wrote in message news:f2c2908d.0309162132.2f5a249d@posting.google.com... > 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.jav a:230) > > Has anyone encoutered this problem before. Any sort of help will be > great!! > > Thanks > shivas