> Author, Presenter, Consultant
> Java, .NET, XML services
> http://blogs.tedneward.com
>
> > -Original Message-
> > From: Discussion of advanced .NET topics. [mailto:ADVANCED-
> > [EMAIL PROTECTED] On Behalf Of J. Merrill
> > Sent: Thursday, January
DOTNET@DISCUSS.DEVELOP.COM
> Subject: Re: [ADVANCED-DOTNET] Nested transactions
>
> Are there framework methods for using savepoints, or do you have to
> execute a SQL statement to use them?
>
> I just learned that savepoints aren't SQL-Server-only (I had thought that
> they
The SqlTransaction class has a Save() method; however, the OracleTransaction
(at least in the Microsoft provider) and OdbcTransaction classes do not. For
those instances you would (I guess) have to use SQL statements to save
transactions.
On 1/5/06, J. Merrill <[EMAIL PROTECTED]> wrote:
>
> Are th
Are there framework methods for using savepoints, or do you have to execute a
SQL statement to use them?
I just learned that savepoints aren't SQL-Server-only (I had thought that they
were) -- they seem to be available in Oracle (at least since 10.2). They
aren't part of "standard SQL", are th
Allan:
> So component 1 which is marked "Requires new" would initiate the
> transaction and the other component would be called from with in the
loop,
> marked as "Required/-Supported".
Surely then the inner 'transaction' would just join the outer one? As I
have it, if the inner call requires a t
Hi
If you could resort to using COM+ (ServicedComponent), you could simply
create 2 components marked with "Requires new" and "Required".
So component 1 which is marked "Requires new" would initiate the
transaction and the other component would be called from with in the loop,
marked as "Required/
P.COM
> Subject: Re: [ADVANCED-DOTNET] Nested transactions
>
> > Can ado.net 1.1 support nested transactions? I would like to
> > have the ability to rollback all changes at the end but also
> > have a start and commit trans in the loop. Note: this is not
> > the exact
What is the expected change in behavior from having done start/work/commit
inside the loop, vs just doing the work without using a transaction? If the
outer transaction is committed, obviously the inner work will be kept, just as
it would be even if that work were not inside its own transaction
> Can ado.net 1.1 support nested transactions? I would like to
> have the ability to rollback all changes at the end but also
> have a start and commit trans in the loop. Note: this is not
> the exact logic but a simple example to demonstrate what I
> want to accomplish so please don't ask why be
OleDbTransaction is the only class that describes Begin() as being
nested. I would assume from that that only OleDbConnection supports
nested transactions; but, I don't know if that includes
OleDbConnection.BeginTransaction(). There's no mention whether it calls
OleDbTransaction.Begin(). Reflect
10 matches
Mail list logo
