Mailing-List: contact embperl-help@perl.apache.org; run by ezmlm
Precedence: bulk
Received-SPF: pass (asf.osuosl.org: local policy)
From: Gerald Richter <richter@ecos.de>
Organization: ecos gmbh
To: embperl@perl.apache.org
Subject: Re: persistent DB connections
Date: Tue, 6 Jun 2006 11:59:10 +0200
User-Agent: KMail/1.8
Cc: "Hartmaier Alexander" <Alexander.Hartmaier@t-systems.at>
References: <2812C04B56EA6B43BAFD046B6B9C4763013989D3@MX1MAIL1.int.neonet.at>
In-Reply-To: <2812C04B56EA6B43BAFD046B6B9C4763013989D3@MX1MAIL1.int.neonet.at>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200606061159.10665.richter@ecos.de>

Am Montag, 29. Mai 2006 11:05 schrieb Hartmaier Alexander:
> If i use $epapp, where/when should I set it? Can it be done in my apache2
> config? (startup.pl) Same question for the global var...

You should not open a db connection in startup.pl because handles will not be 
valid after the fork of the children. All other data can be setup in the 
startup.pl and stored in a global variable.

The db connection should be opened at the first request to the db.

Gerald

>
> -Alex
>
> > -----Original Message-----
> > From: Gerald Richter [mailto:richter@ecos.de]
> > Sent: Monday, May 29, 2006 6:31 AM
> > To: Hartmaier Alexander; embperl@perl.apache.org
> > Subject: RE: persistent DB connections
> >
> > > 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 **
>
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
>"* 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.
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
>"*

 
** Virus checked by BB-5000 Mailfilter ** 


---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org