Discussions
Categories
- 197.2K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Oracle Developer Tools for VS Code: How to configure auto-commit on each CTRL+E command?

Marcelo F. Ochoa
Member Posts: 20
Hi:
I am testing Oracle Developer Tools for VS Code on Linux + XE.
On each command submitted from the Editor pane by selecting the text and press CTRL+E the command is executed and automatically commit on the DB side.
How can I change auto-commit property on the connection setting?
Thanks in advance, Marcelo.
Answers
-
Thanks for the suggestion, Marcelo. We are going to do our best to get this into the July update. Stay tuned!
-
Hi Marcelo,
This feature/fix is now available in the new 19.3.3 version. Please try it out and let me know what you think.
- When executing multiple SQL statements (for example, running a script), auto commit automatically commits work after each statement. If auto commit is disabled, an explicit COMMIT or ROLLBACK statement can be used to control the behavior
- In your SQL file, enter SET AUTOCOMMIT OFF or SET AUTOCOMMIT ON and then right click and select Execute SQL from the menu. This autocommit setting will be in effect for the life of your connection and will override the default extension setting.
- To set the default for all SQL files opened with this extension, Press F1 to open the Command Palette and enter Preferences: Open Settings (UI) command
- Expand the Extensions node and select Oracle Developer Tools for VS Code Configuration.
- Check the SQLPlus:Auto Commit checkbox to enable auto commit and uncheck it to disable it
-
-
Hi,
Do you have plans to have a keyboard shortcut for commit and rollback?
Thanks