Multi Threading Issues

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
meetkarthik
Posts: 9
Joined: Thu 16 Sep 2010 20:10

Multi Threading Issues

Post by meetkarthik » Mon 22 Nov 2010 23:24

We use dotConnect for Oracle 5.70.180 as part of a WCF service, and we are seeing some incorrect results when sending simultaneous requests to the service from multiple clients. Each request is served by several DataContext instances that are created specifically for this request and are not shared with any other requests. When using only one client everything works perfectly but even as few as 2 clients start causing issues. For example, when retrieving data from the db some dependent entities (specified through DataLoadOptions.LoadWith) are not retrieved at all (according to dbMonitor no selects are generated for them). This happens randomly for approx. 30-40% requests. Are you aware of any multi-threading issues with the simultaneous use of multiple DataContext instances? Is there any static data that they all share that is not thread-safe?

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Tue 23 Nov 2010 16:05

A problem similar to the one you've described was fixed in the 5.70.190 build of dotConnect for Oracle. Please try the 5.70.190 or 6.0.46 Beta build. It can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(the trial version) or from Registered Users' Area (provided that you have an active subscription):
http://secure.devart.com/

If the problem can be reproduced with a newer version, please describe it in more details or, if possible, send us a test project so that we are able to reproduce and investigate it.

Post Reply