1

We are trying to connect to Oracle using Oracle thin driver with SSL.

We are able to connect to Oracle using thin driver using following connect string to connect without SSL - jdbc:oracle:thin:@<host>:<port>:<service_name>.

Can anyone help with the connect string if we want to use SSL encryption?

What would be the parameters to be given in JDBC URL to make a connection?

Any help would be appreciated.

tomerpacific
  • 4,704
  • 13
  • 34
  • 52
Divya Garg
  • 11
  • 3

1 Answers1

0

The only thing you add to the connect string is PROTOCOL=tcps - everything else gets set up through JSSE properties. You'll have different choices depending on whether you just want to use SSL for encryption, or whether you also want it for authentication (and if so, whether you prefer Oracle Wallets or Java Keystores).

I feel like the official SSL with Oracle JDBC Driver whitepaper is a great walkthrough (this post is basically a non-pdf version of the same info). You might also find this Oracle blog post helpful.

There's several questions on here about this topic, they have some good code examples that might be helpful: 1 2 3 4

kfinity
  • 8,581
  • 1
  • 13
  • 20