Skip to Content.
Sympa Menu

freetds - Re: Commit

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Henry Lu <zhlu AT umich.edu>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Commit
  • Date: Tue, 21 Mar 2000 07:21:41 -0500 (EST)


If i do delete and insert without commit between, the first delete
transaction will be rollback automatically. Why?


---------------------------------------------------------------------------
Henry Lu
Computer Systems Programmer III e-mail: zhlu AT umich.edu
MCIT phone: (734) 936-2063
University of Michigan Medical Center fax: (734) 763-4372

On Mon, 13 Mar 2000, Craig Spannring wrote:

>
> Submit sample code that demonstrates the problem to
>
> freetds-jdbc-bugs AT aedinc.net
>
>
> Henry Lu writes:
> > Why I am allowed to commit one transaction a time in the freetds JDBC for
> > MS SQL Server? Is it a bug or what?
> > Example:
> > I insert 100 rows into a table. If commit is issued after 100 insertion,
> > only the first row is inserted. If commit is issued after each insertion,
> > all 100 rows are inserted.
> >
> > Is there any way to have one commit for 100 insertion?
>
> --
> =======================================================================
> Life is short. | Craig Spannring
> Bike hard, ski fast. | cts AT internetcds.com
> --------------------------------+------------------------------------
> Any sufficiently horrible technology is indistinguishable from Perl.
> =======================================================================
>
> ---
> You are currently subscribed to freetds as: zhlu AT umich.edu
> To unsubscribe, forward this message to $subst('Email.Unsub')
>




  • Commit, Henry Lu, 03/13/2000
    • <Possible follow-up(s)>
    • Re: Commit, Craig Spannring, 03/13/2000
    • Re: Commit, Henry Lu, 03/21/2000

Archive powered by MHonArc 2.6.24.

Top of Page