Changing the JDBC Driver

By default, Planning uses the embedded Oracle JDBC driver. To change the JDBC driver, update the JDBC property using these values:

Table 16. JDBC Property Values

JDBC Driver

RDB_SERVER_URL

RDB_DRIVER

Oracle Thin

jdbc:oracle:thin:@%SERVER_NAME%:1521:%DB_NAME%

oracle.jdbc.driver.OracleDriver

DB2 native

jdbc:db2:%DB_NAME%

COM.ibm.db2.jdbc.app.DB2Driver

DB2 native for remote DB2 server

jdbc:db2://myhost.mydomain.com:6789/%DB_NAME"

COM.ibm.db2.jdbc.net.DB2Driver

Database driver names and URLs are stored in the HSPSYS_DATASOURCE database table.

  After changing JDBC properties, to make the necessary third-party files accessible to the Planning server:

  1. Locate the .jar file (for Oracle) or .zip file (for DB2):

    • For Oracle, find classes12.jar in the OraHome/jdbc/lib directory.

    • For DB2, find db2java.jar or db2java.zip in the /Program Files/sqllib/java directory.

  2. Copy the .jar or .zip file from the previous step to the Web application server destination directory. For example:

    1. Extract the .ear file.

    2. Copy the .jar or .zip file to the HPDomain/applications directory.

    3. Add the file to the CLASSPATH in startHPServer.cmd.

  3. Stop and restart the Web application server.