The drivers support Internet Protocol (IP) addresses in IPv4 and IPv6 format as described in the following tables. To connect to IPv6 addresses, the client or application server requires J2SE 5.0 or higher.
Table 8. IP Address Formats Supported by DataDirect Connect for JDBC
Driver
IPv4
IPv6
DB2
All supported versions
DB2 V9.1 and higher for Linux/UNIX/Windows
DB2 V9.1 for z/OS
DB2 for i V5R4 and higher
Informix
All supported versions
Informix 10 and higher
MySQL
All supported versions
Not supported
Oracle
All supported versions
Oracle 11g R2
PostgreSQL
All supported versions
PostgreSQL 8.2 and higher
Progress OpenEdge
All supported versions
Progress OpenEdge 10.1A and higher
Microsoft SQL Server
All supported versions
Microsoft SQL Server 2005 and higher
Sybase
All supported versions
Sybase 12.5.2 and higher
Table 9. IP Address Formats Supported by DataDirect Connect XE for JDBC
Driver
IPv4
IPv6
Driver for Apache Hive
All supported versions
Not supported
Greenplum
All supported versions
Not supported
Salesforce
All supported versions
All supported versions
If your network supports named servers, the server name specified in the connection URL or data source can resolve to an IPv4 or IPv6 address. For example, the server name DB2Server in the following URL can resolve to either type of address:
Alternatively, you can specify addresses using IPv4 or IPv6 format in the server name portion of the connection URL. For example, the following connection URL specifies the server using IPv4 format:
You also can specify addresses in either format using the ServerName data source property. The following example shows a data source definition that specifies the server name using IPv6 format:
DB2DataSource mds = new DB2DataSource(); mds.setDescription("My DB2DataSource"); mds.setServerName("[ABCD:EF01:2345:6789:ABCD:EF01:2345:6789]"); mds.setPortNumber(50000); ...
Note: When specifying IPv6 addresses in a connection URL or data source property, the address must be enclosed by brackets.
In addition to the normal IPv6 format, the drivers support IPv6 alternative formats for compressed and IPv4/IPv6 combination addresses. For example, the following connection URL specifies the server using IPv6 format, but uses the compressed syntax for strings of zero bits: