Is the SQL to create the BPMS / BRMS database available?

Solution Unverified - Updated

Environment

  • JBoss BRMS
    • 5.x
    • 6.x
  • JBoss BPM Suite
    • 6.x
  • Red Hat Decision Manager - RHDM
    • 7.x
  • Red Hat Process Automation Manager - RHPAM
    • 7.x

Issue

I am trying to configure JBoss Enterprise BRMS to use SQL Server as it's DB repository. However, I wish that the database tables/indexes (to be used by JBoss Enterprise BRMS) are created from SQL scripts.

  • Can you please provide me the SQL to create the tables/indexes used by JBoss Enterprise BRMS database? The only work around I can think of is to install JBoss Enterprise BRMS which is already configured with SQL Server, and then export the DDL for the database.
  • Is there further documentation on the database including an E-R design and whether querying the database from outside of JBoss Enterprise BRMS is supported? i.e. Is the design subject to change without notification?

Resolution

BRMS 5

  • Unfortunately, there is no SQL script provided by us as the database is created through Apache Jackrabbit which is a JCR (Content Respository API for Java) implementation. We don't recommend the idea of accessing database directly.
    Regarding the work-around which you mentioned above (export the DDL for the database), in future when you upgrade JBoss Enterprise BRMS, you would need to possibly upgrade the schema and SQL scripts as well.
    Just for your information, there is a section in This content is not included.BRMS Administrator Guide which you can follow if you need to consider Data Management (i.e. take Data Backups, Importing and Exporting Data) while you are upgrading your JBoss Enterprise BRMS installation.

  • Jackrabbit/ JCR encapsulates database access, so what you want to know depends on Jackrabbit/ JCR. Here are some links [1][2][3] you might be interested in. There is no document which explicitly describes database schema. It is Jackrabbit's internal implementation. Querying the database from outside of JBoss Enterprise BRMS is not supported and it can't be done without JBoss Enterprise BRMS.
    The content repository design won't change as it's defined in JCR specification and JBoss Enterprise BRMS versions should support backwards compatibility of rules, packages etc. But we cannot guarantee that physical database schema won't change.

BRMS 6, BPM Suite 6

DDL scripts for database tables for both BRMS and BPM Suite are available for download via This content is not included.Customer Portal, respectively at following This content is not included.link for BRMS. These DDL scripts are packaged inside the downloaded archive for Supplementary Tools at the jboss-bpms-brms-6.0.3.GA-redhat-1-supplementary-tools.zip/jboss-bpms-brms-6.0.3.GA-redhat-1-supplementary-tools/ddl-scripts/ location (for an example) . Also, if the Source Distribution for BRMS/BPMS is downloaded from Customer Portal, users can find the DDL scripts inside it's /jbpm/jbpm-installer/db/ddl-scripts/ location.
Sample Entity-Relationship diagram, generated from MySQL scripts for jBPM database is attached.

RHPAM 7, RHDM 7

DDL scripts for database tables for both RHDM and RHPAM are available for download via This content is not included.Customer Portal, respectively at following This content is not included.link for RHDM/RHPAM. These DDL scripts are packaged inside the downloaded archive for add-ons at the rhpam-7.0.1-add-ons.zip//rhpam-7.0-migration-tool/ddl-scripts/ location (for an example) .

Sample Entity-Relationship diagram, generated from MySQL scripts for jBPM database is attached.

=====
[1] Content from jackrabbit.apache.org is not included.Content from jackrabbit.apache.org is not included.http://jackrabbit.apache.org/jackrabbit-architecture.html
[2] Content from jackrabbit.apache.org is not included.Content from jackrabbit.apache.org is not included.http://jackrabbit.apache.org/object-content-mapping.html
[3] Content from jcp.org is not included.Content from jcp.org is not included.http://jcp.org/aboutJava/communityprocess/final/jsr170/index.html

SBR
Product(s)
Components
Category
Tags

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.