skip to main content
Getting Started : Quick Start Connect : Connecting to a Database : 3. Passing the Connection URL : URL Formats: DataDirect Connect for JDBC Drivers
  
URL Formats: DataDirect Connect for JDBC Drivers
The following table shows the URL formats for DataDirect Connect for JDBC drivers, where:
*server_name identifies the server using one of the following methods:
IP address
Host name (if your network resolves host names to IP addresses) 1
*The integer value that appears after the server name is the port number on which the database is listening.
Table 3. URL Formats for DataDirect Connect for JDBC Drivers
Driver
URL Format
DB2 for Linux/UNIX/Windows 1
jdbc:datadirect:db2://server_name:50000;
DatabaseName=your_database
DB2 for z/OS and i 2
jdbc:datadirect:db2://server_name:446;
LocationName=db2_location
Informix
jdbc:datadirect:informix://server_name:1526;
InformixServer=your_server;DatabaseName=your_database
MySQL
jdbc:datadirect:mysql://server_name:3306
Oracle 3
jdbc:datadirect:oracle://server_name:1521;
ServiceName=your_servicename
PostgreSQL
jdbc:datadirect:postgresql://server_name:5432;
DatabaseName=your_database
Progress OpenEdge
jdbc:datadirect:openedge://server_name:2003;
DatabaseName=your_database
Microsoft SQL Server 4
jdbc:datadirect:sqlserver://server_name:1433
Sybase
jdbc:datadirect:sybase://server_name:5000

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 diver 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.


1 You can use the ping command to verify this feature (for example, ping server1). Verify that the correct IP address is returned in the reply from the command.