Database dead lock in Sql Server


Performance and scalability: Database dead lock in Sql Server

  1. Database dead lock in Sql Server (2 messages)

    Hi , I 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.
  2. interesting article on sqlserver : avoiding deadlocks - If you are using entity beans in jboss: Bhagvan K
  3. At first, I thought of writing a long essay describing the deadlock situation but the resources that you refered are very much suffient.Thank you for saving my time.Keep It up. cheers,