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

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

    Hi

    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
    Pedro

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi Pedro,

    Run first "set lock mode to wait".

    Gustavo.

Posting Permissions

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