Subject | Interclient 2.01 bug or feature??? |
---|---|
Author | Ferrari Alberto |
Post date | 2002-04-04T09:29:09Z |
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
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