Andrew, I found the following in Tyrex mailing archive:
----------------- cut here -----------------------------
Re: [tyrex-dev] JDBC Pool Size in Tomcat 4.0
Date: Fri, 05 Oct 2001 13:07:46 -0700
From: arkin <[EMAIL PROTECTED]>
Subject: Re: [tyrex-dev] JDBC Pool Size in Tomcat 4.0
The connection you get from getConnection() is always a new connection.
This is a logical connection, and the driver is required to always give
a new logical connection when getConnection() is called.
Tyrex obtains a physical connection by calling a different
getConnection() method on a PooledConnectionDataSource. This returns a
PooledConnection, from which any number of logical connections can be
obtained without opening a new network connection.
The driver must support the PooledConnectionDataSource or XADataSource
interfaces, and must implement them in such a way that opening a new
logical connection does not open a new physical connection.
We are using Oracle 8i, Sybase 12.5 and DB2 7.1 and experiencing no
problems.
arkin
------------------------ cut here ------------------------------
So they say that everything depends on your database,
however I found pool related staff in the tyrex source code.
Also I am surprised that people in this mailing list don't response.
Though I am sure (of my experience) the real work is impossible without
connection pool!
Andrew Rodwell wrote:
> Lev,
>
> I have this impression also of Tyrex. Every servlet seems to be a new pool.
> Is that your experiance. Each time the servlet runs a new connection.
>
> Andrew
>
> -----Original Message-----
> From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> Sent: 05 March 2002 10:53
> To: Tomcat Users List
> Subject: Re: Who uses connection pool?
>
> I am not sure Tyrex's connection pool really works.
> Do you use JNDI when you work with bitmechanics staff?
> If yes could you please show me that?
>
> Reynir Hubner wrote:
>
> > yeah you can use that one, it is good, and you have docs on it in the
> > jakarta website.
> >
> > Bitmechanics pool is not only for GSP. I've never used GSP, but I have
> > used the JDBC-pool alot.
> > it's good for most drivers, I've only had problems using it with DB2
> > drivers.
> >
> > hope it helps,
> > [EMAIL PROTECTED]
> >
> > > -----Original Message-----
> > > From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> > > Sent: 5. mars 2002 09:37
> > > To: Tomcat Users List
> > > Subject: Re: Who uses connection pool?
> > >
> > >
> > > I already looked in there.
> > > I was confused that their pool is for GSP.
> > > Tomcat uses Tyrex by default. How about that?
> > >
> > > Reynir H?bner wrote:
> > >
> > > > sure
> > > > check out bitmechanic.com, thats a fine place to start.
> > > >
> > > > -hope it helps
> > > > [EMAIL PROTECTED]
> > > >
> > > > > -----Original Message-----
> > > > > From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> > > > > Sent: 5. mars 2002 09:09
> > > > > To: 'Tomcat Users List'
> > > > > Subject: Who uses connection pool?
> > > > >
> > > > >
> > > > > Hi!
> > > > > Could you tell me please,
> > > > > does anybody successfully use database connection pool?
> > > > >
> > > > >
> > > > > --
> > > > > Lev Assinovsky Peterlink Web
> > > > > Programmer St. Petersburg, Russia
> > > > > Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Ё
> > > > > E-mail: [EMAIL PROTECTED]
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > To unsubscribe:
> > > <mailto:[EMAIL PROTECTED]>
> > > > > For additional commands:
> > > <mailto:[EMAIL PROTECTED]>
> > > > > Troubles with the list:
> > > <mailto:[EMAIL PROTECTED]>
> > > > >
> > > > >
> > >
> > > --
> > > Lev Assinovsky Peterlink Web
> > > Programmer St. Petersburg, Russia
> > > Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7
> > > E-mail: [EMAIL PROTECTED]
> > >
> > >
> > >
> > >
> > > --
> > > To unsubscribe: <mailto:[EMAIL PROTECTED]>
> > > For additional commands: <mailto:[EMAIL PROTECTED]>
> > > Troubles with the list: <mailto:[EMAIL PROTECTED]>
> > >
> > >
> >
> > --
> > To unsubscribe: <mailto:[EMAIL PROTECTED]>
> > For additional commands: <mailto:[EMAIL PROTECTED]>
> > Troubles with the list: <mailto:[EMAIL PROTECTED]>
>
> --
> Lev Assinovsky Peterlink Web
> Programmer St. Petersburg, Russia
> Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7
> E-mail: [EMAIL PROTECTED]
>
> --
> To unsubscribe: <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>
--
Lev Assinovsky Peterlink Web
Programmer St. Petersburg, Russia
Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7
E-mail: [EMAIL PROTECTED]
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
