wood burning stoves 2.0*
The moose likes Tomcat and the fly likes Datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Datasource" Watch "Datasource" New topic
Author

Datasource

Glenny Dsilva
Ranch Hand

Joined: May 09, 2005
Posts: 42
The example given in tomcat 5.0 documentation is running successfully on my machine.

I not clear with one point is that when i check the processes runing in Mysql it is showing only "1" process while in the server.xml we have set the number of active connections as "100".

The server.xml file copy is below

<ResourceParams name="jdbc/TestDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>

<!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>

<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>

<!-- Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>

<!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value>11111</value>
</parameter>

<!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>

<!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours.
-->
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/javatest?autoReconnect=true</value>
</parameter>
</ResourceParams>

Pls. clear this point regarding connection pooling.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Datasource
 
Similar Threads
Context and WAR file
Very slow to hook up to MySQL db
Configuring a MySQL DataSource in Tomcat5
getting familiar with Tomcat 5.5
Connectionpooling in tomcat 5.5