I use Eclipse DTP for database queries. The connection is set to autocommit=true
by default. I would like to disable autocommit.
I read this: http://download.oracle.com/docs/cd/E13095_01/oepe-website/db-tools/gettingStarted/files/gettingStarted.html
There is said, that I can use the additional property autocommit=false
to disable autocommit. I added this property at "Driver Properties" -> "Optional", but it still connects with autocommit enabled.
Thanks in advance.
P.S. I use Eclipse Helios and Oracle 11 R1 11.1.0.7.0 and the driver ojdbc6 for 11.1.0.7.0.
Chose Window -> Preferences -> Data Management -> SQL Development -> SQL Editor -> SQL Files/Scrapbooks and Set "Manual" for Connection Commit Mode
You will also need to restart Eclipse to get your change to activate.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With