concept on savepoint

my code is something like this ....

SavePoint s1 = con.setSavePoint("My SavePoint1");

//Some transactions ........ Transaction Set1

SavePoint s2 = con.setSavePoint("My SavePoint2");

//Some transactions ........... Transaction Set2

if(condition)

{

con.rollback(s2);//this is clear to me but ....

con.rollback(s1);//It is not clear...

}

that means con.rollback(s1) rolls back the Transaction Set1 as well as Transaction Set2 or only TRansaction Set1..

plz help me out

thanks in advance

[564 byte] By [dmj_screen1a] at [2007-11-26 18:10:01]
# 1
fiends i looking for helpplz help me!!!!!!!!!!
dmj_screen1a at 2007-7-9 5:42:10 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
con.rollback(savepoint) will rollback everything to when that savepoint was created.So in your code the con.rollback(s2) is a little redundant, as "transaction set 2" will be rolled back implicitly by the con.rollback(s1).
iklestevea at 2007-7-9 5:42:10 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...