SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySQL - Can't call rollback when autocommit=true even if autocommit=false

687809Feb 26 2009 — edited Feb 26 2009

Hi,

I have a MySQL DB with InnoDB tables.

Even if "Autocommit in SQL Worksheet" is turned off, i'm unable to issue commit / rollback after executing a statement.

The shown error message is "Can't call rollback when autocommit=true. Vendor code 0".

I'm using Oracle sql Developer 1.5.3, and MySQL connectors 5.0.8 / 5.1.7 (I have the identical problem with both version).

Previously i used the 1.2 version of sql Developer, and all things worked correctly.

Any ideas?

Paolo

Edited by: user5393134 on 26-feb-2009 4.43

Edited by: user5393134 on 26-feb-2009 5.17

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2009

Added on Feb 26 2009

#sql-developer

1 comment

915 views