-
Notifications
You must be signed in to change notification settings - Fork 206
Closed
Description
The Oracle client only supports the format that defines a service id (SID).
https://docs.oracle.com/en/database/oracle/oracle-database/21/jajdb/index.html
EZConnect Format
In EZConnect format Hostname, Port and Service Name can be configured using a simple syntax.
Since 19c, the connection properties can be added at the end of the URL.
The syntax uses '?' to indicate start of conection properties and '&' as a delimiter between each property.Syntax :
jdbc:oracle:thin:@[[protocol:]//]host1[,host2,host3][:port1][,host4:port2] [/service_name][:server_mode][/instance_name][?connection
properties]Examples:
jdbc:oracle:thin:@mydbhost:1521/mydbservice jdbc:oracle:thin:@tcp://mydbhost:1521/mydbservice jdbc:oracle:thin:@tcp://mydbhost1,mydbhost2:1521/mydbservice jdbc:oracle:thin:@tcp://mydbhost1:5521,mydbhost2:1521/mydbservice jdbc:oracle:thin:@tcp://mydbhost1:5521/mydbservice:dedicated jdbc:oracle:thin:@mydbhost1:5521/mydbservice?oracle.net.httpsProxyHost=myproxy&oracle.net.httpsProxyPort=80 jdbc:oracle:thin:@tcps://mydbhost1:5521/mydbservice?wallet_location=/work/wallet jdbc:oracle:thin:@tcps://mydbhost1:5521/mydbservice?wallet_location=/work/wallet&ssl_server_cert_dn="Server DN"