| Subject | Re: Firebird function to test if a database connection is not disconnected? |
|---|---|
| Author | jeff_j_dunlap |
| Post date | 2009-05-14T01:25:48Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
I think it would be nice to have a FB client function that would allow us to test for a valid database connection. I am assuming that there is no such test, therefore I will likely end up looping through each connection to periodically test for inactive connections and reconnect them.
> you haven't said how you are actually maintaining a connection.The application is an ISAPI application written in C++. I wrote my own connection pool class but I do need to complete that class with some reconnection logic in case a connection happens to disconnect for some reason.
> e.g. PHP can connection pool. so too can ISAPI but I don't know
> which if either you are using.
> The earlier PHP setup was a bit buggy with polling but the
> current setup is quite reliable.
I think it would be nice to have a FB client function that would allow us to test for a valid database connection. I am assuming that there is no such test, therefore I will likely end up looping through each connection to periodically test for inactive connections and reconnect them.