Experience JSP server under win98/2000 (with database, novice dedicated)

js| Server | data | Database This setting is used for practice, very simple and convenient.

The database server is the MSSQL server personal. Ann installation by default.

JDK is version 1.4, download page: http://java.sun.com/j2se/1.4/index.html
is also installed in the default manner.

JSP server is Jakarta TomCat 4.0, now the latest is 4.0.4, download page: http://jakarta.apache.org/builds/jakarta-tomcat-4.0/release/v4.0.4-b2/
or the default installation, to install the JDK first.

Add the following lines to the Autoexec.bat:
Path= "%PATH%"; C:\progra~1\micros~1\80\tools\binn; C:\JDK140; C:\JDK140\BIN

Set java_home=c:\jdk140
Set TOMCAT_HOME=C:\TOMCAT40

SET classpath=.; C:\JDK140\LIB\merlia.jar; C:\JDK140\LIB\dt.jar; C:\JDK140\LIB\tools.jar; C:\JDK140\LIB\htmlconverter.jar

Notice the Merlia.jar inside the classpath, which is the inet JDBC driver, which is type 4.

The following is said JDBC driver, download page is: http://www.inetsoftware.de/English/Produkte/MERLIA/default.htm
Choose Download on the left, then add a table can be downloaded. After downloading is a zip file, I Merlia.jar solution to the Java under the Lib, but also changed the name (because at the beginning of the time out of the problem, I randomly come up with the method, in fact, there is no need. But the blunt knife said, The case should be consistent!).

OK, so far, a JSP server has been done. The method of testing the JSP is: http://localhost:8080, the method of testing the database is: first compile Merlia extract the Classicdriver.java in the catalog of sample ( Javac Classicdriver.java), then run (Java classicdriver>result.txt), and note that you want to start MSSQL server.

Another point to note is that the default port for SQL Server in Classicdriver is 1433, and the default port I install is 1113, which is: Start-> program->mssql server-> server-side Network Utility-> TCP/IP properties, and restart SQL Server after modification.


Configuring Tomcat under Win2000 is actually very simple, as long as you set the Win2000 two environment variables.
Add the following environment variables as follows:
java_home=d:\jdk1.3//directory to install path to JDK
tomcat_home=d:\tomcat4.0//directory against Tomcat installation path
Add d:\jdk1.3\lib\tools.jar;d:\jdk1.3\lib\dt.jar;//directory in classpath to the installation path of JDK
Add d:\jdk1.3\in;d:\jdk1.3;//directory to the installation path of the JDK in path
All OK, no reboot, you can start Tomcat.