JDBC drivers
The following table provides an example JDBC URL for database targets. It also provides documentation and download URLs where available. For more information, consult the database vendor's documentation.
Database | JDBC URL |
---|---|
MySQL | jdbc:mysql://host[,failoverhost...][:port]/[database] [;property=value][;property=value] The following example URL connects to a MySQL server running on a host on IP address
|
Postgres | jdbc:postgresql://host:[port]/database [?propertyName1][=propertyValue1][&propertyName2][=propertyValue2] The following example URL connects to a Postgres server running on a host on IP address
|
Oracle | For Oracle, there are two possible connection styles: jdbc:oracle:<drivertype>:[username/password]@//host[:port]/service The following example URL connects, using a
jdbc:oracle:<drivertype>:@host[:port]:SID The following example URL connects, using a
|
Ingres | jdbc:ingres://host:[port]/database [;property=value][;property=value] The following example URL connects to an Ingres server running on a host on IP address
|
Sybase | jdbc:sybase:Tds:host[:port][/databasename] The following example URL connects to a Sybase server running on a host on IP address
|
MS SQL | jdbc:sqlserver://serverName[\instanceName][:portNumber] [;property=value][;property=value] The following example URL connects to an instance of MS SQL server called
|
JTDS | jdbc:jtds:servertype://server[:port][/database] [;property=value][;property=value] The following example URL connects using JTDS to an MS SQL server running on a host on IP address
No IPv6 support IPv6 access using JTDS is not currently possible. |
Comments