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

        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: