in reply to Re^7: Preventing database handles from going stale
in thread Preventing database handles from going stale

It is, I just took a peek at the source code for it, and it does a SELECT (dbd_db_ping(dbh) in dbdimp.c). I don't know why that wouldn't be enough to keep the connection alive though...Perhaps the query needs to interact with an existing table to keep the connection alive?

__________
The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it.
- Terry Pratchett

  • Comment on Re^8: Preventing database handles from going stale

In Section Seekers of Perl Wisdom