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 |
---|---|
IBM DB2 | jdbc:db2://host[:50001][/schema][:name=value[;name=value ...]] The following example URL connects to an IBM DB2 server running on a host on IP address jdbc:db2://192.168.1.100:50001/schema_name:user=fred;password=password;SSL=true
|
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
|
Microsoft SQL Server | jdbc:sqlserver://serverName[\instanceName][:portNumber] [;property=value][;property=value] The following example URL connects to an instance of MS SQL server called
|
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
|
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
For more information about setting up both styles in BMC Discovery, see Multiple Drivers Using the Same JAR (Oracle). |
PostgreSQL | 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
|
Sybase | jdbc:sybase:Tds:host[:port][/databasename] The following example URL connects to a Sybase server running on a host on IP address
|
Comments
Log in or register to comment.