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.