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.