Performance and scalability: Database dead lock in Sql Server
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.
- Posted by: nuthan kumar an
- Posted on: October 02 2006 17:19 EDT
interesting article on sqlserver : avoiding deadlocks - http://www.sql-server-performance.com/deadlocks.asp http://www.rampant-books.com/t_hpsdba_44_deadlocks_design_issues.htm http://msdn2.microsoft.com/en-us/library/ms190465.aspx If you are using entity beans in jboss: http://docs.jboss.org/jbossas/jboss4guide/r4/html/ch5.chapter.html#ch5.entitylock.sect Bhagvan K http://www.jroller.com/page/bhagvank
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, http://javaicillusion.blogspot.com/