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
kely.
>>>
>>>> testOnBorrow = "false"
>>> Try setting this to true.
>>>
>>> Mark
>>>
>>>
>>> -
>>> To unsubscribe, e-mail: users-unsubscr...@tomcat.apach
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
13 matches
Mail list logo
