Database dead lock in Sql Server
843859Oct 2 2006 — edited Oct 3 2006I am getting database dead lock exception in my java application (SQL server)when ever the load/number of hits increases on the server.
1) I am using microsoft SQL Server 2003.
2) netforge drivers
3) Jboss application server
I am getting following exception
"Caused by: java.sql.SQLException: Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."
I read several articles on the dead lock and verfied my java code and database configuration such as indexes looks everything right.