--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:

> Hi,
>
> > So i want to use "pingInterval" to keep it alive but it doesn't

seem

> > to work : i look at the network activity (with ethereal from

debian

> > server that supports tomcat) and nothing happens : no packet
> > transmitted to FireBird server. Here are my parameters for JayBird
> > pool in server.xml (note, in my java code I get a connection -

make

> > my queries - close my connection) :
>
> Pool will not send "pings" when connection is in pool. Pool will

execute the

> "ping" statement when connection that is returned from pool was not

used

> longer than "pingInterval". When the "ping" statement fails, it

will mark

> the connection as "broken", close it, remove it from the pool and

will try

> to fetch the new one.
>
> This feature will not prevent connections from closing, however you

should

> never obtain a connection that is unusable.
>
> If you do want to keep the connection open while keeping it in the

pool, you

> have to modify sources of the pool to do this. I think the most easy
> approach is to extend the thread that checks the idle timeout

and "ping" the

> connection there.
>
> BTW, you can ignore the pingStatement parameter, by default it

is "SELECT

> CAST(1 AS INTEGER) FROM rdb$database", it is guaranteed to succeed

if the

> connection is working.
>
> Roman

sorry, I forgot another question : PingInterval is in second or
millisecond? thanks