Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Unanswered: Error "Could not position within a table": newbie seeks help!


    I'm developing a java app which connects to a Informix server.

    My app reads requests from an entry table, processes them, and afterwards writes the result in an exit table and delete the request from the entry table.

    My goal was to do this (the inserting in the exit table and deleting from the entry table) in a single transaction by setting Autocommit to false, performing the operations, and then commiting the result. However, when I do that, I get the annoying "Could not position within a table <table name>" error message. If I execute both statements in separate transactions (by leaving autocommit set to true), everything works fine.

    Can someone help me here?

    Thanks in advance

  2. #2
    Join Date
    Aug 2003
    Hi Pedro,

    Run first "set lock mode to wait".


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts