473,320 Members | 1,950 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Oracle, Dataset Designer, and Transactions

I am building a windows forms app using VS2005 and the dataset designer to
connect to an Oracle backend. So far this has worked quickly and easily for
me to finish the app within the given timeframe.

I would love to add transactioning to some of the calls to add robustness.
I can begin the transaction on the tableadapter, but I cannot find a way to
enlist the various predefined commands for each tableadapter into the
transaction. Or do the commands automatically enlist themselves in the
transaction with a System.Data.OracleClient type connection?

Thanks in advance for any information.
Sep 5 '06 #1
2 1917
Hello maltobelli,

for oracle, transactions are implicit for each connection

mI am building a windows forms app using VS2005 and the dataset
mdesigner to connect to an Oracle backend. So far this has worked
mquickly and easily for me to finish the app within the given
mtimeframe.
m>
mI would love to add transactioning to some of the calls to add
mrobustness. I can begin the transaction on the tableadapter, but I
mcannot find a way to enlist the various predefined commands for each
mtableadapter into the transaction. Or do the commands automatically
menlist themselves in the transaction with a System.Data.OracleClient
mtype connection?
m>
mThanks in advance for any information.
m>
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
Sep 5 '06 #2
If you're using .NET 2.0 you have the option of using TransactionScope.
Although this can have a performance hit.

The other option is to use transaction directly by extending your table
adapter with a BeginTransaction method. The method should first check that
the current connection is open. Then create a transaction from the adapters
Connection property and assign it to each command (I,U,D) and the
_commandCollection. Remember to check for nulls! Then return the
transaction. It's not a lot of work, honest.

I'd also recommend you take a look at ODP.NET. It's brimming with neat
stuff and the documenation is superb, all 1212 pages of it!

http://www.oracle.com/technology/tec...net/index.html

HTH

Glenn
"maltobelli" <ma********@discussions.microsoft.comwrote in message
news:A6**********************************@microsof t.com...
>I am building a windows forms app using VS2005 and the dataset designer to
connect to an Oracle backend. So far this has worked quickly and easily
for
me to finish the app within the given timeframe.

I would love to add transactioning to some of the calls to add robustness.
I can begin the transaction on the tableadapter, but I cannot find a way
to
enlist the various predefined commands for each tableadapter into the
transaction. Or do the commands automatically enlist themselves in the
transaction with a System.Data.OracleClient type connection?

Thanks in advance for any information.

Sep 8 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: francis70 | last post by:
Hi, I have these 2 problem? Is there a way in Oracle to read UNCOMMITED data. i.e. in Oracle the normal behaviour is that a user's updates to a table are visible to other users ONLY when the...
11
by: Markus Breuer | last post by:
I have a question about oracle commit and transactions. Following scenario: Process A performs a single sql-INSERT into a table and commits the transaction. Then he informs process B (ipc) to...
1
by: Rick | last post by:
I'm having problems with EnterpriseServices transactions running against Oracle 9iR2. I am inconsistently getting Oracle ORA-24761: Transaction Rolled Back results mid-transaction. If I start...
0
by: Max | last post by:
Hi wise people, Has anyone encountered the Crystal Reports problem I describe below? If so, how did you solve it? It seems that every article posted on google regarding CR and logon problems is...
5
by: Grant | last post by:
Hello, How come when I add a new row to my dataset table it shows up as changed (agencyData.Haschanges() = True) but when I delete a row the dataset thinks here are no...
0
by: Michelle Keys | last post by:
I am trying to call a print function to print a string from a database using javascript. Which is RC_DATA of Varchar2(2500). This is a javascript is not being used. I have a thing that needs to...
2
by: Oriol Tomàs | last post by:
Hi, I want to publish a Web Service who returns a dataset with some data from an Oracle Database. In the view designer I can preview data from my OracleDataAdapter1. It returns 3 rows. ...
0
by: DrSnap | last post by:
Hi, Admitted I am a newbie to Oracle (databases in general) but now Ive installed the Oracle DB v.10g and the ODAC development tools for Microsoft Visual Studio 2005. So, now i've found out,...
6
by: Joe Kovac | last post by:
Hi! I change quite a lot TableRows in several Tables of a typed DataSet. Now I would like to know which is the best way to save all the rows. Currently I just use each TableAdapters Update()...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.