java.sql.SQLException: ORA-01002: fetch out of sequence

Discussions

Web tier: servlets, JSP, Web frameworks: java.sql.SQLException: ORA-01002: fetch out of sequence

  1. Hi,

             I am getting a java.sql.SQLException: ORA-01002: fetch out of sequence in weblogic when I am trying to access the database.
         Can anyone help me.

    Thanks,
    Surendra

    Threaded Messages (1)

  2. autocommit[ Go to top ]

    Hi surendra,

    Well I had this problem and here is what I did :

    In my code my SQL request what a "select for update" statement, because I had to update a row which contained a BLOB.

    By default, the flag "autocommit" is set to true in a JBDC Connection. I switch this flag to false and the error vanished.

    Regards

    Laurent