Thank you for this tutorial!
I'm having an issue using transactions though
I'm using sqldeveloper 126.96.36.199 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 :
but at "start transaction" i get
Unable to open file: "TRANSACTION.sql"
Any idea how to do transactions or disable the auto-commit with this driver?
Keep Up with TechRepublic