Re: Apache:DBI DBD::Informix and dbping

#1

On Thu, Sep 1, 2011 at 02:10, Clive Eisen <clive (AT) serendipita (DOT) com> wrote:

Quote:

I'm using mod_perl and Informix, and therefore Apache:

BI 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/**Apac.../lib/Apache/**
DBI.pm <http://search.cpan.org/%7Ephred/Apac.../Apache/DBI.pm

suggests that I need a dbping method and an example is supplied
What 'simple' piece of sql do the team suggest?

Quote:

select 1 from systables where tabid =1

That is the simplest one that works in (almost) any Informix database. To
be safe against 'MODE ANSI' databases, you'd use:

SELECT 1 FROM "informix".systables WHERE TabID = 1

This is safe in a MODE ANSI databases, and any version from 4.00 onwards.

--
Jonathan Leffler <jonathan.leffler (AT) gmail (DOT) com> #include <disclaimer.h>
Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Apache:DBI DBD::Informix and dbping

comp.databases.informix comp.databases.informix

Re: Apache:DBI DBD::Informix and dbping - 09-01-2011 , 09:55 AM