Subject Re: [Firebird-Java] Re: Tomcat + DBCP + FireBird
Author Roman Rokytskyy
> hello!

> 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 minute
> 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