On 07/19/2016 05:37 AM, James Smith wrote: > > > 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. >>
There is a ODBC driver under DBD if someone wanted to use it (for whatever reason) > 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!) > > > > -- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and and extermination camps, but incompatible with living as a free human being. -RI Safir 2013
