Shivas

Common problem caused by a record or index entry being locked. Couple of
solutions to be used separately or together. Change the locking on
stockprice from page to row. Run the SQL command SET LOCK MODE TO WAIT n
(where n is a number of seconds). Before your query.

Keith

----Original Message-----
From: shivasj@mindtree.com [mailto:shivasj@mindtree.com]
Sent: Wednesday, September 17, 2003 06:32
To: informix-list@iiug.org
Subject: java.sql.SQLException: Could not position within a table


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:3 102)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.jav a:2982)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2066)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava:1995)
at com.informix.jdbc.IfxSqli.sendStatementQuery(IfxSq li.java:1263)
at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java:1210)
at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java:1147)
at com.informix.jdbc.IfxResultSet.executeQuery(IfxRes ultSet.java:218)
at com.informix.jdbc.IfxStatement.executeQueryImpl(If xStatement.java:707)
at
com.informix.jdbc.IfxPreparedStatement.executeQuer y(IfxPreparedStatement.jav
a:230)

Has anyone encoutered this problem before. Any sort of help will be
great!!

Thanks
shivas

************************************************** ********************************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
************************************************** ********************************
sending to informix-list