Subject Re: Multiple threads with one connection each
Author Alexander V.Nevsky <>
--- In, "Datatal AB - Gauffin, Jonas"
<jonas@d...> wrote:
> Hello
> I'm writing a small test application for firebird that uses Open
> FireBird ODBC Driver.
> Everything works nice when I got one connection.
> But as soon as I load up more threads, with one connection each,
> everything stops in the execution of a sql statement (SELECT
> I've started with a thread that do random reads and a thread that do
> random inserts/updates.


> What can be wrong?

Jonas, I don't know C, but I could'nt find in your text
a) connection string - local connections are queued in gds32 so you
threads will wait each other.
b) transaction parameters - some modes produce infinitive waiting on
lock conflict resolution with random tests.

Best regards, Alexander V.Nevsky.