Re: [Firebird-net-provider] How to reset transaction after connection drop?

[<car...@te...>]

Hello:

> I am writing a windows service that is basically polling a firebird
> database.  In the past I have had some difficulty with the database
> periodically crashing.  So, I am trying to make my service gracefully 
> handle
> a database crash.
>
> The service itself reuses a series of FbCommand objects each time a Timer
> event fires.  But, I haven't found a way to recover the FbCommand objects
> that have active transactions to allow them to be used with the new 
> database
> connection.  As far as I can tell, any attempt to associate a new
> FbConnection object with the FbCommand objects causes a rollback on the
> existing transaction.  This obviously fails since the original 
> connection is
> no longer valid.  Is there a way to recover these command objects or 
> should
> I instantiate new ones and let the old ones be garbage collected?


Can you try with latest cvs sources i have commited a fix for it yet.

> Has anyone started working on enabling events?  I know that my service 
> would
> be a whole lot more efficient if I could use an event model as apposed to
> polling the database.  If anybody is working on it, I'd be glad to 
> help.  If
> not, I'll look into it myself.


No, to which events are you referring??, (now there are events enabled 
on FbConnection class for StateChange of connection and info messages 
sent by firebird server, and there are events on FbDataAdapter for data 
updating).


Best regards
Carlos Guzma'n A'lvarez
Vigo-Spain