Disable autocommit in SQL Developer when using MySQL

mysql oracle-sqldeveloper autocommit
Michael picture Michael · Jul 24, 2013 · Viewed 45.5k times · Source

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

rob2universe picture rob2universe · May 26, 2016

In Oracle SQL Developer 4 the setting has moved:

Tools > Preferences > Database > Advanced > Autocommit

Default is off.

Alternative:

set autocommit off;

Related questions

How do you connect to a MySQL database using Oracle SQL Developer?

I have Oracle SQL Developer already installed and am able to connect to and query Oracle databases. Using Help -> Check for Updates I was able to install the Oracle MySQL Browser extension but there are no connection options …

Read More
String out of index with SQL developer

I got below message from sql developer when I try to access. I did just nothing special. my connection info like below Connection name : z*sch*** Username : root Password : it just numbers and characters(en) Connect Type : basic Role : default …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More