[CDBI] reconnecting after timeout

Michael Peters mpeters at plusthree.com
Tue Feb 21 16:19:25 GMT 2006

Jay Strauss wrote:
>>Ima::DBI calls $dbh->ping and checks $dbh->{Active} before it uses the
>>If the connection is dead one of those should return false.
>>It's always worked beautifully for me on every database I tried it on; what
>>DBIx::Class does is extremely similar and I haven't had any problems with
>>that either - including our Oracle-based users, a number of whom came from
>>CDBI and didn't have this problem there either.
>>So I'm definitely voting for "not Class::DBI's fault".
> You're totally correct.  I just ran a script that manually disconnects, and 
> watched the DB for the disconnect, and then it selected using CDBI and I got 
> a new connection.

Just out of curiosity, is there a firewall between the db server and the
application server? I've knocked a lot of holes into walls with my head because
of firewalls silently dropping sockets.

Michael Peters
Plus Three, LP

More information about the ClassDBI mailing list