Configure Java Database Connectivity (JDBC)

Scenario Guide › Scenario Overview › Installing CA GovernanceMinder and Oracle Real Application Clusters (RAC) › How to Install CA GovernanceMinder and Oracle RAC › Configure Java Database Connectivity (JDBC)

Configure Java Database Connectivity (JDBC)

You configure the JDBC to connect to a database and increase default cache settings. JDBC, an API for the Java programming language, defines how a client accesses a database by providing querying methods and updating database data.

Follow these steps:

Backup the eurekify-ds.xml and wp-ds.xml files from the following folder:
```
gm_install/CA/RCM/Server/eurekify-jboss/server/eurekify/deploy/
```
Update JDBC URL values to define Oracle RAC database cluster rac1-vip and rac2-vip. Do the following:
1. Locate the following elements in both files:
```
<connection-url>jdbc:oracle:thin:@rac:1521/RCMDB1</connection-url>
```
2. Replace with the following text that defines the JDBC URL to Oracle RAC cluster rac1-vip and rac2-vip databases:
```
<connection-url>jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
```
```
(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip.localdomain) (PORT=1521))
```
```
(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip.localdomain) (PORT=1521))
```
```
(CONNECT_DATA=(SERVICE_NAME=RCMDB1)))</connection-url>
```
3. Save and close the files.
  The JDBC URL values define Oracle RAC database cluster rac1-vip and rac2-vip.
Reset the CA GovernanceMinder cache limits, as follows:
1. Edit the ehcache-sageDal.xml file on the CA GovernanceMinder server:
  - For JBoss, this file is found in the following location:
```
jboss_install\server\all\farm\eurekfiy.war\WEB-INF\classes\
```
  - For WebSphere, this file is located in the eurekify.ear file found in the following location:
```
/eurekify.war/WEB-INF/classes
```
2. In the defaultCache entry, change the following attribute:
  
  maxElementsInMemory
  
  Defines the maximum number of elements stored in cache memory.
  
  We recommend that you set this field using the following formula:
  
  maxElementsInMemory = total number of entities * 3
  
  For example, if you have one universe with 500,000 users and 500,000 roles, set maxElementsInMemory to 3,000,000 elements.
  
  If you have two universes, each with 500,000 users and 500,000 roles, set maxElementsInMemory to 6,000,000 elements.
3. Save and close the file.
  The CA GovernanceMinder cache limits are reset.
  
  You have configured the JDBC. You now verify a successful CA GovernanceMinder installation.