Details on Schema based Multitendency

Flowable Engine
1

I went through the blog and simply adding the below snippet it works. I need to know do should I add the parent database in the register registerTenant method ? please advice on this.

config = new MultiSchemaMultiTenantProcessEngineConfiguration(tenantInfoHolder); config.setDatabaseType(MultiSchemaMultiTenantProcessEngineConfiguration.DATABASE_TYPE_H2); config.setDatabaseSchemaUpdate(MultiSchemaMultiTenantProcessEngineConfiguration.DB_SCHEMA_UPDATE_DROP_CREATE); config.registerTenant(“tenant1”, createDataSource(“jdbc:h2:mem:flowable-tenant1;DB_CLOSE_DELAY=1000”, “sa”, “”)); config.registerTenant(“tenant2”, createDataSource(“jdbc:h2:mem:flowable-tenant2;DB_CLOSE_DELAY=1000”, “sa”, “”)); config.registerTenant(“tenantN”, createDataSource(“jdbc:h2:mem:flowable-tenantN;DB_CLOSE_DELAY=1000”, “sa”, “”)); processEngine = config.buildProcessEngine();

Regards,
Raja

2

Have you tried to put the tenant ID in the setDatabaseSchema, like:

config.setDatabaseSchema(tenantId) ?

Is the way I use and works fine.