Executing CMRF as a standalone application

Configuring the database connection

The CMRF is executed as a standalone Java application, without application server.

The database connection needs to be configured on both the ConSol CM and the CMRF side.

ConSol CM

The database connection is configured in the cm6-config.properties file in the application server where ConSol CM run:

1. Uncomment the line for the CMRF transactional datasource in the cm6-config.properties file located in <JBOSS_HOME>\bin and provide the settings for your database:

   • cmrf.xa.datasource.url
     URL of the transactional CMRF datasource.

     Example values:

     • MySQL 5: jdbc:mysql://localhost/cmdatabase?serverTimezone=Europe/Berlin
     • MySQL 8: jdbc:mysql://localhost/cmdatabase?characterEncoding=UTF-8&serverTimezone=Europe/Berlin
     • Oracle: jdbc:oracle:thin:@localhost:1521/SERVICE_NAME
     • Microsoft SQL Server: jdbc:sqlserver://localhost:1433;databaseName=cmdatabase
     • PostgreSQL: jdbc:postgresql://localhost:5432/cmdatabase

   • cmrf.xa.datasource.username
     Name of the database user for CMRF

   • cmrf.xa.datasource.password
     Password of the database user for CMRF

CMRF

The database connection is configured in the cmrf.properties file. This file needs to be saved in the same location from where the cmrf-application-package-app-<CM_VERSION>.jar is started.

1. Uncomment the line with the JDBC connection for your database system, starting with spring.datasource.url.

2. Enter the URL of your datasource

   Example values:

   • MySQL: jdbc:mysql://localhost/cmrf
   • Oracle: jdbc:oracle:thin:@localhost:1521/SERVICE_NAME
   • Microsoft SQL Server: jdbc:sqlserver://localhost;databaseName=cmrf
   • PostgreSQL: jdbc:postgresql://localhost/cmrf

3. Provide the username and password:

   • spring.datasource.username
     Name of the database user for CMRF

   • spring.datasource.password
     Password of the database user for CMRF

If needed, you can add settings to override the default logging configuration to this file.

Starting the CMRF

You need to start both the ConSol CM server and the CMRF server.

ConSol CM server

Run the following commands to start the JBoss server. Alternatively you can configure JBoss to run as a service (similar to autostart of ConSol CM, see Autostarting the CM server).

Example start command on Windows:

<JBOSS_HOME>\bin\standalone.bat -P <JBOSS_HOME>\bin\cm6-config.properties -c cm6-dwh-<DB>.xml

Example start command on Linux:

<JBOSS_HOME>/bin/standalone.sh -P <JBOSS_HOME>/bin/cm6-config.properties -c cm6-dwh-<DB>.xml

Replace cm6-dwh-<DB>.xml with the ConSol CM configuration file for your database:

• cm6-dwh-mysql-5.xml for MySQL 5
• cm6-dwh-mysql-8.xml for MySQL 8
• cm6-dwh-oracle.xml for Oracle
• cm6-dwh-mssql.xml for Microsoft SQL Server

• cm6-dwh-postgresql.xml for PostgreSQL

CMRF application

Run the following command to start the CMRF:

java -jar cmrf-application-package-app-<version>.jar

On MySQL, you need to provide the path to the My SQL driver in the start command. In the following example, the connector is saved in the same directory from which the application is started:

java -Dloader.path=mysql-connector-java-8.0.22.jar -jar cmrf-application-package-app-<version>.jar