Solved

OracleConnection does not support parallel transactions

Posted on 2004-09-05
5
1,995 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction                                                 Was the var keyword really only brought out to shorten your syntax? Or have the VB language guys got their way in C#? What type of variable is it? All will be revealed.   Also called…
This article introduced a TextBox that supports transparent background.   Introduction TextBox is the most widely used control component in GUI design. Most GUI controls do not support transparent background and more or less do not have the…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

932 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now