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@mindtree.com> wrote in message
news:f2c2908d.0309162132.2f5a249d@posting.google.c om...
> 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

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

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