# Flowable upgrade to 7.0.0 H2 is not able to create table

**URL:** <https://forum.flowable.org/t/flowable-upgrade-to-7-0-0-h2-is-not-able-to-create-table/11054>\
**Category:** Flowable Engine\
**Created:** [November 20, 2023, 6:23pm UTC](https://forum.flowable.org/t/flowable-upgrade-to-7-0-0-h2-is-not-able-to-create-table/11054 "2023-11-20T18:23:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vcarri202\_comcast](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/vcarri202_comcast/32/3310_2.png) [@vcarri202\_comcast](https://forum.flowable.org/u/vcarri202_comcast)\
**Post date:** [November 20, 2023, 6:23pm UTC](https://forum.flowable.org/t/flowable-upgrade-to-7-0-0-h2-is-not-able-to-create-table/11054/1 "2023-11-20T18:23:18Z")

</div>

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.

```auto
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

```auto
  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

```

---

<div class="post-metadata">

**Author:** ![vcarri202\_comcast](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/vcarri202_comcast/32/3310_2.png) [@vcarri202\_comcast](https://forum.flowable.org/u/vcarri202_comcast)\
**Post date:** [November 21, 2023, 3:22pm UTC](https://forum.flowable.org/t/flowable-upgrade-to-7-0-0-h2-is-not-able-to-create-table/11054/2 "2023-11-21T15:22:32Z")

</div>

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

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/flowable/original/2X/a/aaa9d10fdcd1c2e3fa7f6966ee8c19e5f0a33975.png)

---

<div class="post-metadata">

**Author:** ![vcarri202\_comcast](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/vcarri202_comcast/32/3310_2.png) [@vcarri202\_comcast](https://forum.flowable.org/u/vcarri202_comcast)\
**Post date:** [November 22, 2023, 5:15pm UTC](https://forum.flowable.org/t/flowable-upgrade-to-7-0-0-h2-is-not-able-to-create-table/11054/3 "2023-11-22T17:15:39Z")

</div>

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.

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

```

---

<div class="post-metadata">

**Author:** ![xliu](https://avatars.discourse-cdn.com/v4/letter/x/ecccb3/32.png) [@xliu](https://forum.flowable.org/u/xliu)\
**Post date:** [January 17, 2024, 4:12pm UTC](https://forum.flowable.org/t/flowable-upgrade-to-7-0-0-h2-is-not-able-to-create-table/11054/4 "2024-01-17T16:12:17Z")

</div>

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