Re: [Firebird-net-provider] A way to monitor connection state

2009-03-30 Thread Dean Harding
> > It's not? Even if you keep a 1-1 relationship between threads and > > connections (i.e. use a separate connection per thread)? > > If you have separate connections for each thread, why bother about > thread safety? Thread safe is about using one connection in multiple > threads. Yeah, sorry,

Re: [Firebird-net-provider] A way to monitor connection state

2009-03-30 Thread Jiri Cincura
On Mon, Mar 30, 2009 at 00:15, Dean Harding wrote: > It's not? Even if you keep a 1-1 relationship between threads and > connections (i.e. use a separate connection per thread)? If you have separate connections for each thread, why bother about thread safety? Thread safe is about using one connec

Re: [Firebird-net-provider] A way to monitor connection state

2009-03-29 Thread Ivan Arabadzhiev
Having multiple connections was a nice idea ... until latency started messing with the data :) I had cases of commited transactions which are not seen by the secondary connection (despite semaphore/lock synchornization ...), which is why I switched to the single connection method ... Mon,

Re: [Firebird-net-provider] A way to monitor connection state

2009-03-29 Thread Dean Harding
> > FbClient is threadsafe, no worries there. > > FirebirdClient isn't thread safe. It's not? Even if you keep a 1-1 relationship between threads and connections (i.e. use a separate connection per thread)? Dean. -- _

Re: [Firebird-net-provider] A way to monitor connection state

2009-03-29 Thread Jiri Cincura
2009/3/29 Zvjezdan Tomicevic : > FbClient is threadsafe, no worries there. FirebirdClient isn't thread safe. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] A way to monitor connection state

2009-03-29 Thread Ivan Arabadzhiev
I`m currently using a slightly modified version of the 2.1 provider, which raises an exception when I try to begin multiple transactions (which is the current source of most of my issues). Is the 2.5 beta capable of concurent transactions? Is it stable enough for basic functionality (select,

Re: [Firebird-net-provider] A way to monitor connection state

2009-03-29 Thread Zvjezdan Tomicevic
You can execute lightweigth dumb query against DB in separate thread for connection checking purposes. FbClient is threadsafe, no worries there. Executing read only query unrelated to user data shold not conflict with your bussiness at all. 2009/3/29 Ivan Arabadzhiev > I am currently developing

[Firebird-net-provider] A way to monitor connection state

2009-03-29 Thread Ivan Arabadzhiev
I am currently developing an application which is supposed to silently ignore lack of database connectivity and continue working transparantly to the end user. There is indication on the GUI about the state of the connection, but I noticed it doesn`t change until an operation is attempted,

[Firebird-net-provider] A way to monitor connection state

2009-03-29 Thread Ivan Arabadzhiev
I am currently developing an application which is supposed to silently ignore lack of database connectivity and continue working transparantly to the end user. There is indication on the GUI about the state of the connection, but I noticed it doesn`t change until an operation is attempted, so I do