skip to main content
Quick Start: Progress DataDirect for JDBC for Oracle Driver : Connecting to a DataSource : Connecting using the DriverManager : Passing the connection URL
  

Try DataDirect Drivers Now
Passing the connection URL
After setting the CLASSPATH, the required connection information needs to be passed in the form of a connection URL.
jdbc:datadirect:oracle://hostname:port[;property=value[;...]]
where:
hostname
is the IP address or host name of the server to which you are connecting.
port
is the number of the TCP/IP port.
property=value
specifies connection properties.

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" in Progress DataDirect for JDBC for Oracle Driver User's Guide for more information.

Example

Connection conn = DriverManager.getConnection
("jdbc:datadirect:oracle://server3:1521;
SID=ORCL;User=test;Password=secret");