I want to connect to a database that uses TCPS and a Java Key Store.
Currently, I'm using Oracle SQL Developer with a modified shortcut target:
C:\Oracle\sqldeveloper\sqldeveloper.exe --AddVMOption=-Djavax.net.ssl.trustStore=C:\Oracle\sqldeveloper\rds.jks --AddVMOption=-Djavax.net.ssl.trustStorePassword=jkspassword -multi
And a custom JDBC string for my connection:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=mydatabasehost.com)(PORT=2484))(CONNECT_DATA=(SID=mydatabasesid)))
That works like a charm, but I'd like to use the new VSCode extension and was wondering how to replicate such a connection with the extension.
I tried adding the VM Options to the Advanced tab of the connection, but that doesn't seem to work (or I did it wrong, who knows).