Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-10010

Mechanism for housekeeping means RecordsPerTransaction is limited to 1000 on Oracle, unnecessarily

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • 7.65.0.Final
    • Runtime Engine
    • None
    • False
    • False
    • NEW
    • NEW

      The mechanism used in org.jbpm.process.audit.JPAAuditLogService#doPartialDelete to batch the delete statements runs into `ORA-01795: maximum number of expressions in a list is 1000` when RecordsPerTransaction is > ~1000.

      This can be improved using a subquery with the delete, instead of passing the list of IDs as a parameter

              kverlaen@redhat.com Kris Verlaenen
              luke.armitage@sky.uk Lake Armitage (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: