Server|server2000|sql finally solved the problem of many days of connection pool, write down this article to share with you. I am configured under the tomcat5.5.9, tomcat5.5.x and previous versions have some differences, so the configuration is also different. I'll just say the basic steps in tomcat5.5.9 configuration: (Make sure you install tomcat5.5.9, sql2000)
1. Copy database JDBC driver to%tomcat_home%/common/lib and%tomcat_home%/webapps/yourweb/web-inf/lib (my WEB folder name is QuickStart)
This step is known to all, otherwise Tomcat cannot connect to the database.
2, modify the%tomcat_home%/conf/server.xml file, between <GlobalNamingResources></GlobalNamingResources>
The above content according to everyone's specific situation to modify accordingly, for example: Name= "Jdbc/quickstart" in the QuickStart to and your Web folder name, the password= "123456" in the "123456" to your database password.
3. Create a new XML file with the same name as your Web folder under%tomcat_home%/conf/catalina/localhost (Mine is quickstart.xml)
This step is very important, if you do not have this step will be wrong, will appear org.apache.tomcat.dbcp.dbcp.SQLNestedException:Cannot create JDBC driver of class ' for connect URL ' null '
Such an error, add the 2nd step in the file, as follows:
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.