HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Disable autocommit for SQL Server connection in Oracle SQL Developer

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
serversqldisablefordeveloperautocommitoracleconnection

Problem

I am using Oracle's SQL Developer to execute queries against my SQL Server 2008 database as I simply can't work with SSMS as long as it doesn't support Ctrl + Return to execute statements...

Anyway, statements in SQL Server seem to be autocommit even when using Oracle SQL Developer. Is it possible to change this on a permanent basis? BEGIN TRANSACTION is not a solution for me.

Solution

SQL Server uses autocommit mode by default. This cannot be changed permanently.

There are two ways implicit transactions (non-autocommit) can be turned on:

-
At the server level such that new sessions use it by default, using sp_configure 'user options' -- this may or may not work depending on how SQL Developer was implemented.

-
For a session, using SET IMPLICIT_TRANSACTIONS ON.

Context

StackExchange Database Administrators Q#21424, answer score: 2

Revisions (0)

No revisions yet.