Skip to content

Support Oracle EZConnect url format #1152

@tsegismont

Description

@tsegismont

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"

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions