Administrator

Enabling the Oracle JDBC Driver

To use an Oracle database, enable the Oracle JDBC driver that you installed.

Prerequisites

  • Configure an Oracle database.
  • Install an Oracle JDBC driver.

Procedure

  1. Open the <SMSBUILDER_HOME>/conf/cfgbackup/service.dsprovider.properties file.
  2. Remove the comment indicators from the Oracle configuration, and enter the password you created for the mwiz2 user:
    • If the password is encrypted, replace XXX with the encrypted password.
    • If the password is plain text, replace {enc}XXX with the password.
    # Oracle
    driverClassName=oracle.jdbc.driver.OracleDriver
    url=jdbc:oracle:thin:@localhost:1521:xe
    username=mwiz2
    password={enc}XXX
    validationQuery=select 1 from DUAL
  3. Comment out the SQL Anywhere configuration, and save the file.