Re: [CDBI] reconnecting after timeout

>>Ima::DBI calls $dbh->ping and checks $dbh->{Active} before it uses the

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

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi