Error when creating link in activiti-cycle on postgres DB

Description

When running the demo-setup on postgres SQL and add a link (on eg. FinancialReportProcess.bpmn20.xml in eclipe-workspace), an error occurs:

09280000 Wrapped Exception (with status template): org.apache.ibatis.exceptions.PersistenceException:

  1.  

    1.  

      1. Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: column "id_" is of type integer but expression is of type character varying
        Hint: You will need to rewrite or cast the expression.

      2. The error may involve org.activiti.cycle.insertCycleLink-Inline

      3. The error occurred while setting parameters

      4. Cause: org.postgresql.util.PSQLException: ERROR: column "id_" is of type integer but expression is of type character varying
        Hint: You will need to rewrite or cast the expression.

Since Postgresql doesn't support the AUTO_INCREMENT construct, the field ID_ is of type 'SERIAL', which creates a sequence behind the scene and creates a numeric column.

The other JDBC-drivers don't seem to mind using a String field (in java) on a numeric jdbc-column.
However, AUTO_INCREMENT shouldn't be applied to VARCHAR columns (and almost no DB-systems support this), the different DB's now all have a numeric field for this (oracles uses sequence on number-field, mysql an bigint AUTO_INCREMENT) to make the create-statements work.

Environment

None

Assignee

Bernd Ruecker (camunda)

Reporter

Frederik Heremans

Labels

None

Fix versions

Priority

Major
Configure