Connection URL
- Last Updated: August 23, 2024
- 1 minute read
- DataDirect Connectors
- JDBC
- Oracle Database 6.0
- Documentation
The connection URL format for the driver is:
jdbc:datadirect:oracle://hostname:port[;property=value[;...]]
where:
- hostname
- is the IP address or host name of the server to which you are connecting. See "Using IP addresses" for details on using IP addresses.
- port
- is the number of the TCP/IP port.
-
property
=value - specifies connection properties. For a list of connection properties and their valid values, see "Connection property descriptions."
Notes
- Untrusted applets cannot open a socket to a machine other than the originating host.
- You can specify connection properties using tnsnames.ora files too. See "Using tnsnames.ora files" for more information.
- Connection property names are case-insensitive. For example,
Passwordis the same aspassword. - For connection properties that support string values, use the following escape sequence
to specify values containing leading or trailing spaces and curly brackets:
{value}. For example:User={hello }orPassword={{hello}}.
Example
Connection conn = DriverManager.getConnection
("jdbc:datadirect:oracle://server3:1521;
SID=ORCL;User=test;Password=secret")