How to establish secure(SSL) connection to oracle database when using oracle.ucp.jdbc.PoolDataSource?

Question

My application uses oracle.ucp.jdbc.PoolDataSource to connect to database. Able to connect to database with normal connection. How to establish secure SSL connection to oracle database?

Answer 1

Can you review JDBC developer's guide for the instructions? You can also review this technical brief, it is old, but, you can still use it.

If you are using JKS or Oracle Wallets, you can also check out the videos on www.oracle.com/jdbc.

Answer 2

Just need to set PROTOCOL in connect string(url) to tcps and set truststore values in the command line.

Answer 3

Connection url should of the following format where we can mention protocol and port.

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<server>)(PORT=1522))(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME=<service name>)))