Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-315

ORM based configuration for ID generation for MySQL/MariaDB

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 6.x.x
    • jBPM Core

    • MySQL 5.7
      MariaDB 10.1

      By default, jBPM generate ID using "AUTO_INCREMENT" in MySQL/MariaDB. But it has a problem that AUTO_INCREMENT value could be reset when MySQL/MariaDB is restarted. The issue is described in https://access.redhat.com/solutions/3222791 and https://issues.jboss.org/browse/JBPM-5226

      In the JBPM-5226, Maciej suggested ORM based configuration for ID generation.

      https://issues.jboss.org/browse/JBPM-5226?focusedCommentId=13296986&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13296986

      This JIRA is raised to make it an official configuration so that it can be tested by QA. (But not default)

      Note: From MariaDB 10.2.4 and MySQL 8.0 (GA not yet released), AUTO_INCREMENT is persistent.

        1. jBPM64Ex021_orm_mysql.zip
          107 kB

            swiderski.maciej Maciej Swiderski (Inactive)
            rhn-support-tkobayas Toshiya Kobayashi
            Marian Macik Marian Macik
            Marian Macik Marian Macik
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: