> I honestly don't know if they're part of ANSI SQL, but I'd be
> willing to bet they are in at least one of the more recent
> versions. Now, whether your favorite database *supports*
> them, that's another story....
In general savepoints in transactions are supported, at least on:
oracle, sqlserver, firebird, postgresql, db2, sybase. MySql and Access don't
support it. I'm not sure about VistaDB and other small
players though.
FB
>
> I wouldn't bet on Access getting them any time soon. ;-)
>
> Ted Neward
> 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 05, 2006 5:41 AM
> > To: ADVANCED-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 were) -- they seem to be available in Oracle (at
> least since 10.2).
> > They aren't part of "standard SQL", are they?
> >
> > At 07:20 AM 1/5/2006, Ted Neward wrote
> > >Savepoints are often used to provide the same basic kind
> of behavior
> > >that nested transactions are asked to provide, a la your example
> > >scenario. I'd
> > go
> > >with the savepoint:
> > >
> > >Start trans
> > >Begin loop
> > > Do work
> > > Create savepoint
> > >End loop
> > >Commit trans or rollback
> > >
> > >Note that you can also rollback to a savepoint if
> necessary/desired.
> > Check
> > >the SQL Server docs for how many open savepoints you can have.
> > >
> > >Bear in mind, too, that you're holding locks throughout
> the window of
> > >the transaction, so savepoints don't release any
> contention issues here.
> > >
> > >Ted Neward
> > >Author, Presenter, Consultant
> > >Java, .NET, XML services
> > >http://blogs.tedneward.com
> >
> >
> > J. Merrill / Analytical Software Corp
> >
> > ===================================
> > This list is hosted by DevelopMentor. http://www.develop.com
> >
> > View archives and manage your subscription(s) at
> > http://discuss.develop.com
>
> ===================================
> This list is hosted by DevelopMentor. http://www.develop.com
>
> View archives and manage your subscription(s) at
> http://discuss.develop.com
>
===================================
This list is hosted by DevelopMentor® http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
