DBCP Connection Validity Check
- From: "gp" <parcha@xxxxxxxxx>
- Date: 14 Apr 2006 14:48:13 -0700
I use Apache's DBCP for my Connection Pool implementation. (Default
connection: 5 connections, with 1000 secs for idletimeout). I usually
connect to Oracle 10g DB.
While creating the Pool, I pass on the validityCheck(Select count(*)
from table_name where table_name has no data) query to the DBCP
interface PoolableConnectionFactory.
So my connection pool works with DBCP and I can do operations from the
app.
To test the Validity Check:
I bounce the DB and bring it up immediately.
So when I try to perform certain acitivites on my UI, I get
exceptions(Connection Exceptions) for the first 2 attempts and from the
3rd attempt everything works fine. Then onwards my app is able to get
data from DB as usual.
I also see that testonBorrow is set to TRUE by default.
Any information as why I see the above situation would be helpfull.
Thanks.
.
- Prev by Date: [ANN] SQLeonardo 2006.03 released
- Next by Date: Access Database Read and Conversion
- Previous by thread: [ANN] SQLeonardo 2006.03 released
- Next by thread: Access Database Read and Conversion
- Index(es):
Relevant Pages
|
|
