persistent DB connections

[Hartmaier Alexander]

Title: Briefvorlage

Once again. It seems that our app has a dbh leak. The sessions to our Oracle db increase and never get closed or used again. I want to use my DBIx::Class module to access the db and want to store a DBIx::Class::Schema object which holds a db connection somewhere, so I can access it from my embperl pages and my embperl library I include with Execute ({ inputfile => 'nacadminlib.epl', import => 1 }); in every page. I looked at the Embperl docs but couldn’t find a solution. Put it in $epreq, or $epapp? How to do it to get one per apache2 child?   Thanks in advance!   -Alex   *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien Handelsgericht Wien, FN 79340b *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* Notice: This e-mail contains information that is confidential and may be privileged. If you are not the intended recipient, please notify the sender and then delete this e-mail immediately. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*