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
-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,
-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
://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
-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
-
-
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
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
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
...@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
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
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
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.
/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
13 matches
Mail list logo