Multi-tenant Multi-schema in Spring Boot

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

jlalwani

I understand how the Activiti Process Engine is configured in Spring Boot. The SpringProcessEngineConfiguration extends ProcessEngineConfigurationImpl to provide the barebones configuration for Spring. Then you have various classes that extend AbstractProcessEngineAutoConfiguration that modify the SpringProcessEngineConfiguration to inject various beans into the configuration.

I read the documentation about how MultiTenant MultiSchemaMultiTenantProcessEngineConfiguration can be used to setup Activiti to use Multiple schema.

However, I don't understand how to do multi-schema in Spring Boot

Should I implement a MultiSchemaMultiTenantProcessEngineAutoConfiguration that extends AbstractProcessEngineAutoConfiguration and modifies the SpringProcessEngineConfiguration?  Perhaps it can be conditional on a bean of type TenantInfoHolder. Is there a similar AutoConfiguration in Activiti already that I can use?

jlalwani

Will this work?

<br>@Configuration<br>@AutoConfigureAfter(DataSourceAutoConfiguration.class)<br>@ConditionalOnBean(TenantInfoHolder.class)<br>public class MultiTenantMultiSchemaConfiguration {<br> <br> @Bean<br> public DataSource dataSource(TenantInfoHolder tenantInfoHolder) {<br>&nbsp; return new TenantAwareDataSource(tenantInfoHolder);<br> }<br> <br> @Bean<br> public ProcessEngineConfigurationConfigurer multiTenantProcessingEngineConfigurer() {<br>&nbsp; return new ProcessEngineConfigurationConfigurer() {<br>&nbsp;&nbsp; <br>&nbsp;&nbsp; @Override<br>&nbsp;&nbsp; public void configure(SpringProcessEngineConfiguration config) {<br><br>&nbsp;&nbsp;&nbsp; config.setIdGenerator(new StrongUuidGenerator());<br>&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp; }<br>&nbsp; };<br> }<br>}<br>