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.java:230)

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

Thanks
shivas

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 (AT) mindtree (DOT) com> wrote

a:230)

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:
--
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 #

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 (AT) mindtree (DOT) com [mailto:shivasj (AT) mindtree (DOT) com]
Sent: Wednesday, September 17, 2003 06:32
To: informix-list (AT) iiug (DOT) 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