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

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

                Dates

                Created:
                Updated:
                Resolved:

                  Salesforce