File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes deadlock in MS SQL 2000 but not in Postgres Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "deadlock in MS SQL 2000 but not in Postgres" Watch "deadlock in MS SQL 2000 but not in Postgres" New topic

deadlock in MS SQL 2000 but not in Postgres

raj varma

Joined: Jan 05, 2003
Posts: 29
I am facing deadlock in MS SQL 2000 sp3, but same code does not face any deadlock in postgres 7.3 database. How do i resolve the problem ?
Even same case happpnes for time taken by postgreas to retrive @15000 records is @4-5 seconds and same no. of records is fetched by ms sql 2000 is @8-10 minutes.
Please Help me.
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

I don't know how Postgres compares with MSSQL Server, but I do know that MSSQL Server has a lower deadlock threshold than DB2 and Oracle i.e. it takes fewer concurrent operations in MSSQL Server to cause deadlock than in the other two. I'd check the Database documentation and see if this is the issue. I'd check your driver documentation too - it might be something to do with how/when it actually runs queries.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: deadlock in MS SQL 2000 but not in Postgres
Similar Threads
Application Hang when delete() method execute
Scrollable ResultSet
sql query returning duplicates
Best JDBC drivers?
SQL command to show tables