FreeTDS Development Group

[Henry Lu <zhlu AT umich.edu>]

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')
>