Oninit cdi / Archive
Talk to an expert →

Could not do a physical-order read to fetch next row

Posted in 2001

Topics: Connectivity: ODBC / JDBC / .NET, Java & JDBC Development

Vlad Dutov — — source: Informix-list mailing list archive (1991-1998)

Hi! Does anybody know kind of trouble: java.sql.SQLException: Could not do a physical-order read to fetch next row. 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.executeFetch(IfxSqli.java:1663) at com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:3720) at com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:437) ... Thanks! Vlad Dutov

↪ replying to Vlad Dutov
Neil Truby — — source: Informix-list mailing list archive (1991-1998)

The row you want to read is locked by another user. Vlad Dutov <vladonmailru@mail.ru> wrote in message news:95973q$105f$1@nl.novosoft.ru... > Hi! > > Does anybody know kind of trouble: > java.sql.SQLException: Could not do a physical-order read to fetch next row. > 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.executeFetch(IfxSqli.java:1663) > at com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:3720) > at com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:437) > ... > > Thanks! > Vlad Dutov > >

↪ replying to Vlad Dutov
Andrew Hamm — — source: Informix-list mailing list archive (1991-1998)

Vlad Dutov wrote in message <95973q$105f$1@nl.novosoft.ru>... > >Does anybody know kind of trouble: >java.sql.SQLException: Could not do a physical-order read to fetch next row. > Oh yes - that's an old friend to many people. Read these recent messages from the newsgroup: 18 Jan 2001 Deadlock problem... 2 responses on the 18th Jan 14 Jan 2001 Question about promotable locks 2 responses on the 15th Jan 2 responses on the 16th Jan All your answers should be in those messages so it's pointless repeating the advice again. Feel free to ask further questions about any finer points.