tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Trond Hersløv <>
Subject db-connectin is working fine, but is it pooling?
Date Fri, 23 Sep 2005 00:06:32 GMT
I'm running TC5.5 and MySQL-4.0.20 on two separate Linux boxes.
Trying setting up a DB connection pool, I followed the example found on:

Everything works just fine, but I'm a little bit concerned that maybe I am generating a singel
connection to the DB and not a pool of connections.
As I run  netstat -a on the machine hosting the DB, I expected to find
a lot of connections to port 3306, which my MySQL server listens to, but there is only one
single connection. Even when I press F5 for a long time to refresh my IE window like a 100
times or with more windows open at the same time there is just this one connection to be found.

<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
               maxActive="100" maxIdle="30" maxWait="10000" minIdle="10"
               username="pool" password="pool"

Have I misunderstood the concept of connection pooling?
Where does the magic happened. Nothing hier like a factory or pooling class?
Regards Trond

This email message has been swept by
MIMEsweeper for the presence of computer viruses.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message