oracle sqldeveloper - Disable autocommit in SQL Developer when using MySQL -

i'd connect mysql server oracle sql developer, autocommit disabled. default, mysql connections have autocommit enabled, rather odd.

the global setting in sql developer unchecked, ,

set autocommit=0;

results in error

set autocommit script command forced off, connection level autocommit on.

in connection's settings no other options besides hostname, port , drop down box database selection.

i'm using sql developer 3.2.10 latest jdbc connector, 5.1.

you run error if try , use

start transaction;  -- sql statements  commit;

...out of box on mysql database in sqldeveloper (as michael mentioned in comment answer.)

in order around error michael referenced in comment can use following hint:

/*sqldev:stmt*/start transaction;  -- sql statements  /*sqldev:stmt*/commit;

found information here.

IO