Return-Path: 
 <tomcat-user-return-51099-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 50451 invoked by uid 500); 19 Oct 2001 17:19:17 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: tomcat-user@jakarta.apache.org
list-help: <mailto:tomcat-user-help@jakarta.apache.org>
list-unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
list-post: <mailto:tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 50394 invoked from network); 19 Oct 2001 17:19:15 -0000
Sender: billa@cnet.com
Message-ID: <3BD0608F.2D8B8CDA@cnet.com>
Date: Fri, 19 Oct 2001 13:19:11 -0400
From: William Au <billa@cnet.com>
X-Mailer: Mozilla 4.77 [en] (X11; U; SunOS 5.8 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
To: tyrex-dev@exolab.org, tomcat-user@jakarta.apache.org
CC: tomcat-dev@jakarta.apache.org
Subject: Re: [tyrex-dev] Tomcat 4.0 Tyrex configuration
References: <PBEKICDPDKDBGBPLKBKGEEDFCNAA.mohammed@intalio.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Riad,

Thanks for the info.  I am using Tyrex with Tomcat 4.0.  I do not see any
Tyrex configuration file in the download of Tomcat 4.0.  Where should
this file be if I am to create one?

Is there any documentation on how to use and configure Tyrex with Tomcat 4.0?
Things seem to work but it is not very useable if it is not configurable.

Anyone out there with any comments on using Tyrex for database connections
pooling in general?  I did see some earlier postings stating that connections
are
not being pooled.  But when I look at the source code I see that Tomcat is using

tyrex.jdbc.xa.EnabledDataSource.  So I am not sure if I need to use the
PooledConnectionDataSource myself.

Should I be using something else that is more commonly used (for example,
poolman)?

Bill

Riad Mohammed wrote:

> Hi Bill,
>
> In the Tyrex configuration file the JCA and JDBC connection pool limits are
> specified by:
>
> <limits>
>    <maximum>10</maximum> <!-- maximum number of connections supported -->
>    <minimum>0</minimum> <!-- minimum number of connections required -->
>    <initial>0</initial> <!-- initial pool size -->
>    <maxRetain>300</maxRetain> <!-- maximum time to retain an unused
> connection (in seconds), or zero to retain indefinitely -->
>    <timeout>10</timeout> <!-- timeout when attempting to open a new
> connection (in seconds), or zero to wait indefinitely -->
>    <trace>false</trace> <!-- to enable tracing -->
> </limits>
>
> For example to use limits in a JDBC connection pool:
>
> <dataSource>
>         <name>db</name>
>         <jar>classes12.zip</jar>
>         <class>oracle.jdbc.xa.client.OracleXADataSource</class>
>         <config>
>             <URL>url</URL>
>             <user>user</user>
>             <password>password</password>
>           </config>
>         <limits>
>             <maximum>10</maximum>
>             <minimum>0</minimum>
>             <initial>0</initial>
>             <maxRetain>300</maxRetain>
>             <timeout>10</timeout>
>         </limits>
> </dataSource>
>
> Riad
>
> > -----Original Message-----
> > From: billa@cnet.com [mailto:billa@cnet.com]
> > Sent: Thursday, October 18, 2001 10:32 AM
> > To: tyrex-dev@exolab.org
> > Subject: [tyrex-dev] Tomcat 4.0 Tyrex configuration
> >
> >
> > I am running Tomcat 4.0 and would like to use the bundled Tyrex
> > for database connection pooling.  I followed the Tomcat documentation
> > and was able to make things work.
> >
> > But how do I configure Tyres with additional parameters like the
> > maximum number of connections in the pool?
> >
> >
> > Bill
> >
> > -----------------------------------------------------------
> > If you wish to unsubscribe from this mailing, send mail to
> > minimalist@exolab.org with a subject of:
> >       unsubscribe tyrex-dev
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> minimalist@exolab.org with a subject of:
>         unsubscribe tyrex-dev