Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

[lichengliang1]

version: flowable7.0.0+ojdbc8+druid(1.2.7)

config:

flowable:
async-executor-activate: true
database-schema-update: true
process-definition-location-prefix: classpath*:/static/modeler/
process-definition-location-suffixes: "**.bpmn20.xml, **.bpmn"

error:
2024-01-16 13:59:55.696 INFO [main] org.flowable.app.spring.SpringAppEngineConfiguration : Executing configure() of class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)
Opening JDBC Connection
==> Preparing: select * from ACT_GE_PROPERTY where NAME_ = ?
==> Parameters: schema.version(String)
2024-01-16 13:59:56.046 ERROR[main] org.flowable.common.engine.impl.interceptor.CommandContext : Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

The error may exist in org/flowable/common/db/mapping/entity/Property.xml

The error may involve org.flowable.common.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty-Inline

The error occurred while setting parameters

SQL: select * from ACT_GE_PROPERTY where NAME_ = ?

Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

How to solve this problem？

[tijsrademakers]

This means that the database schema was not created. Are you using Apache Druid as your database? This database is not supported by Flowable.

[lichengliang1]

The database schema has been created,
I am using druid is

com.alibaba
druid
1.2.7

But it seems to have nothing to do with Druid,I ruled it out, but the same error still occurred
This is my Oracle database connection information:jdbc:oracle:thin:@${oracle.host}:${oracle.port}:orcl?currentSchema=HC7

[tijsrademakers]

Ok you need to set the database schema value in your config as well with flowable: database-schema: HC7