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.

Task

Open the BRAND_HOME/conf/cfgbackup/service.dsprovider.properties file.
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
```

Comment out the Derby configuration, and save the file:

# DERBY EMBEDDED  – For development and Testing only!!!!!   
#driverClassName=org.apache.derby.jdbc.EmbeddedDriver   
#url=jdbc:derby:mwiz2   
#username=mwiz2   
#password=sql   
#validationQuery=select 1 from sysibm.sysdummy1