How to use flowable with h2 database Oracle mode

Flowable Engine
1

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

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

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:

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.

2

Hey @wjfqvi,

I see that you cross posted this both on GitHub and here. I have replied to your issue on GitHub.

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