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

Hi Pedro,

Run first "set lock mode to wait".

Gustavo.