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!

how to connect to TCPS database with only SQL Developer for Visual Studio code

user11971075Nov 5 2025

Dear SQL Developer Ext.-Team

Thank you for providing this great extension.

If I choose TCP connection, it works well.
But if I choose to use TCPS connection, it is difficult.
If I search "tcps" in the official doc, I got no entry.
https://docs.oracle.com/en/database/oracle/sql-developer-vscode/25.3/

So I did some researches and got this Oracle paper on Easy Connection Plus.
https://download.oracle.com/ocomdocs/global/Oracle-Net-Easy-Connect-Plus.pdf

With Custom JDBC URL, the below string works.
jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCPS)(HOST = dbhost1)(PORT = 1525)) (SECURITY=(WALLET_LOCATION=C:\_local\oracle_tcps_wallet)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = service_hr)))

With Easy Connection Plus syntax, it does not work.
jdbc:oracle:thin:@tcps://dbhost1:1525/service_hr?wallet_location="C:\_local\oracle_tcps_wallet"

I wonder if your team can kindly publish those information in the official doc.

Best,
Kevin Zhang

Comments
Post Details
Added on Nov 5 2025
6 comments
131 views