5.4. Editing the Database

Dashbuilder requires the JBoss BPM Suite to have history log's database tables. It is mandatory to deploy the Human Task console (or a superset, i.e: kie-wb) first. Otherwise, the Dashboard will not be initialized correctly and it will not be possible to display its key performance indicators.
By default, the application is configured to use a datasource with the following JNDI name: 
java:jboss/datasources/ExampleDS
This is specified in JBoss EAP's configuration file; for example, standalone.xml.

Note

This datasource is intended for development/demo purposes; it is present by default in any JBoss installation.
If you want to deploy on a database different from H2 like Oracle, MySQL, Postgres or MS SQL Server, please perform the following steps:

Procedure 5.1. Changing Database

  1. Install the database driver on JBoss (refer to JBoss driver documentation).
  2. Create an empty database and a JBoss data source which connects to the database driver.
  3. Modify the file dashbuilder.war/WEB-INF/jboss-web.xml: 
    <jboss-web>
   <context-root>/dashbuilder</context-root>
   <resource-ref>
       <res-ref-name>jdbc/dashbuilder</res-ref-name>
       <res-type>javax.sql.DataSource</res-type>
       <jndi-name>java:jboss/datasources/myDataSource</jndi-name>
   </resource-ref>
   ...
  4. Replace the jndi-name parameter value by the JNDI path of the JBoss data source you've just created.
  5. Modify the file dashbuilder.war/WEB-INF/jboss-deployment-structure.xml
  6. Add the following snippet of configuration inside the deployment tag, where jdbcDriverModuleName is the name of the JBoss JDBC driver module: 
      <dependencies>
      <module name="jdbcDriverModuleName" />
  </dependencies>