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_GEPROPERTY 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_GEPROPERTY 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