[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
>>$dbh.
>>
>>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
Developer
Plus Three, LP





More information about the ClassDBI mailing list