topic How to set database table prefix when using Spring Boot? in Alfresco Archive

How to set database table prefix when using Spring Boot?

jubedus — Thu, 03 Mar 2016 18:34:18 GMT

Hello Experts, I am trying to switch my Activiti 5.19.0 + Spring Boot application to Oracle database. All Activiti tables have been already created by DBA in a dedicated schema. According to documentation, I need to specify database table prefix in order for Activiti queries to run successfully. Ot

Re: How to set database table prefix when using Spring Boot?

jbarrez — Mon, 07 Mar 2016 09:52:43 GMT

So just to make sure: you were able to make it work by changing the process engine config programmatically?
In that case, it might simply be that the properties are not read and passed into the engine.

Re: How to set database table prefix when using Spring Boot?

jubedus — Mon, 07 Mar 2016 22:40:43 GMT

Hi Joram,

Thanks for your reply!

No, I'm still trying to figure out how to change the process engine config programmatically. I was able the change the values of the process engine config as I was debugging through the application in Eclipse. Do you have an example of how to change process engine config in a Spring Boot application on start-up? Thanks a lot in advance!

Since table prefix is not listed in ActivitiProperties, does it mean it can't be set through configuration?

Re: How to set database table prefix when using Spring Boot?

jbarrez — Fri, 11 Mar 2016 09:07:08 GMT

There is a configurer class you can use: https://github.com/Activiti/Activiti/blob/master/modules/activiti-spring-boot/spring-boot-starters/activiti-spring-boot-starter-basic/src/main/java/org/activiti/spring/boot/ProcessEngineConfigurationConfigurer.java

Indeed, since it's not in ActivitiProperties, it's not read and passed.

Re: How to set database table prefix when using Spring Boot?

shere_khan_ — Thu, 22 Dec 2016 18:18:51 GMT

Have you made any progress on this? I'm having a similar issue. I created the activiti tables via sql scripts, and to stop activiti from complaining that the tables exist when I start spring boot, I added the following code:

@Bean
StandaloneProcessEngineConfiguration standaloneProcessEngineConfiguration() {
StandaloneProcessEngineConfiguration standaloneProcessEngineConfiguration =
new StandaloneProcessEngineConfiguration();
standaloneProcessEngineConfiguration.setDatabaseSchemaUpdate("true");
return standaloneProcessEngineConfiguration;
}

But now I get the below stack trace:

Caused by: org.springframework.beans.factory.NoUniqueBeanDefinitionException: No qualifying bean of type [org.activiti.engine.ProcessEngineConfiguration] is defined: expected single matching bean but found 2: standaloneProcessEngineConfiguration,springProcessEngineConfiguration
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1126)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1014)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:545)
... 25 more

Basically, the bean is already defined by default and I need to figure out a clean workaround for this. Are you getting that same exception by any chance?