Subject Re: [IBO] Transactions
Author Joshua Higgs
> J> 1) Using 2 connections to the database - one with a TIB_Connection
> J> one with a TDatabase gave random exceptions "Declared cursor already
> J> exists". I needed the two connections until a fixed a bug in an old
> J> of TIBOQuery that prevented it being used to feed QuickReports. Going
> J> to 1 connection seems to have fixed this problem.
> Did you use a single IB_Session or two? I am going to have to do
> exactly that (two connections) and I was planning to use two
> IB_Session objects. I need to know if there's any outstanding bug in
> IBO in this area (well, I'm gonna run into it if there is, but knowing
> in advance would be nice); do you have any further info about this
> one?

I only used one in that case because it was not multi threaded. However, I
did introduce a worker thread which had a third connection to the database
with it's own TIB_Session. This worked most of the time but I got some
funny errors that I did not have time to research (most likely my own error
since it was my first attempt at multi threading), so I brought it back into
the main thread.