 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / November 2003MS SQLServer hangs on single threaded application with isolation level serializable
Experts out there, I need your help! When setting high isolation levels in a single threaded application MS SQLServer deterministicly blocks when accessing certain tables. This might be a stupid question, but are those DB locks reentrant, i.e. can I acquire them twice from the same connection? Thanks for any hints in advance, Oliver > Experts out there, I need your help! > [quoted text clipped - 5 lines] > > Thanks for any hints in advance Hi. This sounds very unlikely. A single connection cannot be blocked accessing locks it already has. (yes, locks are re-entrant). Are you sure you're using only one real connection? If you are using the MS-provided JDBC driver, add this property for the connection: selectMethod=cursor What does the DBMS say about sessions, and who is holding what locks? Joe > Oliver >> Experts out there, I need your help! >> [quoted text clipped - 8 lines] > Hi. This sounds very unlikely. A single connection cannot be blocked > accessing locks it already has. (yes, locks are re-entrant). Thought so, but things seem to be so weird, I wanted to be sure... > Are you > sure you're using only one real connection? Having ruled out almost all other possibilities this becomes more and more likely. But wherer? Hmmmm. > If you are using the > MS-provided JDBC driver, add this property for the connection: > > selectMethod=cursor Already done... > What does the DBMS say about sessions, and who is holding what locks? > Joe Will inversitage this further. Thanks for helping, Oliver Joe! Thanks a lot for your help! There was a second connection I could identify when examining locks and processes. Oliver >>> Experts out there, I need your help! >>> [quoted text clipped - 34 lines] > > Oliver > Joe! Thanks a lot for your help! There was a second connection I could > identify when examining locks and processes. > > Oliver Glad to help. We want you successful. Joe Weinstein at BEA >>>> Experts out there, I need your help! >>>> [quoted text clipped - 34 lines] >> >> Oliver Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.