How to disable autorun in Eclipse Database Tools for Oracle?

Question

I am using Eclipse DTP for database queries. The default value is autocommit=true . 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

They say that I can use the additional property autocommit=false to disable autocommit. I added this property to "Driver Properties" → "Optional", but it still connects with autoload enabled.

• Why is this not working?
• How to disable auto-comment the correct way?

Thanks in advance.

PS I am using Eclipse Helios and Oracle 11 R1 11.1.0.7.0 and the ojdbc6 driver for 11.1.0.7.0.

Answer 1

Select a window → Settings → Data Management → SQL Development → SQL Editor → SQL / Scrapbooks Files and set “Manual” for connection fix mode

Answer 2

You will also need to restart Eclipse to activate your change.