On 7/19/2016 9:58 AM, yhp...@orange.fr wrote:
Jie,

I have been using Apache::DBI, but I don't think it is something like JDBC.

Thankfully not - JDBC is one of the biggest nightmares our DBAs face - if we have network issues (firewall session timeout e.g.) we have had all sorts of problems with
oracle jdbc connections.

We actually don't even use Apache::DBI (we are primarily MySQL) as the "uncontrolled" caching of connections can lead to problems - flooding database servers with open connections, connections failing because of firewall issues. We explicitly cache (and reconnect) using DBIx::Connector to cope with the few databases we explicitly want
vast connections...

Admitedly many of our servers have upward of 30-40 apps on them, talking to 40-50
different databases (quite often on the same server!)




--
The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE.

Reply via email to