# How to use flowable with h2 database Oracle mode

**URL:** <https://forum.flowable.org/t/how-to-use-flowable-with-h2-database-oracle-mode/12395>\
**Category:** Flowable Engine\
**Created:** [August 18, 2025, 4:24pm UTC](https://forum.flowable.org/t/how-to-use-flowable-with-h2-database-oracle-mode/12395 "2025-08-18T16:24:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![wjfqvi](https://avatars.discourse-cdn.com/v4/letter/w/6bbea6/32.png) [@wjfqvi](https://forum.flowable.org/u/wjfqvi)\
**Post date:** [August 18, 2025, 4:24pm UTC](https://forum.flowable.org/t/how-to-use-flowable-with-h2-database-oracle-mode/12395/1 "2025-08-18T16:24:11Z")

</div>

I have a Spring Boot 3 project. I want to use flowable with h2 database Oracle mode.

But if I use h2 database, flowable will use h2 SQL. I have set database to Oracle mode and set flowable database type to Oracle, but not work.

build.gradle.kts

```auto
plugins {
    java
    id("org.springframework.boot") version "3.5.4"
    id("io.spring.dependency-management") version "1.1.7"
}
java {
    toolchain {
        languageVersion = JavaLanguageVersion.of(17)
    }
}

repositories {
    mavenCentral()
}

dependencies {
    implementation("org.springframework.boot:spring-boot-starter-web")
    implementation("org.flowable:flowable-spring-boot-starter:7.1.0")
    implementation("com.h2database:h2")
}

```

application.yml

```yml
spring:
  datasource:
    url: jdbc:h2:mem:testdb;MODE=Oracle;DEFAULT_NULL_ORDERING=HIGH
    driver-class-name: org.h2.Driver
    username: sa
    password:
  h2:
    console:
      enabled: true
      path: /h2-console
flowable:
  database-type: oracle

```

Error:

```auto
Caused by: 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_) 
) [50004-232]

```

I have set `flowable.database-type=oracle` , but flowable still use h2 SQL

Does anyone know how to use flowable with h2 database oracle mode?

Thanks.

---

<div class="post-metadata">

**Author:** ![filiphr](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/filiphr/32/315_2.png) [@filiphr](https://forum.flowable.org/u/filiphr)\
**Post date:** [August 19, 2025, 11:33am UTC](https://forum.flowable.org/t/how-to-use-flowable-with-h2-database-oracle-mode/12395/2 "2025-08-19T11:33:49Z")

</div>

Hey @wjfqvi,

I see that you cross posted this both on GitHub and here. I have replied to your issue on [GitHub](https://github.com/flowable/flowable-engine/issues/4097#issuecomment-3199702544).

tl;dr there we no `flowable.database-type` property in Flowable that you can use to configure the database type.

Additionally, I’d add that it is a bit strange that you want to use H2 in Oracle mode, I would advise to just use an Oracle DB.

Cheers,  
Filip