failing to rollback before a client exits.

Posted in 2004

Andrew Hardy — Wed, 10 Mar 2004 11:44:45 +0000 — source: Usenet: comp.databases.informix

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

Art S. Kagel — Wed, 10 Mar 2004 08:55:27 -0500 — source: Usenet: comp.databases.informix

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