Stream: hapi
Topic: Sql server transaction deadlocked on concurrent transactions
Chandan Datta (Feb 17 2020 at 06:03):
When we try to process concurrent write transactions to a SQL Server 2019 engine using the HAPI RestfulServer class embedded in a spring boot app, we are getting a transaction deadlock error. Each transaction has bundle of 100 resources being saved as a resource type batch. It seems to happen in SQL server, but not in HSQL db in-memory. Is this deadlock issue due to the unique way that Spring JPA deals with SQL server's transaction? Has anyone else run into a similar issue or the same issue?
Last updated: Apr 12 2022 at 19:14 UTC