1. Administrator's Guide
  2. Getting Started with Planning
  3. Setting Application and System Properties
  4. Changing the JDBC Driver

Changing the JDBC Driver

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

Table 2-2 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.