Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-6580

I want to query process instances by start time on DB2 with history level none on DB2

    XMLWordPrintable

Details

    Description

      Right now we are getting exceptions on DB2 if history level none is set and query of process instances with ordering by start time is performed.
      to reproduce run org.camunda.bpm.cockpit.plugin.base.ProcessInstanceRestServiceTest#testQueryOrderByStartTime with profile cfghistorynone,db2,db2-105

      Hint
      statement 

      <if test="!historyEnabled">
        null START_TIME_
</if>

      in org/camunda/bpm/cockpit/plugin/base/queries/processInstance.xml
      looks very strange.

      Possible solution
      http://stackoverflow.com/questions/2509233/db2-wont-allow-null-column
      customization of null column is done through org.camunda.bpm.engine.impl.db.sql.DbSqlSessionFactory

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Activity

            People

              michael.schoettes Michael Schoettes
              askar.akhmerov Askar
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce