Tomcat6 MySQL connection pool Configuration

The Java + JSP + tomcat6 + MySQL connection pool I recently saw on the Internet is mostly tomcat5. Many of them are not detailed and cannot be configured, which makes us very time-consuming and brainless, today, I finally successfully configured the connection pool of the latest atat6 + MySQL, And I will share the following:

 

1. required files:

Installation File)

 

2. ConfigureContext. xml file

 

Add a connection pool between <context> </context> as follows:

1. <Resource Name = "JDBC/MySQL"
2. Auth = "Container"
4. Type = "javax. SQL. datasource"
5. Driverclassname = "com. MySQL. JDBC. Driver"
6. Url = "JDBC: mysql: // localhost/test"
7. Username = "root"
8. Password = "root"
9. Maxactive = "100"
10. Maxidle = "30"
11. Maxwait = "10000" type = "codeph" text = "/codeph"/>

I don't need to talk about the above parameters. I know what it means.

 

3. Configure web. xml under your application

 

<Web-app> </Web-app>:

XML Code

1. <Resource-ref>
2. <Description> dB connection </description>
3. <Res-ref-Name> JDBC/mysqlx </RES-ref-Name>
4. <Res-type> javax. SQL. datasource </RES-type>
5. <Res-auth> container </RES-auth>
6. </Resource-ref>

4. Success

 

Do not use the original server. after the configuration is in XML, you can write the test program below. There will be a lot on the internet, mainly on the top. Of course, you need to put the connection drivers under the Lib under Tomcat 6.

 

Gengv: verified and successful.