Skip to Main Content

SQL Developer

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!

Connect using custom JDBC and via keyStore & trust store with Oracle SQL Developer

Simone GiussoNov 8 2024

Hi,

Via Java Code I can connect to the DB by setting the URL and some properties in a Properties Object:

Properties jdbcProp = new Properties();

jdbcProp.put("javax.net.ssl.trustStoreType", "JKS");
jdbcProp.put("javax.net.ssl.trustStore", “…”);
jdbcProp.put("javax.net.ssl.trustStorePassword", “…”);
jdbcProp.put("javax.net.ssl.keyStoreType", "JKS");
jdbcProp.put("javax.net.ssl.keyStore", “…”);
jdbcProp.put("javax.net.ssl.keyStorePassword", “…”);
try {
OracleDataSource dataSource = new OracleDataSource();
dataSource.setConnectionProperties(jdbcProp);
dataSource.setURL("myURL");
return dataSource;
} catch (SQLException e) {
throw new RuntimeException(e);
}

I would like to do the same via Oracle SQL Developer. For the reason I modified the sqldeveloper.conf by adding these rows at the end:

AddVMOption -Djavax.net.ssl.trustStore=...
AddVMOption -Djavax.net.ssl.trustStoreType=...
AddVMOption -Djavax.net.ssl.trustStorePassword=...
AddVMOption -Djavax.net.ssl.keyStore=...
AddVMOption -Djavax.net.ssl.keyStoreType=JKS
AddVMOption -Djavax.net.ssl.keyStorePassword=...

However:

What I'm doing wrong?

This post has been answered by Simone Giusso on Nov 11 2024
Jump to Answer
Comments
Post Details
Added on Nov 8 2024
2 comments
459 views