Still on this same issue i have not btw solved the previous issue, if you
will recall, i have found it merely impossible to reconnect an ibo
connection once it is lost, even after cancelling and closing all
transactions, the ibo connection still wants to write something to the
connection on close, not even forcedisconnect works, or Connected := false.
I have even tried to Free the IBO Connection Components and replacing them
with new instances, this works but causes memory leaks with the IBO
connection components not freeing since it raises an exception on destroy
trying to "write" to the connection, not a clean solution

so the only alternative was to periodiacally check the connection by calling
VerifyConnection, If this fails it waits 1 sec and then retries another 2
times, if it does not verify all 3 times, the server's process is terminated
and restarts itself, this seemed to work, but

Whenever quite a few queries are run the server seems to keep restarting,
it's as if verifyconnection does not work if something is busy with the
connection.

What does veryifyconnection do? and how reliable is it? and if a query is
busy running over the connection and data is being received or something,
will verifyconnection return false?

----- Original Message -----
From: "Heri" <heribender@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, November 03, 2002 10:19 PM
Subject: Re: [IBO] TIB_Connection Losing Connection. PLEASE HELP


> > All our query components start transactions as follows:
> >
> > if not qryXX.IB_Transaction.InTransaction then
> > qryXX.IB_Transaction.StartTransaction;
> > if not qryXX.IB_Transaction.Started then
> > qryXX.IB_Transaction.Started := true;
> > try
> > try
> > qryXX.Open;
> > finally
> > qryXX.IB_Transaction.Commit;
> > end;
> > except
> > try
> > qryXX.IB_Transaction.Rollback;
> > except
> > end;
> > raise;
> > end;
>
> I wonder why you enclose the commit statement within a try..finally block.
> 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.
>
> Heri
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>