Enterprise Administration Guide › Configuring SAM Endpoints › Prepare a JBoss Application to Use a Database (JDBC) Password Consumer › Customize the Datasource Configuration files for Oracle

Customize the Datasource Configuration files for Oracle

You can configure a JDBC database password consumer to replace hard-coded passwords in applications that use JDBC to connect to an Oracle database. Complete the following steps after you have prepared the endpoint to use a JDBC password consumer.

To customize the datasource configuration files for Oracle

1. Locate the <xa-datasource-class> tag and replace the default value with the CAJDBCDataSource class properties. For example:

   <xa-datasource-class>com.ca.ppm.clients.jdbc.CAJDBCDataSource</xa-datasource-class>
   

   Important! The property names must remain in the same case as the default value.

2. Locate all the <xa-datasource-property name=> tags. For example:

   <xa-datasource-property name="URL">jdbc:oracle:oci8:@tc</xa-datasource-property>
   <xa-datasource-property name="User">scott</xa-datasource-property>
   <xa-datasource-property name="Password">tiger</xa-datasource-property>
   

3. Formulate the properties into a single string. For example:

   <xa-datasource-property name="CAJDBCProperties">CAJDBCPropertyRealDatasourceClass="oracle.jdbc.xa.client.OracleXADataSource";URL="jdbc:oracle:oci8:@tc";User="scott";Password="tiger";</xa-datasource-property>
   

4. Start CA ControlMinder.

   You have customized the datasource configuration files for Oracle. You must now create a password consumer for the application in CA ControlMinder Enterprise Management. You start the application after you create the password consumer.