skip to main content
Getting Started : Using the Drivers : Connecting Using the JDBC Driver Manager : Specifying Connection URLs : URL Format: DataDirect Connect for JDBC
  
URL Format: DataDirect Connect for JDBC
Syntax
jdbc:datadirect:drivername://server_name:port[;property=value[;...]]
where:
drivername
is the name of the driver, for example, sybase.
server_name
is the IP address or TCP/IP server 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. Multiple properties are separated by a semi-colon. For a list of connection properties supported for each driver and their valid values, see the appropriate driver chapter.
Notes
*Untrusted applets cannot open a socket to a machine other than the originating host.
The following table shows some typical driver connection URLs for each driver.
Table 6. Example URLs for DataDirect Connect for JDBC
Driver
URL
DB2 for Linux/UNIX/Windows 1
jdbc:datadirect:db2://server1:50000;DatabaseName=jdbc;
User=test;Password=secret
DB2 for z/OS and i 2
jdbc:datadirect:db2://server1:446;LocationName=Sample;
User=test;Password=secret
Informix
jdbc:datadirect:informix://server4:1526;
InformixServer=ol_test;DatabaseName=your_database;
User=test;Password=secret
MySQL
jdbc:datadirect:mysql://server1:3306;User=test;
Password=secret
Oracle 3
jdbc:datadirect:oracle://server3:1521;ServiceName=ORCL;
User=test;Password=secret
PostgreSQL
jdbc:datadirect:postgresql://server1:5432;DatabaseName=jdbc;
User=test;Password=secret
Progress OpenEdge
jdbc:datadirect:openedge://server1:2003;User=test;
Password=secret
Microsoft SQL Server 4
jdbc:datadirect:sqlserver://server1:1433;User=test;
Password=secret
Sybase
jdbc:datadirect:sybase://server2:5000;User=test;
Password=secret

1 See the DB2 driver chapter for more information about creating DB2 packages.

2 See the DB2 driver chapter for more information about creating DB2 packages.

3 See the Oracle driver chapter for instructions on retrieving connection information from an Oracle tnsnames.ora file.

4 See the SQL Server driver chapter for instructions on connecting to named instances.