List Info

Thread: persistent DB connections
persistent DB connections
user name
 2006-05-22 13:41:28 

  


  

    





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.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*		
  

  
  
   
     
    

  

    persistent DB connections
  


  

     user name

     2006-05-29 04:30:46
  


  

    
> 
> 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?
> 

Putting it in $epapp should work, but will get a db handle
for every
different name you specify with Embperl_App in your
httpd.conf file.

The other possibility is to put it in a global variable,
then you will get a
handle per Apache child

Gerald


 
** Virus checked by BB-5000 Mailfilter ** 


------------------------------------------------------------
---------
To unsubscribe, e-mail: embperl-unsubscribeperl.apache.org
For additional commands, e-mail: embperl-helpperl.apache.org



  


  

    
  

  
  
   
     
    






 [1-2]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )