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

SQL incompatible types when using PER_PROCESS_INSTANCE strategy

XMLWordPrintable

      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

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

                Created:
                Updated:
                Resolved: