Re: Problem with connection pool

2011-05-02 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chris, On 4/30/2011 6:58 AM, chris derham wrote: > Finally managed to track the problem down to nested transactions - > apparently spring doesn't support them. Once removed the problem went away Glad you got it figured out. What is a "nested transact

Re: Problem with connection pool

2011-04-30 Thread David Kerber
On 4/30/2011 6:58 AM, chris derham wrote: All, What do you mean by "swapped out"? Idle speculation in the face of a problem that I didn't really understand :-( 69% of all threads are sleeping on a monitor. Fully expected, since that's what they do when waiting for work to show up. This m

Re: Problem with connection pool

2011-04-30 Thread chris derham
All, > > What do you mean by "swapped out"? > Idle speculation in the face of a problem that I didn't really understand :-( > > > 69% of all threads are sleeping on a monitor. > > Fully expected, since that's what they do when waiting for work to show up. > > > This might indicate they are waiti

RE: Problem with connection pool

2011-04-29 Thread Caldarale, Charles R
> From: cjder...@gmail.com [mailto:cjder...@gmail.com] On Behalf Of chris derham > Subject: Problem with connection pool > So what I deduce is that a connection goes to server, > obtains the lock, and then somehow swapped out and so > never commits transaction, hence lock is

Re: Problem with connection pool

2011-04-29 Thread David kerber
On 4/29/2011 12:57 PM, chris derham wrote: All, I am having a weird problem with an app. We were having concurrency issues, so we setup some simple pessimistic locking - we lock a single table using select for update. We have developed a jmeter script that allows us to test the app when loaded.

Problem with connection pool

2011-04-29 Thread chris derham
All, I am having a weird problem with an app. We were having concurrency issues, so we setup some simple pessimistic locking - we lock a single table using select for update. We have developed a jmeter script that allows us to test the app when loaded. Repeatedly after different intervals, but les