Jump to: navigation, search

Change a JDBC Data Source Configuration

New3.png 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.

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.

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.

This page was last modified on June 3, 2014, at 11:51.

Feedback

Comment on this article:

blog comments powered by Disqus