I have an application which manages various sql updates in their begin,
commit transactions.
On an occasion the code hits a bug where it does a begin, carries out a
number of sql updates successfully, then decides it needs to rollback, but
does NOT. The program then exits cleanly.
Can any one tell me if the updates may under any circumstances be commited
?
Many thanks,
Andrew H
sending to informix-list
↪ replying to Andrew Hardy
On Wed, 10 Mar 2004 06:44:45 -0500, Andrew Hardy wrote:
The engine will automatically rollback everything within the uncommitted
transaction when the connection to the client is lost.
Art S. Kagel
> I have an application which manages various sql updates in their begin,
> commit transactions.
>
> On an occasion the code hits a bug where it does a begin, carries out a
> number of sql updates successfully, then decides it needs to rollback, but
> does NOT. The program then exits cleanly.
>
> Can any one tell me if the updates may under any circumstances be commited ?
>
> Many thanks,
>
> Andrew H
>
>
> sending to informix-list