Make suer you use validationQuery parameter, copypaste from DBCP
config help: http://jakarta.apache.org/commons/dbcp/configuration.html
validationQuery
The SQL query that will be used to validate connections from this pool
before returning them to the caller. If specified, this query MUST be
an SQL SELECT statement that returns at least one row.

> > I have still the same problem (using BasicDataSource still because
> > already used in my application) but I try to 'occupy' application to
> > make a test : I made a thread which questions database every inute
> > and I log results (I know, it isn't the best solution!).
> >
> > first test : I use my application. thread is OK but I can't get a
> > connection after 30 min of inactivity when I try to re use my
> > application.
> > second test : I don't use my application any all. thread is OK
> > (durign 928 min!!!) but when I try my application in browser, I
> > can't get a connection!
> >
> > I don't understand why I arrive to get connection in my thread (on
> > the pool too) but not in application after a time of inactivity!

> Because pool contains multiple connections. The one that is used by

the thread is ok, the rest were closed. Either configure your pool
correctly, or configure you servers not to close inactive sockets.

> Roman