Subject Interclient 2.01 bug or feature???
Author Ferrari Alberto
I all,

i noticed this behavior in interclient 2.0:
if, for some statements, i call Connection.setAutoCommit(false) (for each statements) it seems that interclient commits the opened transaction

my code is:
Statement s;
Connection c;
if(s==null) s = c.createStatement ();
for(int i=0;i<10;i++){
c.setAutoCommit (false);

sql = "insert INTO "bhaa blahh" ";
s.executeUpdate(sql);

}
Logger.log("Element inserted now rollback");
c.rollback();
NO ROLLBACK IS DONE: calling setAutoCommit (false) in every cycle commits the transaction opened

Best Regards
Alberto Ferrari