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
