Re: [Haskell-cafe] The ping method in HDBC

Agent Zhang wrote:

Hi, there

I'm wondering if there's a ping method in HDBC that does the same thing as Perl DBI's ping. Please see the following link for details:

http://search.cpan.org/~timb/DBI-1.605/DBI.pm#ping

I think It's rather important for database auto-connection when preserving database connections for a quite long time in fastcgi applications. Any ideas?

Thanks in advance!

There's no specific ping function, but you can try something like: run dbh "SELECT 1" [] I note from the Perl DBI documentation that it is not guaranteed that its ping function actually does anything. I am pondering connection pools in HDBC for the future, if I have the need for it. -- John