|Subject||Re: [IBO] TIB_Connection Losing Connection. PLEASE HELP|
> All our query components start transactions as follows:I wonder why you enclose the commit statement within a try..finally block.
> if not qryXX.IB_Transaction.InTransaction then
> if not qryXX.IB_Transaction.Started then
> qryXX.IB_Transaction.Started := true;
Like this, any exception which comes up after the open statement (I assume
you have some statements there), will cause first to commit (in the finally
part) then rollback (in the except part), which I believe cannot be healthy.