Monday, September 12, 2016

JDBC Connection String for Oracle

... It's been a while I hadn't had to do it. Hence: a reminder on how a JDBC connection string looks like for Oracle: 

Here's the template: 
jdbc:oracle:{driver:variants:thin:Thin=thin,OCI=oci,OCI8=oci8}:[{user}[/{password}]]@//{host::localhost}?[:{port::1521}]/{service:identifier:XE

...and here's an example:

jdbc:oracle:thin:myuser/mypwd@localhost:1521:XE