Solved

OracleConnection does not support parallel transactions

Posted on 2004-09-05
5
2,011 Views
Last Modified: 2011-10-03
I got this message and I'm guessing that connections don't support multiple transactions. Can anyone tell me what they did to get around this issue.

Regards

Simion
0
Comment
Question by:simion_tishler
5 Comments
 
LVL 10

Expert Comment

by:123654789987
ID: 11987398
Refer this link

http://www.error-bank.com/microsoft.public.dotnet.framework.adonet/76907_Thread.aspx

It is about SqlServer but I think the same refers to oracle
0
 
LVL 22

Expert Comment

by:Mohammed Nasman
ID: 11995410
0
 
LVL 1

Author Comment

by:simion_tishler
ID: 12001779
hey guys

I solved it my self. Actually there is no way it is possible to do parallel transactions. Oracle has something called saved points and the oracle data provider does not implement saved points. The  only way to used saved points is to use the execute sql command. Saved points are good but are not strictly parallel transactions.
The only way to get another transaction is to open a new connection. if you have a great server and a high speed lan then this is not a bad option.

Thanks for you help guys.
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 12034222
Closed, 125 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question