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

SQL incompatible types when using PER_PROCESS_INSTANCE strategy

    XMLWordPrintable

Details

    Description

      org.jbpm.runtime.manager.impl.jpa.ContextMappingInfo contains an HQL query named "FindKSessionToInit". Such query joins ContextMappingInfo with ProcessInstanceInfo on cmInfo.contextId = processInstanceInfo.processInstanceId. However, cmInfo.contextId is declared as a string while processInstanceInfo.processInstanceId is declared as a long so there is a mismatch in the types of the two columns created in the database.

      When the runtime engine is created with JPA support, the "FindKSessionToInit" is run and it produces the following error:

      org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = bigint

      Attachments

        Activity

          People

            swiderski.maciej Maciej Swiderski (Inactive)
            aledibe Alessandro Di Bella (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: