Summary of jsp project deployment in Apache Tomcat 5.5 -- basic configuration

Last week, the leader told me to deploy a JSP project. Since I have never been in touch with JSP, I immediately found some documents on the Internet about how to deploy the jsp project in Apache Tomcat 5.5. In fact, this is not difficult, but it is troublesome to encounter some objective factors. I deployed it for a day. The strange thing is that I couldn't connect to the database, finally, I found in a forum that the reason may be that the SQL Server 2000 SP4 patch was not installed on the SQL Server database. So I immediately downloaded the patch from the Internet and installed it. Then I tried again. Everything went smoothly and logged on to the system smoothly. However, after I entered the system, I found that all the pages were garbled. It was a headache and I had to find some solutions to the JSP garbled problem on the Internet, it took two days to successfully deploy the JSP project. Ah, the first time I deployed my JSP project, it was really bumpy and tortuous! However, after this deployment, I am also very experienced. Now I have recorded the whole process of my deployment and the solution to the problem. I hope it will help you!
I. necessary software:Apache-tomcat-5.5, jdk-1.5, SQL Server 2000 driver for JDBC, SQL2000-KB884525-SP4-x86-CHS (SP4 patch/I am suffering from this stuff), SQL server 2000 installer.

Ii. Software Installation

1. Install SQL Server 2000During installation, note the following:

Run the autorun.exe file or other executable files. After the installer is called up, the interface shown is displayed. Select "Local Computer" and click "Next ".

Select to create a new SQL Server instance ......", Click Next

Select "server and client tools" and click Next

Note that it is critical to select "hybrid mode" () for authentication "(). Note that the sa logon password cannot be the same as the Windows logon password. If the same occurs, the software cannot connect to the database. Sa is the advanced user name, and the sa password is the initial password of the software. You can install it later by default.

2. Install the patch SQL Server 2000SQL2000-KB884525-SP4-x86-CHS. EXE, displayed after double-clicking

Then you can install it by default, find setup. bat in the SQL2KSP4 directory of drive C, double-click it, and then select:
SQL Server System Administrator..., enter the sa password you set when installing SQL Server 2000.

The following is OK!

3.Jdk-1.5 InstallationIt's easy. I won't go into details here.

4. InstallationApache -- tomcat-5.5Note: The Key is as follows:

If you pay attention to the port configuration, the default value is 8080. You can set any port in the port range, for example, 8888, but ensure that the port is not occupied;

For example, you must select the corresponding JDK version during the installation process. If you select an incorrect version, the configuration may also be incorrect.

5. Installation of SQL Server 2000 driver for JDBCYou can simply double-click the default installation.

Finally, find the msbase under Microsoft SQL Server 2000 Driver for JDBC \ lib. jar, mssqlserver. jar, msutil. jar files are copied to Tomcat-5.5.20 \ common \ lib in the bin directory of tomcat. (This is important for everyone to pay attention to), then you can start tomcat and access http: // localhost: 8088 (set the port to 8088) in IE ), if you see the welcome page of tomcat, the installation is successful.