JDBC Drivers
During configuration, on the Configure Database page, click Advanced to specify additional JDBC parameters, which are used by Oracle Enterprise Performance Management System JDBC drivers to connect to the database.
The following table describes the format to use to enter the parameters if you are using JDBC drivers.
Database | Format |
---|---|
Oracle Database |
jdbc:oracle:thin:@hostname:port:SID
|
SQL Server |
jdbc:weblogic:sqlserver://hostname:port;databaseName=databaseName
|
The following table describes additional information about the parameters:
Property | SQL Server | DB2 |
---|---|---|
LOADLIBRARYPATH | Yes | Yes |
MAXPOOLEDSTATEMENTS | Yes | Yes |
ALTERNATESERVERS | Yes | Yes |
CONNECTIONRETRYCOUNT | Yes | Yes |
CONNECTIONRETRYDELAY | Yes | Yes |
LOADBALANCING | Yes | Yes |
DYNAMICSECTIONS | Yes | |
CREATEDEFAULTPACKAGE | Yes | |
REPLACEPACKAGE | Yes | |
DATABASENAME | Yes | Yes |
For Oracle Database parameters, see the Oracle Thin JDBC Driver documentation.
For more information, see the Oracle® Database JDBC Developer's Guide 11g Release 2 (11.2): http://docs.oracle.com/cd/E11882_01/java.112/e16548/urls.htm#BEIJFHHB.