Win2000XP apache2.0.48 + tomcat5.0.19 + mysql4.0.18 + jdk1.5 (1.4) + JSPservlet integration advancement (2)

3 Tomcat 5.0.19 installation and configuration

3.1 The installation of Tomcat 5.0.19 is best to select the Service section, my installation directory is C: / Tomcat 5.0, below in $ tomcat_home

3.2 In the $ TOMCAT_HOME / Conf directory, open the JK2.Properties text file, add the following

Channelsocket.port = 8009

3.3 In the $ TOMCAT_HOME / Conf directory, open the server.xml file, join before the file's last

factory org.apache.commons.dbcp.basicDataSourceFactory

<-!.. 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 -.> maxActive 10

maxidle 5

maxwait 10000 Username test password testpwd

driverclassname com.mysql.jdbc.driver

<-!.. 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 . -> jdbc: mysql: // localhost / testdb? Autoreconnect = true

3.4 Rename MOD_JK2-2.0.43.dll file is mod_jk2.dll, mainly for convenience, no other purpose, as long as it is consistent with the file name in the $ apache_dir / conf / httpd.conf file, then copy to $ apache_dir / MODULES, only this file is known to DLL

3.5 Tomcat start and background service installation

Go to the command prompt (DOS interface), run startup.bat under $ tomcat_home / bin, remember that the DOS window cannot be closed.

You can also load Tomcat5 as a background service, in $ tomcat_home / bin command, as follows

Service Install

Net Start Tomcat5

If you want Tomcat5 to start automatically as a service, please modify it in your service.

4 Install MySQL and MySQL Control Center4-1 suggestion MySQL installation under the default directory C: / MySQL, because MySQL is not installed in the default directory, sometimes the service will not start, the more troublesome you need to modify 4-2 Configure the JDBC connection to mysql mysql After the Connector / J 3.1 file is decompressed, copy the JAR file into the $ TOMCAT_HOME / COMMON / LIB directory, and add the address in the Environment Variable Settings. I have added the path in advance when the J2SDK installation configuration is, only need to be changed according to you. JAR file name is changed to OK -----

Author: Arthurz Email: YEPPO1979@msn.com