Skip to Main Content

SQL Developer 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.

Attach/Detach connection

Itamar TzadokMay 29 2025

The extension appears to offer two distinct commands: sqldeveloper.worksheet.attachConnection and sqldeveloper.worksheet.detachConnection. But in effect they behave the same, namely, they open the connection selector with the active connection, if any, to detach and the other connections to attach. This seems to add an unnecessary click to detach and it clutters the list to attach with additional two lines, the attached connection and a message that selecting it will detach it. I don't think we need to select the active connection in order to detach it. It should be done directly on using the command. Then the list to attach won't need to show the active connection, or it can still show it, but selecting will attach a new instance of that connection (that is, detach and reattach if already active).

Can we simplify accordingly?

Additionally, the order of connections in the selector seems to change after each selection. Whatever the logic there is, I think that it would be more productive to fix the order lexicographically, same as it is displayed in the connections pane of the extension. This would make it easier and safer to select the desired connection, especially since we don't currently have any other cues to distinguish between connections.

Comments
Post Details
Added on May 29 2025
3 comments
96 views