JDBC drivers
The following table provides an example JDBC URL for database targets. It also provides documentation and download URLs where available. When selecting the appropriate driver, note that BMC Atrium Discovery uses JDK 1.6. Consult the database vendor's documentation for further information.
Database |
JDBC URL |
---|---|
Informix |
jdbc:informix-sqli://host[:port]/database:INFORMIXSERVER=servername [;property=value][;property=value]
|
MySQL |
jdbc:mysql://host[,failoverhost...][:port]/[database] [;property=value][;property=value]
|
Postgres |
jdbc:postgresql://host:[port]/database [?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]
|
Oracle |
For Oracle there are two possible connection styles: jdbc:oracle:<drivertype>:[username/password]@//host[:port]/service jdbc:oracle:<drivertype>:@host[:port]:SID |
Ingres |
jdbc:ingres://host:[port]/database [;property=value][;property=value] |
Sybase |
jdbc:sybase:Tds:host[:port][/databasename]
|
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] No IPv6 support IPv6 access using JTDS is not currently possible. |
Comments