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

Details

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

    • MySQL 5.7
      MariaDB 10.1

    Description

      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.

      Attachments

        Issue Links

          relates to

          Task - Represents a small unit of work that is not end-user facing. RHBPMS-5097 Certify MariaDB 10.2

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              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

              Dates

                Created:
                Updated:
                Resolved: