cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Drasko Kokic <drasko_ko...@yahoo.com>
Subject [C2.0a4] Connection Pooling
Date Sat, 05 May 2001 16:06:58 GMT
The version I have has got the following default
entry:
  <datasources>
    <component-instance name="personnel"
class="org.apache.avalon.util.datasource.JdbcDataSource">
      <pool-controller min="5" max="10"/>
      <dburl>jdbc:postgresql://localhost/test</dburl>
      <user>test</user>
      <password>test</password>
    </component-instance>
  </datasources>

Is it okay that the element is called differently?  I
still havent tried ESQL and connection pooling under
C2

Drasko
--- giacomo <giacomo@apache.org> wrote:
> 
> 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>


Mime
View raw message