Re: [Firebird-odbc-devel] Retreiving data using one connection object with multiple threads.

[Vladimir T. <pr...@hm...>]

Hi Nidhi,

> In my application I require to retrieve data from the firebird database. I
> am using firebird ODBC driver. I have created one connection object and at
> present only one thread is using this object to retrieve the data. To
> fulfill some enhancement there is a requirement that another thread will
> also use same connection object to retrieve the data from database.
> I have not yet tried and explored it to know whether is it possible or
not?
> I am posting this here so if somebody already have done this then can
> provide some inputs to me.

See
http://www.praktik.km.ua/downloads/OdbcTest.zip
folder TestThreading

However you should know
  one connect - one thread (OdbcJdbc.dll)
     Faster ~ 1.5-2 times
 then   one connect - many threads (OdbcJdbcMT.dll)

--
Best regards,
Vladimir Tsvigun