BorlandTalk.com

kei · Guest

I try to use the follow method:

Database.setAutoCommit(false);
try{
// some change made on ds;
database.saveChanges(ds);
throw new Exception("test rollback()");
database..commit();
}
catch(Exception ex){
Database.rollback();
}
finally{
Database.setAutoCommit(true);
}

but I find that even I set autocommit to false, when
database.savechanges(ds) is called, the change is already written to
database (I check using SQL analyzer), and even there is exception and
rollback() is run, the record has not really rollback(), so the change is
still written to the database table, why??
Is it necessary to use
database.saveChanges(ds, false); // use false parameter instead of
database.saveChanges(ds) only??

Thx!!