tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jorge Medina <cerebrotecnolog...@gmail.com>
Subject Re: programming question
Date Sat, 26 Feb 2011 21:09:45 GMT
If you use Oracle, some DBCP settings may not work and you may need to
use Oracle connection pool classes.
In particular, I was not able to use DBCP and have a loginTimeout when
using Oracle.

Using Oracle connection pool classes, the validation query does not
work in the same way as in Apache DBCP. Apache DBCP tries to give you
a valid connection if the query fails. Oracle will just test and throw
an exception indicating the connection is stale (as opposed to just
giving you the stale connection). So even with an Oracle RAC, the pool
may return a stale connection or throw an exception. So, I use Oracle
Connection Caching settings to grow a pool from 0 to n and discard any
connection that has been idle more than T seconds. This was worked
well in production environment. (without having to switch to Oracle
UCP, which was our next option).


On Fri, Feb 25, 2011 at 3:17 PM, Christopher Schultz
<chris@christopherschultz.net> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> David,
>
> On 2/24/2011 12:08 PM, David Smith wrote:
>> With tomcat's built-in database pooling, just adding a validation query
>> to the resource config should be all that's necessary.  On each borrow
>> of a connection, the connection is tested and closed if the test fails.
>> Failed connections are replaced with new ones.
>
> +1
>
> - -chris
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAk1oDkQACgkQ9CaO5/Lv0PB4ywCffleVFm8jZtJRcD3x2V3gCs6T
> DBUAoKUD6zJXXPURMoQLtm8SGecxQfqk
> =MkzS
> -----END PGP SIGNATURE-----
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message