I'd have to see a spec reference before I thought this was a bug. Changing
transaction isolation should also commit the current tx.

david jencks

On 2002.04.04 04:29:09 -0500 Ferrari Alberto wrote:
> 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
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>