views:

146

answers:

1

What is the behaviour of nested transactions. I am using java + jdbc ? Eg:

tx1.begin
    do stuff1
    tx2.begin
        do stuff2
    tx2.commit
    do stuff1.1
tx1.rollback

tx2 is basically inside another function. Will the results from tx2 be persisted ?

In case behaviour is db specific, what is it in case of Sql server 2005 ?

A: 

Look at this answer which is similar.

rmarimon