Change a JDBC Data Source Configuration

35px|link= There are two modules that contain JDBC data source configuration information:

• com.informiam.platform/platform-datasource-service/<version>/rar
• com.informiam.ea/metric-graphing-datasource/<version>/rar

There is no FA data source starting in release 8.5.0; earlier releases of Advisors included an FA data source.

You must re-deploy each instance of the preceding modules for which you modify the geronimo-ra.xml descriptor (see the following procedures).

Before you perform either of the procedures below, read the following carefully:

• Perform the following procedure offline; Geronimo must be fully stopped.
• Ensure that Advisors NT service is not running.
• After you stop Geronimo, Genesys recommends that you take a complete directory backup of <GCTI>/Advisors/ before you do any manual operations.

<tabber>

Advisors Platform=

1. Copy geronimo-ra.xml from **/GCTI/Advisors/geronimo-tomcat6-minimal-2.2.1/repository/com/ informiam/platform/platform-datasource-service/<version>/platform- datasource-service-<version>.rar/rar/META-INF to **/GCTI/Advisors/platform-datasource.

2. Edit the descriptor (geronimo-ra.xml that you copied to **/GCTI/Advisors/platform-datasource), as required.

3. Ensure the Advisors service is stopped before proceeding.

4. Open a command prompt window.

5. Navigate to the **/GCTI/Advisors/geronimo-tomcat6-minimal-2.2.1/bin directory.

6. Run the following command: java -jar deployer.jar --offline --user system --password manager redeploy ../../platform-datasource/platform-datasource.rar ../../platform-datasource/geronimo-ra.xml Note: In the preceding command line, ../../platform-datasource/geronimo-ra.xml is the path to the recently-edited descriptor.

7. Start the Advisors service and verify that the reconfigured data source works.

8. If the database parameters require further updates, edit the data source descriptor file and run the command again to re-deploy it. For example: Edit ../../platform-datasource/geronimo-ra.xml and run the command again.

|-| Metric Graphing Datasource=

1. Copy geronimo-ra.xml from **/GCTI/Advisors/geronimo-tomcat6-minimal-2.2.1/repository/com/Informiam/ea/metric-graphing-datasource/<version>/ metric-graphing-datasource-<version>.rar /rar/META-INF to **/GCTI/Advisors/metric-graphing-datasource.

2. Edit the descriptor (geronimo-ra.xml that you copied to **/GCTI/Advisors/metric-graphing-datasource), as required.

3. Ensure the Advisors service is stopped before proceeding.

4. Open a command prompt window.

5. Navigate to the **/GCTI/Advisors/geronimo-tomcat6-minimal-2.2.1/bin directory.

6. Run the following command: java -jar deployer.jar --offline --user system --password manager redeploy ../../metric-graphing-datasource/metric-graphing-datasource.rar ../../metric-graphing-datasource/geronimo-ra.xml Note: In the preceding command line, ../../metric-graphing-datasource/geronimo-ra.xml is the path to the recently-edited descriptor.

7. Start the Advisors service and verify that the reconfigured data source works.

8. If the database parameters require further updates, edit the data source descriptor file and run the command again to re-deploy it. For example: Edit ../../metric-graphing-datasource/geronimo-ra.xml and run the command again.