Apache:DBI DBD::Informix and dbping

Posted in 2011

Clive Eisen — Thu, 01 Sep 2011 12:10:37 +0300 — source: Usenet: comp.databases.informix

I'm using mod_perl and Informix, and therefore Apache::DBI and DBD::Informix It seems I am running into stale database handles That is to say a connect in my code 'works' but any operation on the dbh fails with a can't call method 'blah' on an undefined value after a time. Reading http://search.cpan.org/~phred/Apache-DBI-1.10/lib/Apache/DBI.pm suggests that I need a dbping method and an example is supplied What 'simple' piece of sql do the team suggest? select 1 from systables where tabid =1 for example? TIA -- Clive