Dear Team,
We are using Camunda spring boot starter application. The source code is copied from the spring boot starter example in GITHUB:
By default it works well with h2 database. But after we connected to oracle database, whenever any write operation happens to database like adding a variable to process instance or completing a task, we are always getting the error like this
eg: “Cannot submit task form 9e5a15dd-eec6-11e9-9a84-b02fd8b32b8e: ENGINE-03005 Execution of ‘DELETE TaskEntity[9e5a15dd-eec6-11e9-9a84-b02fd8b32b8e]’ failed. Entity was updated by another transaction concurrently”.
eg: “Could not add the new variable: Cannot put process instance variable 1: ENGINE-03005 Execution of ‘UPDATE ExecutionEntity[9e577dca-eec6-11e9-9a84-b02fd8b32b8e]’ failed. Entity was updated by another transaction concurrently.”
Though im the only person accessing and doing this activity, concurrent transaction error is coming always.Error stacktrace.txt (26.0 KB)
- configured to connect to oracle db in the springboot application. java class
@Bean(name = “dataSource”)
public DataSource dataSource() throws NamingException {
DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName(“oracle.jdbc.OracleDriver”);
dataSource.setUrl(“url”);
dataSource.setUsername(“name”);
dataSource.setPassword(“passoword”);
return dataSource;
}
@Bean(name = “transactionManager”)
public PlatformTransactionManager transactionManager() throws NamingException {
return new DataSourceTransactionManager(dataSource());
}
- Added the following dependencies in POM
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
Above configuration is creating tables in oracle database and the sample.bpmn file is also deployed. But whenever we tried updating the process instance we get this error.
Our oracle version is 12c, We tried programatically setting the jdbcBatchProcessing to false, when we do this above error doesnot come and we get a successful operation message, but data doesnt persist to database.
@EventListener
public void processApplicationDeploymentEvent(PostDeployEvent event){
event.getProcessEngine().getProcessEngineConfiguration().setJdbcBatchProcessing(false);
}
Kindly request you to help us resolving this concurrent transaction issue.
Thanks in Advance
Ravitheja