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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, October 18, 2001 10:32 AM > > To: [EMAIL PROTECTED] > > 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 > > [EMAIL PROTECTED] with a subject of: > > unsubscribe tyrex-dev > > ----------------------------------------------------------- > If you wish to unsubscribe from this mailing, send mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe tyrex-dev
