Open Edition

Open Editions

Come for answers. Stay for best practices. All we’re missing is you.


#Data
#Businessautomation
#Data
 View Only

BAMOE-Deadlocks Issue - Spring Boot + Microsoft SQL Server Database + BAMOE 9.3.x

  • 1.  BAMOE-Deadlocks Issue - Spring Boot + Microsoft SQL Server Database + BAMOE 9.3.x

    Posted Sun March 29, 2026 03:27 PM

    We are facing deadlock issues on table jbpm_user_tasks with update query (update jbpm_user_tasks set values where id=?), when there is concurrent requests comes to create processInstance 

    We enabled Read Commited Snapshot to On at db level and at set isolation level at Datasource Application Level

    SpringBootDataSource Configuration with Local entityManagerafactoryBean and Transaction Manager with @Primary annotation as we have multiple datasources in Application



    ------------------------------
    Mohan Sumanth
    ------------------------------