Chapter 5. Configuring JDBC data sources for KIE Server

Procedure

1. Complete the following steps to prepare your database:

   1. Extract rhpam-7.8.0-add-ons.zip in a temporary directory, for example TEMP_DIR.
   2. Extract TEMP_DIR/rhpam-7.8.0-migration-tool.zip.
   3. Change your current directory to the TEMP_DIR/rhpam-7.8.0-migration-tool/ddl-scripts directory. This directory contains DDL scripts for several database types.

   4. Import the DDL script for your database type into the database that you want to use, for example:

      psql jbpm < /ddl-scripts/postgresql/postgresql-jbpm-schema.sql

      Copy to Clipboard Toggle word wrap
      Note

      If you are using PostgreSQL or Oracle in conjunction with Spring Boot, you must import the respective Spring Boot DDL script, for example /ddl-scripts/oracle/oracle-springboot-jbpm-schema.sql or /ddl-scripts/postgresql/postgresql-springboot-jbpm-schema.sql.

2. Open EAP_HOME/standalone/configuration/standalone-full.xml in a text editor and locate the <system-properties> tag.

3. Add the following properties to the <system-properties> tag where <DATASOURCE> is the JNDI name of your data source and <HIBERNATE_DIALECT> is the hibernate dialect for your database.

   Note

   The default value of the org.kie.server.persistence.ds property is java:jboss/datasources/ExampleDS. The default value of the org.kie.server.persistence.dialect property is org.hibernate.dialect.H2Dialect.

   <property name="org.kie.server.persistence.ds" value="<DATASOURCE>"/>
   <property name="org.kie.server.persistence.dialect" value="<HIBERNATE_DIALECT>"/>

   Copy to Clipboard Toggle word wrap

   The following example shows how to configure a datasource for the PostgreSQL hibernate dialect:

   <system-properties>
       <property name="org.kie.server.repo" value="${jboss.server.data.dir}"/>
       <property name="org.kie.example" value="true"/>
       <property name="org.jbpm.designer.perspective" value="full"/>
       <property name="designerdataobjects" value="false"/>
       <property name="org.kie.server.user" value="rhpamUser"/>
       <property name="org.kie.server.pwd" value="rhpam123!"/>
       <property name="org.kie.server.location" value="http://localhost:8080/kie-server/services/rest/server"/>
       <property name="org.kie.server.controller" value="http://localhost:8080/business-central/rest/controller"/>
       <property name="org.kie.server.controller.user" value="kieserver"/>
       <property name="org.kie.server.controller.pwd" value="kieserver1!"/>
       <property name="org.kie.server.id" value="local-server-123"/>
   
       <!-- Data source properties. -->
       <property name="org.kie.server.persistence.ds" value="java:jboss/datasources/KieServerDS"/>
       <property name="org.kie.server.persistence.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>
   </system-properties>

   Copy to Clipboard Toggle word wrap