Disable autocommit in SQL Developer when using MySQL

Disable autocommit in SQL Developer when using MySQL

I'd like to connect to a MySQL server with Oracle SQL Developer, but with autocommit disabled. By default, all MySQL connections have autocommit enabled, which is rather odd.

The global setting in SQL Developer is unchecked, and

set autocommit=0;  

results in the error

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

In the connection's settings are no other options besides hostname, port and a drop down box for database selection.

I'm using SQL Developer 3.2.10 with latest JDBC connector, 5.1.

Answer by Tantowi Mustofa for Disable autocommit in SQL Developer when using MySQL

enclose the commands with 'start transaction' and 'commit'. mysql turned off auto-commit on 'start transaction' until 'commit' or 'rollback' is issued

Answer by diadyne for Disable autocommit in SQL Developer when using MySQL

You will run into an error if you try and use

start transaction;    -- Your SQL statements    commit;  

...out of the box on a MySQL database in SQLDeveloper (as Michael mentioned in a comment to another answer.)

In order to get around this error that Michael referenced in his comment you can use the following hint:

/*sqldev:stmt*/start transaction;    -- Your SQL statements    /*sqldev:stmt*/commit;  

Found this information here.

Answer by Uttam Kumar for Disable autocommit in SQL Developer when using MySQL

Outils-->Preferences-->Fenetre SQL--> Validation automatique de transactions SQL uncheck the check box

Answer by Melinda for Disable autocommit in SQL Developer when using MySQL

Turn off the auto commit option in SqlDeveloper. Go to Tools -> Preferences -> Database -> ObjectViewer Parameters and uncheck the box Set Auto Commit On.

Answer by Harsh Gurudiwan for Disable autocommit in SQL Developer when using MySQL

connect sqlplus as sysadmin and type command "SET AUTOCOMMIT OFF" it is off as command. and if u want to check it is off or not the type command "show autocommit" and it show like "autocommit OFF"

Answer by Narendra Reddy for Disable autocommit in SQL Developer when using MySQL

You can turn on AutoCommit by clicking on Tools | Preferences Open the Database Tree select Worksheet parameters Check on the Autocommit in SQL Worksheet box

Answer by RobE for Disable autocommit in SQL Developer when using MySQL

In Oracle SQL Developer 4 the setting has moved:

Tools > Preferences > Database > Advanced > Autocommit

Default is off.

Alternative:

set autocommit off;  

Fatal error: Call to a member function getElementsByTagName() on a non-object in D:\XAMPP INSTALLASTION\xampp\htdocs\endunpratama9i\www-stackoverflow-info-proses.php on line 72