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

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

      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

              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

                Created:
                Updated:
                Resolved: