Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-3099

Create index DDL should be added to oracle-jbpm-schema.sql

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Duplicate
    • Major
    • None
    • 6.0.3
    • Installer
    • None

    Description

      Description of problem:
      Create index DDL should be added to oracle-jbpm-schema.sql in order to prevent a dead lock in DB.

      Create index DDL is CREATE INDEX IDX_EVENTTYPES ON EVENTTYPES (INSTANCEID);. It is described in Bug 854612.

      And oracle-jbpm-schema.sql is in /brms-src/jbpm/jbpm-installer/db/ddl-scripts/oracle/oracle-jbpm-schema.sql in jboss-bpms-brms-6.0.3.GA-redhat-1-src.zip.

      Version-Release number of selected component (if applicable):
      jbpm 6.0.3

      Additional info: Bug 854612 - Missing index in EVENTTABLES table
      https://bugzilla.redhat.com/show_bug.cgi?id=854612

      Attachments

        Activity

          People

            thauser_jira Thomas Hauser (Inactive)
            rhn-support-ksuzumur Keishi Suzumura
            Tomáš Livora Tomáš Livora (Inactive)
            Tomáš Livora Tomáš Livora (Inactive)
            bpms-support, Jiri Svitak (Inactive), Kris Verlaenen
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: