in reply to DBD::Sybase - How to reconnect through err_handler

I've been asked to do similar things in the past for PgSQL, so you may try the results of my efforts - DBIx::AutoReconnect, or it's bloatier relative, DBIx::Roles::AutoReconnect. These modules detect DBI errors by transparently wrapping all method calls in eval, making them restartable, and check the connection status by calling $dbh->ping() ( vs $dbh->DBDEAD you were using ). I didn't test the logic on Sybase, but I'd like to know if it was useful there.

Replies are listed 'Best First'.
Re^2: DBD::Sybase - How to reconnect through err_handler
by jfroebe (Parson) on Nov 08, 2006 at 13:46 UTC

    That is definitely something to take a look at :), atleast for new development. Merging it into legacy code may be a bit trickier (politically and technically).

    Jason L. Froebe

    Team Sybase member

    No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1