Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Auto commit broken in 21.4.0?

MagnusMGMar 28 2022

Since a couple of weeks I have had problems with auto commit in VS Code. It seems to coincide with the release of 21.4.0.
I develop my scripts in VS Code, but run SQL Developer in parallel, for quick checks. Sometimes (I have not quite figured out what controls this) changed I make in VS Code ('Execute SQL' or ctrl-e) are not visible in SQL Developer until I issue an explicit 'commit' in VS code.
I also sometimes end up with a lot of connections from VS Code to the database, visible when I execute a 'SELECT * FROM V$SESSION WHERE username =''<my user name>'''. They typically disappear if I close restart VS Code.
I did not have these problems before. Yes, the autocommit setting is on in my VS Code preferences.

Comments

Post Details

Added on Mar 28 2022
10 comments
422 views