AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  MS SQLServer hangs on single threaded application with isola          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message Oliver Zeigermann Guest Posted: Thu Nov 13, 2003 5:53 pm    Post subject: MS SQLServer hangs on single threaded application with isola 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 Back to top Joe Weinstein Guest Posted: Thu Nov 13, 2003 7:05 pm    Post subject: Re: MS SQLServer hangs on single threaded application with i Oliver Zeigermann wrote: Quote: 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 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 Quote: Oliver Back to top Oliver Zeigermann Guest Posted: Fri Nov 14, 2003 10:36 am    Post subject: Re: MS SQLServer hangs on single threaded application with i Joe Weinstein wrote: Quote: Oliver Zeigermann wrote: 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 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... Quote: 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. Quote: If you are using the MS-provided JDBC driver, add this property for the connection: selectMethod=cursor Already done... Quote: What does the DBMS say about sessions, and who is holding what locks? Joe Will inversitage this further. Thanks for helping, Oliver Back to top Oliver Zeigermann Guest Posted: Wed Nov 19, 2003 11:25 am    Post subject: Re: MS SQLServer hangs on single threaded application with i Joe! Thanks a lot for your help! There was a second connection I could identify when examining locks and processes. Oliver Oliver Zeigermann wrote: Quote: Joe Weinstein wrote: Oliver Zeigermann wrote: 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 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 Back to top Joe Weinstein Guest Posted: Wed Nov 19, 2003 5:10 pm    Post subject: Re: MS SQLServer hangs on single threaded application with i Oliver Zeigermann wrote: Quote: 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 Quote: Oliver Zeigermann wrote: Joe Weinstein wrote: Oliver Zeigermann wrote: 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 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 Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.