Webmaster Forum  

Go Back   Webmaster Forum > Marketing, SEO and Development > Programming
User Name
Password
Register FAQ Members List Calendar Transactions Store Search Today's Posts Mark Forums Read


MS-SQL deadlock and hang the Java application

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 03-18-2007, 11:24
reachpradeep
Junior Member


Join Date: Mar 2007
Posts: 14
Trader Rating: (0)
Points: 20 (Donate)
5 F$/Referral Refer Friends
reachpradeep is on a distinguished road
Default MS-SQL deadlock and hang the Java application

Hi.. We have a java application which connect to our MS-SQL DB during midnight using JDBC connector and extract information. But very often ,the java applicatian halted and because of the deadlock as shown below.

Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Transaction (Process ID 54) was deadlocked o n lock resources with another process and has been chosen as the deadlock victim.

now the java programmer is blaming me that the MS SQL DB is having deadlock and cause their Java application to hang.

Is there any way to clear the deadlock before the the Java applcation run or how to prove the Java application script itself is having problem and causing the deadlock ?
reachpradeep is offline
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


Resources : | Advertise at FHF | itextLink.com| Reseller Hosting| TextDot| iNamePros| Any Webmaster| Web Host| Dep3|


All times are GMT -4. The time now is 23:16.


Powered by: vBulletin
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.