cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From giacomo <giac...@apache.org>
Subject Re: Turbine Connection Pool
Date Fri, 04 May 2001 18:52:21 GMT


On Fri, 4 May 2001, Drasko Kokic wrote:

> Is it the same Turbine code used in the C2?

No. C2 uses the connection pool from the Avalon project.

Giacomo

>
> --- giacomo <giacomo@apache.org> wrote:
> >
> >
> > On Wed, 2 May 2001 paint007@mc.duke.edu wrote:
> >
> > >
> > > Martin,
> > >
> > > These instructions are for Cocoon 1, I don't know
> > if they are the same for
> > > Cocoon 2.
> > >
> > > You set up a pool in the cocoon.properties by
> > filling out the appropriate
> > > information such as this:
> > >
> >
> processor.xsp.pool.database.mypool.driver=com.sybase.jdbc2.jdbc.SybDriver
> > >
> >
> processor.xsp.pool.database.mypool.url=jdbc:sybase:Tds:myhost:1025/mydb
> > >
> > processor.xsp.pool.database.mypool.username=pooluser
> > > processor.xsp.pool.database.mypool.password=*****
> > >
> > processor.xsp.pool.database.mypool.maxConnections=3
> > >
> >
> processor.xsp.pool.database.mypool.expiryTime=3600000
> > >
> >
> > In C2 you configure the jdbc connection pool in the
> > datasource element
> > in the cocoon.xconf file:
> >
> >   ...
> >   <datasources>
> >     <jdbc name="mypool">
> >       <pool-controller min="5" max="10"/>
> >       <auto-commit>false</auto-commit>
> >
> > <dburl>jdbc:sybase:Tds:myhost:1025/mydb</dburl>
> >       <user>pooluser</user>
> >       <password>*****</password>
> >     </jdbc>
> >   </datasources>
> >   ...
> >
> > Giacomo
> >
> > > Most of this is the same connection info you
> > usually put inside of
> > > <esql:connection>.  Replace "mypool" with whatever
> > name you want to use for
> > > your pool.
> > >
> > > Then, in <esql:connection>, you use a single tag,
> > <esql:pool>, to name the pool you want to use:
> > >       <esql:connection>
> > >         <esql:pool>mypool</esql:pool>
> > >         <esql:execute-query>
> > >         ...
> > >
> > > It works great for us.
> > >
> > > -Christopher
> > >
> > >
> > >
> > >
> > >
> > >
> > > Please respond to cocoon-users@xml.apache.org
> > >
> > > To:   <cocoon-users@xml.apache.org>
> > > cc:
> > >
> > > Subject:  Turbine
> > >
> > >
> > > Hi,
> > >
> > > Has someone installed and ran Cocoon with
> > Connection Pooling?
> > >
> > > If so, could you tell me how to use it within esql
> > ?
> > >
> > > thanks!
> > >
> > > Lic. Martin O. Mauri
> > >
> > >
> > >
> > >
> > >
> > >
> >
> ---------------------------------------------------------------------
> > > Please check that your question has not already
> > been answered in the
> > > FAQ before posting.
> > <http://xml.apache.org/cocoon/faqs.html>
> > >
> > > To unsubscribe, e-mail:
> > <cocoon-users-unsubscribe@xml.apache.org>
> > > For additional commands, e-mail:
> > <cocoon-users-help@xml.apache.org>
> > >
> > >
> > >
> > >
> >
> >
> >
> ---------------------------------------------------------------------
> > Please check that your question has not already been
> > answered in the
> > FAQ before posting.
> > <http://xml.apache.org/cocoon/faqs.html>
> >
> > To unsubscribe, e-mail:
> > <cocoon-users-unsubscribe@xml.apache.org>
> > For additional commands, e-mail:
> > <cocoon-users-help@xml.apache.org>
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
> To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
>
>
>
>


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message