Flowable_database

1

Hi everyone i have custom schema where i want to set my DB tables for flowable
So i have database which has multiple schemas

In that i have assigned one schema for flowable
spring.datasource.url=jdbc:postgresql://10.45.100.103:61025/xyz?currentSchema=xyz
spring.datasource.username=xyz
spring.datasource.password=xyz
spring.jpa.properties.hibernate.default_schema=tx
spring.jpa.hibernate.ddl-auto=update

Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: relation “flw_channel_definition” does not exist

i got this error

please help for the initable set up for this

2

Hey @kartik,

You’ll need to set the flowable.database-schema property as well for this to work.
Try something like

flowable.database-schema=xyz

Cheers,
Filip

3

ya i tried that its still now working for me
so i have this in the application properties

spring.datasource.url=jdbc:postgresql://11.05.180.109:60987/xyz?currentSchema=xyz
spring.datasource.username=xyz
spring.datasource.password=xyz
spring.datasource.driver-class-name=org.postgresql.Driver
#spring.jpa.hibernate.ddl-auto=update
#spring.jpa.show-sql=true
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
spring.jpa.properties.hibernate.hbm2ddl.auto=update
spring.jpa.properties.hibernate.default_schema=xyz

flowable.update-schema=xyz
flowable.database.schema-update=true and gives me this error

Screenshot 2024-09-10 225331
Screenshot 2024-09-10 2253311675×534 126 KB

and when i do this with localhost it works perfectly fine with updating postgre Db and also making the tables on the first run

While i use this schema its not working

@Bean
public ProcessEngine processEngine(DataSource dataSource) {
    return ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration()
            .setDataSource(dataSource)
            .setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE)
            .buildProcessEngine();
}

I am using this as the flowableconfig file

4

Where did you come up with this properties? They are not correct.

What you need is:

flowable.database-schema=xyz
flowable.database-schema-update=true
1 Like