Return-Path: <piyushs@imagine-sw.com>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 94377 invoked from network); 9 Jan 2001 19:08:26 -0000
Received: from ftp1.imagine-sw.com (HELO mail-ny.imagine-sw.com)
 (206.232.17.3)
  by h31.sny.collab.net with SMTP; 9 Jan 2001 19:08:26 -0000
Received: from ntbo3 (ntbo3 [192.9.201.134])
	by mail-ny.imagine-sw.com (8.9.3/8.9.3) with SMTP id OAA21493
	for <cocoon-users@xml.apache.org>; Tue, 9 Jan 2001 14:07:53 -0500 (EST)
Message-ID: <000901c07a6f$6ebbe4e0$86c909c0@imagineny.com>
From: "Piyush Sheth" <piyushs@imagine-sw.com>
To: <cocoon-users@xml.apache.org>
References: <004f01c07a64$8fad6e40$86c909c0@imagineny.com>
 <20010109130444.A2382@plan9ws1.uct.usm.maine.edu>
 <3A5B5BD9.7060007@apache.org>
Subject: Re: cocoon and database Connection
Date: Tue, 9 Jan 2001 14:07:32 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N

That's what one would expect of database connection( as done in Cocoon2 )
management.

Is it possible to use my own database connection pool( such that it starts
when cocoon starts ) and ends once cocoon's
lifetime ends ? If yes how can it be done with cocoon-1.8/2 ?

piyush.

----- Original Message -----
From: Berin Loritsch <bloritsch@apache.org>
To: <cocoon-users@xml.apache.org>
Sent: Tuesday, January 09, 2001 1:43 PM
Subject: Re: cocoon and database Connection


> Matthew Cordes wrote:
>
> > Cocoon itself does nothing, but you can use the turbine connection
> > pool to have a pool of persistent connections (see your
> > cocoon.properties file).  In lieu of that you'd need to make at least
> > a connection per page (use the pool).
>
> In Cocoon 2, there is a pooled Jdbc Connection facility.
> You specify your connection and give it a name in the
> cocoon.xconf file (look in the supplied version on how
> to do that), and then reference it with the <esql:use-connection>
> tag or <sql:use-connection> tag.
>
> The connections are pooled and kept open until the system
> shuts down.  It reclaims connections that are not used
> when they are no longer needed.
>
> >
> > -matt
> >
> > On Tue, Jan 09, 2001 at 12:49:48PM -0500, Piyush Sheth wrote:
> >
> >> How does cocoon manage database connection ?
> >> Does it establish database connection everytime a document( obviously
it has
> >> some fields from database )
> >>  is requested or the connection is persists once cocoon is initialized
and
> >> until it is shutdown.
> >>
> >>
> >> Piyush.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> >> For additional commands, e-mail: cocoon-users-help@xml.apache.org
> >>
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> > For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
>