Subject | Re: [IBO] Transactions |
---|---|
Author | Joshua Higgs |
Post date | 2003-07-28T00:03:37Z |
> J> 1) Using 2 connections to the database - one with a TIB_Connectionand
> J> one with a TDatabase gave random exceptions "Declared cursor alreadyversion
> 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. Goingback
> J> to 1 connection seems to have fixed this problem.I only used one in that case because it was not multi threaded. However, I
>
> 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?
>
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.
Cheerio
Josh