Direct mode and Threaded Application Server

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
rhettp
Posts: 25
Joined: Tue 15 Aug 2006 01:25

Direct mode and Threaded Application Server

Post by rhettp » Tue 25 Jan 2011 16:38

Can anyone clarify this statement in the ODAC help:

>> Are the ODAC connection components thread-safe?
>> In Client mode, ODAC is thread-safe. In Direct mode, we do not
>> guarantee complete thread safety and recommend setting up a separate
>> Connection set for each thread that uses ODAC.

Does this mean that Direct Mode is not recommended for all threading scenarios, or just that if using Direct Mode you need to stick with only one Connection per thread and then you are ok?

- Rhett Price

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Wed 26 Jan 2011 08:47

Hello,

We had some problems with threads in the direct mode in older versions of ODAC.
Now we have fixed most of them, and recently we did not receive any complaints associated with multi-threading in the direct mode.
So if you are using the latest version of ODAC, you should not have any problems with multi-threading in direct mode.

fagut
Posts: 1
Joined: Sun 11 Sep 2011 20:30

Post by fagut » Mon 12 Sep 2011 08:32

From wich version have you fixed the code ?
We have ODAC v.6.90.0.60 ... is this version fixed or is considered unestable with thread safe in direct connections ?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Mon 12 Sep 2011 13:12

Hello,

The last known bug with multithreading in ODAC was fixed in the version 7.00.0.2, but we recommend you to use the latest versions of our products, because all fixes and new features are added to the latest version only.

Post Reply