Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread appy74
Hello I don't think this is a Tomcat issue but I thought I would post here just in case. I have a Java, JSP and MySQL application running under Apache Tomcat 6.0.26 which I've been testing with JMeter. What I find is that for a simple test having 10 users logging in and displaying a JSP

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
On 21 Nov 2011, at 09:28, app...@dsl.pipex.com app...@dsl.pipex.com wrote: Hello I don't think this is a Tomcat issue but I thought I would post here just in case. I have a Java, JSP and MySQL application running under Apache Tomcat 6.0.26 which I've been testing with JMeter. What I

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Martin O'Shea
Usually the connection is initialised as null and then assigned inside the try block. What happens if the method above throws an error after a connection is removed from the pool? To try to answer this, the sample code provided is illustrative of my DAO classes generally. The following is

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Terence M. Bandoian
On 1:59 PM, Martin O'Shea wrote: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: Too many connections I'd check into this. -Terence Bandoian

RE: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Martin O'Shea
[mailto:tere...@tmbsw.com] Sent: 21 Nov 2011 16 11 To: Tomcat Users List Subject: Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp On 1:59 PM, Martin O'Shea wrote: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
On 21 Nov 2011, at 16:11, Terence M. Bandoian tere...@tmbsw.com wrote: On 1:59 PM, Martin O'Shea wrote: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: Too many connections I'd check

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
have? -Original Message- From: Terence M. Bandoian [mailto:tere...@tmbsw.com] Sent: 21 Nov 2011 16 11 To: Tomcat Users List Subject: Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp On 1:59 PM, Martin O'Shea wrote: Caused

FW: Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Martin O'Shea
Are you able to provide any more information about what I am actually looking for in VisualVM?

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Martin O'Shea
Well, I hope I'm reading VisualVM correctly, because when I run the JMeter test first time around, I see 40 'connector' threads created in VisualVM, all of which run for so long and then return to a wait state. And if I run the test again several times in succession, the number of connector

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
On 21 Nov 2011, at 20:09, Martin O'Shea app...@dsl.pipex.com wrote: Are you able to provide any more information about what I am actually looking for in VisualVM? Depends how you defined the Db. Did you define a global Resource in server.xml? Or perhaps in conf/context.xml? p

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
On 21 Nov 2011, at 21:25, Martin O'Shea app...@dsl.pipex.com wrote: Well, I hope I’m reading VisualVM correctly, because when I run the JMeter test first time around, I see 40 ‘connector’ threads created in VisualVM, all of which run for so long and then return to a wait state. I always forget

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Terence M. Bandoian
should have? -Original Message- From: Terence M. Bandoian [mailto:tere...@tmbsw.com] Sent: 21 Nov 2011 16 11 To: Tomcat Users List Subject: Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp On 1:59 PM, Martin O'Shea wrote: Caused