Discussion on:

Configuring SQL Developer for MySQL

Somebody from Oracle's SQL Developer team contacted me and said that the next version of the product will simplify the process even further. It will make the MySQL JDBC drivers available thru the automated update mechanism.

So instead of having to go thru the steps I outlined above, you'll just be able to make a couple clicks thru the update screens and it will install the MySQL JDBC JAR automatically.

0 Votes

+ -

can't do transactions or disable autocommit

vpa2013 3rd Jul 2011

Hello,
Thank you for this tutorial!
I'm having an issue using transactions though
I'm using sqldeveloper 3.0.0.4 with connector/j mysql-connector-java-5.1.16-bin.jar
I want to be able to do transactions. I'm just used to playing around with queries and being able to rollback at any point.
I've tried disabling auto-commit options in sqldeveloper but it's overriden at driver level
I can't event change it explicitely in the session
set autocommit off
-> Set autocommit script command forced off, as connection level autocommit is on

I've read that innodb database had a strange way of handling transactions from multiple sources (see http://forums.oracle.com/forums/thread.jspa?messageID=1658148&) so i gave up trying to disable auto-commit and settled for using explicit transaction declaration when needed :
start transaction;
...
commit;

but at "start transaction" i get
Error report:
Unable to open file: "TRANSACTION.sql"

Any idea how to do transactions or disable the auto-commit with this driver?
Thanks

0 Votes

+ -

Thank you!

MariposaLibre 23rd Nov 2011

I want to thank you for this article - after adding this dependency to JAR file with driver "automagically" a new tab 'MySQL' in "New / Select Database Connection" showed up!