topic Re: Activiti database tables are re-created... in Alfresco Archive

Activiti database tables are re-created...

niyazi_capar — Wed, 04 Sep 2013 08:12:25 GMT

Hello,Probably I've configured something wrong as I am new to Activiti, but as soon as I deploy or start a business process within Eclipse, the Activiti tables are re-created. Can anybody help me on this issue?Note: I'm using org.activiti.spring.SpringProcessEngineConfiguration as a class, and MS S

Re: Activiti database tables are re-created...

frederikherema1 — Wed, 04 Sep 2013 09:53:15 GMT

How do you boot your process-engine? What does the engine-configuration look like?

Re: Activiti database tables are re-created...

jbarrez — Wed, 04 Sep 2013 09:57:02 GMT

Your config file is probably on create-drop setting?

Re: Activiti database tables are re-created...

niyazi_capar — Wed, 04 Sep 2013 12:00:25 GMT

The activiti.cfg.xml is what follows:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

<bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
<property name="dataSource" ref="dataSource" />
<property name="transactionManager" ref="transactionManager" />
<property name="databaseSchemaUpdate" value="false" />
<property name="jobExecutorActivate" value="true" />
</bean>
<bean class="org.activiti.spring.ProcessEngineFactoryBean" id="processEngine">
<property name="processEngineConfiguration" ref="processEngineConfiguration" />
</bean>
<bean id="repositoryService" factory-bean="processEngine"
factory-method="getRepositoryService" />
<bean id="runtimeService" factory-bean="processEngine"
factory-method="getRuntimeService" />
<bean id="taskService" factory-bean="processEngine"
factory-method="getTaskService" />
<bean id="historyService" factory-bean="processEngine"
factory-method="getHistoryService" />
<bean id="managementService" factory-bean="processEngine"
factory-method="getManagementService" />
<bean id="identityService" factory-bean="processEngine"
factory-method="getIdentityService" />
</beans>

… and simple test class is:

@ContextConfiguration("classpath:activiti.cfg.xml")
public class HelloWorldTest extends SpringActivitiTestCase {

@Autowired
RuntimeService runtimeService;

@Autowired
RepositoryService repositoryService;

@Test
public void testHelloWorld() {
System.out.println("Initializing…");
repositoryService.createDeployment()
.addClasspathResource("hello-world.bpmn20.xml").deploy();

// Run
runtimeService.startProcessInstanceByKey("helloWorld");
}

}

Re: Activiti database tables are re-created...

niyazi_capar — Wed, 04 Sep 2013 12:01:19 GMT

Config:
————————–
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

<bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
<property name="dataSource" ref="dataSource" />
<property name="transactionManager" ref="transactionManager" />
<property name="databaseSchemaUpdate" value="false" />
<property name="jobExecutorActivate" value="true" />
</bean>
<bean class="org.activiti.spring.ProcessEngineFactoryBean" id="processEngine">
<property name="processEngineConfiguration" ref="processEngineConfiguration" />
</bean>
<bean id="repositoryService" factory-bean="processEngine"
factory-method="getRepositoryService" />
<bean id="runtimeService" factory-bean="processEngine"
factory-method="getRuntimeService" />
<bean id="taskService" factory-bean="processEngine"
factory-method="getTaskService" />
<bean id="historyService" factory-bean="processEngine"
factory-method="getHistoryService" />
<bean id="managementService" factory-bean="processEngine"
factory-method="getManagementService" />
<bean id="identityService" factory-bean="processEngine"
factory-method="getIdentityService" />
</beans>

Re: Activiti database tables are re-created...

niyazi_capar — Wed, 04 Sep 2013 12:06:55 GMT

Sorry for the inconvenience. I uploaded the config file as pasting to the body seems problematic.

Thank you.

Re: Activiti database tables are re-created...

jbarrez — Tue, 10 Sep 2013 15:36:49 GMT

That all looks fine, your setting is correct:

<code>
<property name="databaseSchemaUpdate" value="false" />
</code>

So it should work as advertised. You are simply running a unit test here?

Are you sure the config is being picked up (ie the data is in the tables)?