Flowable upgrade to 7.0.0 H2 is not able to create table

Flowable Engine
1

After the upgrade of Flowable to 7.0.0 the H2 database for testing purposes is not able to create a table. When running the app with MySQL connection, it works as expected, but I am not able to run the tests with H2 database.

org.h2.jdbc.JdbcSQLNonTransientException: Unknown data type: "IDENTITY"; SQL statement:
create table ACT_HI_TSK_LOG ( 
ID_ identity, 
TYPE_ varchar(64), 
TASK_ID_ varchar(64) not null, 
TIME_STAMP_ timestamp not null, 
USER_ID_ varchar(255), 
DATA_ varchar(4000), 
EXECUTION_ID_ varchar(64), 
PROC_INST_ID_ varchar(64), 
PROC_DEF_ID_ varchar(64), 
SCOPE_ID_ varchar(255), 
SCOPE_DEFINITION_ID_ varchar(255), 
SUB_SCOPE_ID_ varchar(255), 
SCOPE_TYPE_ varchar(255), 
TENANT_ID_ varchar(255) default '', 
primary key (ID_)

This is my H2 configuration for test profile

  datasource:
    hikari:
      driverClassName: org.h2.Driver
      jdbcUrl: jdbc:h2:mem:flowable;DB_CLOSE_ON_EXIT=FALSE;DB_CLOSE_DELAY=-1;MODE=MYSQL;IGNORECASE=TRUE;
      username: sa
      password:
  jpa:
    open-in-view: false
    show-sql: true
    format-sql: true
    hibernate:
      ddl-auto: update
      show_sql: true
    properties:
      hibernate.id.new_generator_mappings: true
      hibernate.connection.provider_disables_autocommit: true
      hibernate.cache.use_second_level_cache: false
      hibernate.cache.use_query_cache: false
      hibernate.generate_statistics: false
      hibernate.hbm2ddl.auto: none #TODO: temp relief for integration tests, revisit required
      hibernate.type.preferred_instant_jdbc_type: TIMESTAMP
      hibernate.jdbc.time_zone: UTC
      hibernate.timezone.default_storage: NORMALIZE
      hibernate.query.fail_on_pagination_over_collection_fetch: true
  h2:
    console:
      path: /h2-console
      enabled: true
2

The same table in mysql is being saved with ID_ of bigint. What am I doing wrong with H2 configuration?

image
image760×520 96.4 KB

3

I figured out the issue. flowable-engine doesn’t support H2, it is shipped with spring boot, by upgrading spring boot to version 3.1.5 I had to update the h2 connection to use legacy.

 datasource:
    hikari:
      jdbcDriver: org.h2.Driver
      jdbcUrl: jdbc:h2:mem:test;MODE=LEGACY;
      username: sa
      password:
4

Thank you! H2 2 gave me notorious error about expected “identifier”; After fixing it, It works for me.