Re: Tomcat 6.X and MySQL connection pooling issue

2009-10-01 Thread MartinOShea
appreciated. Is there a MySQL setting which should be changed at all? Thanks Martin O'Shea. -- View this message in context: http://www.nabble.com/Tomcat-6.X-and-MySQL-connection-pooling-issue-tp25677820p25693459.html Sent from the Tomcat - User mailing list archive at Nabble.com

Re: Tomcat 6.X and MySQL connection pooling issue

2009-10-01 Thread Christopher Schultz
-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 FYI,

Re: Tomcat 6.X and MySQL connection pooling issue

2009-10-01 Thread Christopher Schultz
-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

Re: Tomcat 6.X and MySQL connection pooling issue

2009-10-01 Thread MartinOShea
://www.nabble.com/Tomcat-6.X-and-MySQL-connection-pooling-issue-tp25677820p25702523.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional

Re: Tomcat 6.X and MySQL connection pooling issue

2009-10-01 Thread Christopher Schultz
-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

Re: Tomcat 6.X and MySQL connection pooling issue

2009-10-01 Thread MartinOShea
- - 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-tp25677820p25707037.html Sent from the Tomcat - User

Tomcat 6.X and MySQL connection pooling issue

2009-09-30 Thread MartinOShea
but any help would be much appreciated. Is there a MySQL setting which should be changed at all? Thanks Martin O'Shea. -- View this message in context: http://www.nabble.com/Tomcat-6.X-and-MySQL-connection-pooling-issue-tp25677820p25677820.html Sent from the Tomcat - User mailing list archive

Re: Tomcat 6.X and MySQL connection pooling issue

2009-09-30 Thread Mark Thomas
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

Re: Tomcat 6.X and MySQL connection pooling issue

2009-09-30 Thread MartinOShea
...@tomcat.apache.org -- View this message in context: http://www.nabble.com/Tomcat-6.X-and-MySQL-connection-pooling-issue-tp25677820p25679823.html Sent from the Tomcat - User mailing list archive at Nabble.com

Re: Tomcat 6.X and MySQL connection pooling issue

2009-09-30 Thread Mark Thomas
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 query

Re: Tomcat 6.X and MySQL connection pooling issue

2009-09-30 Thread MartinOShea
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

Re: Tomcat 6.X and MySQL connection pooling issue

2009-09-30 Thread Pid
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.

Re: Tomcat 6.X and MySQL connection pooling issue

2009-09-30 Thread MartinOShea
/Tomcat-6.X-and-MySQL-connection-pooling-issue-tp25677820p25680340.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