• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1747
  • Last Modified:

Disable auto commit on Oracle SQL Developer with DB2

Is there any way to DISABLE auto commit on Oracle SQL Developer with DB2? SQL Developer is 4.0.3.16 and DB2 is 9.7.0.4

Usual icons for Commit and Rollback (in SQL File window) are grayed out, and in Tools -> Preferences -> Database -> Advanced -> Autocommit is deselected.

On DB2 level, autocommit is OFF (UPDATE COMMAND OPTIONS USING c OFF), setting is checked.
0
KPax
Asked:
KPax
  • 2
  • 2
1 Solution
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi Nenad,

I suspect that your issue is with the JDBC driver, where autocommit=true is the default.  It's not your application (SQL Developer) that is issuing the commit, it's the driver.

This came up a while back.  Autocommit could be disabled in the application code, but I don't know how this translates to SQL Developer.  

  http://www.experts-exchange.com/Programming/Languages/Scripting/PHP/Q_25489914.html
0
 
KPaxAuthor Commented:
So, in essence, I can't do nothing about it?
0
 
Kent OlsenData Warehouse Architect / DBACommented:
I won't go that far, but I don't know of anything.

The driver can be configured to not perform the autocommit.  But one of the driver's class methods needs to be called.

  conn.setAutoCommit (false);

I'm not sure that it can be done through SQL Developer.
0
 
KPaxAuthor Commented:
In IBM Data Studio there are detailed settings for JBDC driver, but none of those are present in Oracle SQL Developer, or at least none that I am ware of .
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now