Environment configuration of JSP and SQL links

1. Set Environment Variables

Catalina_base D:/program files/Java/tomcat 5.0.28

Catalina_home D:/program files/Java/tomcat 5.0.28

Classpath

% Java_home %/bin ;.; % java_home %/LIB; % java_home %/lib/DT. jar; % java_home %/lib/tools. jar; % catalina_home %/common/lib/servlet-api.jar; D:/program files/Microsoft SQL Server 2000 driver for JDBC/lib/msbase. jar; D:/program files/Microsoft SQL Server 2000 driver for JDBC/lib/MSSQLServer. jar; D:/program files/Microsoft SQL Server 2000 driver for JDBC/lib/msutil. jar

Java_home D:/program files/Java/jdk1.6.0

Path

% Java_home %/bin; % SystemRoot %/system32; % SystemRoot %/system32/WBEM; C:/program files/Microsoft SQL Server/80/tools/binn

 

2. Database considerations

Select SQL Server and windows for authentication

Right-click "properties" of "(local) (Windows NT)" under "SQL Server group", and select the "Security" tab in the displayed dialog box, set the AUTHENTICATION option to the previous one: SQL Server and windows. Click OK! The connection statement does not need to be changed!

 

3. Tomcat

Copy the three JDBC jar files to the/tomcat 5.0.28/common/lib directory and set their environment variable parameters.

 

4. The C disk format is FAT32, and the rest are NTFS.

5. Don't forget to patch SP4.