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 ?