On Fri, Mar 28, 2014 at 12:31 PM, Propes, Barry L
wrote:
>
>
> -Original Message-
> From: Mark Shifman [mailto:mark.shif...@yale.edu]
> Sent: Friday, March 28, 2014 12:34 PM
> To: Tomcat Users List
> Subject: Re: Connection pooling issue on Tomcat
>
> ===
-Original Message-
From: Mark Shifman [mailto:mark.shif...@yale.edu]
Sent: Friday, March 28, 2014 12:34 PM
To: Tomcat Users List
Subject: Re: Connection pooling issue on Tomcat
On 03/28/2014 11:58 AM, Propes, Barry L wrote:
> Hi folks,
>
> I'm using Tomcat 6.0.29 for a
-Original Message-
From: Christopher Schultz [mailto:ch...@christopherschultz.net]
Sent: Friday, March 28, 2014 11:13 AM
To: Tomcat Users List
Subject: Re: Connection pooling issue on Tomcat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Barry,
On 3/28/14, 11:58 AM, Propes, Barry L
On 03/28/2014 11:58 AM, Propes, Barry L wrote:
Hi folks,
I'm using Tomcat 6.0.29 for an app I've had in place for years. I run the Java
app I have on a Windows 2003 server for my production region, but have local
builds on both my desktop and laptop, both of which are Windows XP Pro. Yes, I
Hi folks,
I'm using Tomcat 6.0.29 for an app I've had in place for years. I run the Java
app I have on a Windows 2003 server for my production region, but have local
builds on both my desktop and laptop, both of which are Windows XP Pro. Yes, I
do realize that the Tomcat version is old, but we'
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Barry,
On 3/28/14, 11:58 AM, Propes, Barry L wrote:
> Hi folks,
>
> I'm using Tomcat 6.0.29 for an app I've had in place for years. I
> run the Java app I have on a Windows 2003 server for my production
> region, but have local builds on both my de
ive 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 by:
com.mysql.j
On 21 Nov 2011, at 21:25, Martin O'Shea 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 to tell people to get
On 21 Nov 2011, at 20:09, Martin O'Shea 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
>
-
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 th
Are you able to provide any more information about what I am actually
looking for in VisualVM?
Tomcat
> maxActive 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 weba
On 21 Nov 2011, at 16:11, "Terence M. Bandoian" 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 int
. 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 by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionExce
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
---
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
On 21 Nov 2011, at 09:28, "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 find is that f
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 which
ttp://enigmail.mozdev.org/
>
> iEYEARECAAYFAkrFIHkACgkQ9CaO5/Lv0PDUcwCfW1Wz6ieZ0pEnm/p+dm9vsiVo
> IFIAoIlQSxys4cHzVi+YAro3BDrV0dju
> =Ojns
> -END PGP SIGNATURE-
>
> -
> To unsubscribe, e-mail: users-unsubscr...@tomcat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martin,
On 10/1/2009 12:53 PM, MartinOShea wrote:
> private static DataSource dataSource = null;
I wouldn't recommend caching the DataSource object. This limits your
ability to reconfigure the DataSource on the fly if you want to. Local
JNDI look
---
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
>
--
View this message in context:
http://www.nabble.com/Tomcat-6.X-and-MySQL-connection-pooling-issue-tp25677820p25702523.html
S
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martin,
On 10/1/2009 3:47 AM, MartinOShea wrote:
> Changing testOnBorrow = "true" has not changed the situation with the
> connection pool failing -can anyone suggest anything?
Are you sure you are configuring the right connection pool?
Can you tu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark et al,
On 9/30/2009 8:33 AM, Mark Thomas wrote:
> It just means that testOnBorrow does nothing if validationQuery is set to "".
> For mysql "select 1" is sufficient and saves a call to now(). The Oracle
> equivalent would be "select 1 from dual"
> return null;
> }
> }
> catch(Exception ex)
> {
> logger.error("Error getting Dataset " + DatasetNo + "\n", ex);
>
> return null;
> }
> finally
> {
> DatabaseUtils.clos
;
>>>>> Mark
>>>>>
>>>>>
>>>>> -
>>>>> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
>>>>> For additional commands, e-mail: users-h...@tomc
On 30/09/2009 13:38, MartinOShea wrote:
So select now() is fine.
(Where "fine" is defined as "not what you were advised to use, for sound
reasons that are require a longer explanation than was necessary at the
time".)
p
Thanks.
markt-2 wrote:
MartinOShea wrote:
Thanks for the reply
e.org
>>> For additional commands, e-mail: users-h...@tomcat.apache.org
>>>
>>>
>>>
>>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
>
--
View this message in context:
http://www.nabble.com/Tomcat-6.X-and-MySQL-connection-pooling-issue-tp25677820p25680199.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
MartinOShea wrote:
> Thanks for the reply.
>
> Setting testOnBorrow to true is something I'll try but according to:
>
> http://commons.apache.org/dbcp/configuration.html
>
> If testOnBorrow is set to true, the validation query must be set to a
> 'non-null string'. Presumably this means that the
---
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
>
--
View this message in context:
http://www.nabble
MartinOShea wrote:
> But I think what is
> happening after eight hours of inactivity, is that the system is trying to
> reuse a connection pool object that MySQL has closed down after its default
> eight hour period.
Sounds likely.
> testOnBorrow = "false"
Try setting this to true.
Mark
-
taset " + DatasetNo + "\n", ex);
return null;
}
finally
{
DatabaseUtils.closeResultSet(rs);
DatabaseUtils.closePreparedStatement(ps);
pool.freeConnection(connection);
}
Where class ConnectionPool_DBA is my own DBCP-based class.
A
y review, disclosure, dissemination, distribution or copying of it or its
contents
- Original Message -
From: "tyju tiui" <[EMAIL PROTECTED]>
To: "Tomcat Users List"
Sent: Saturday, November 18, 2006 10:32 PM
Subject: Re: Pooling Issue
I do have a firewall, but I
and that any review, disclosure, dissemination,
distribution or copying of it or its
contents
- Original Message -
From: "tyju tiui" <[EMAIL PROTECTED]>
To: "Tomcat Users List"
Sent: Saturday, November 18, 2006 10:32 PM
Subject: Re: Pooling Issue
I do have a firewal
(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
- Original Message
From: David Smith <[EMAIL PROTECTED]>
To: Tomcat Users List
Sent: Saturday, November 18, 2006 9:28:46 PM
Subjec
Well that's a stumper. The connection refused exception implies that
nothing is listening on that port or the port is blocked by a firewall.
Is there any more to that exception like a root cause? Given you are
using the localhost interface, I doubt this has a bearing but would you
happen to
Hi David,
Thank you so much for the response and good advice.
I verified that I was able to connect to MySQL using
the command you suggested (via port 3306). I also
removed the autoReconnect parameter and moved the
pooling config out to Catalina/localhost/DBTest.xml. I
restarted tomcat and I'm sti
For starters, you might want to make a copy of your server.xml file for
documentation purposes and then drop all the comments from the active
one. The documentation comments are excellent, but they make the
serverl.xml near impossible to read.
At any rate the exception is connection refus
I'm having problems setting up connection pooling with
comcat 5.5.2.0 and MySQL 5.0.24 using mysql
connector/J 5.0.
I've setup / populated a test database and verified
that I can login to the server/db using the specified
username/password/host found in the connection string.
My server.xml looks l
38 matches
Mail list logo
