CS301 F2005 Exercise #7
Java Server Pages with SQL JSTL Tag and Tomcat

Goal:

• Learn how to create JSP web pages with Core/SQL tags in Java Standard Tag Library.
• Learn how to set up deployment directory with deployment director (web.xml), server.xml, library  for a web application with JSP pages with MySQL access.
• Learn how to setup and run the Tomcat server, and deploy web applications.

Description:

1. Learn how to setup and run Tomcat server.

• Login to windom.uccs.edu or any of your designated CS Unix machines.
   

  Last Digit of your Student ID % 5	Designated JSP-MySQL for Web Programming Exercises
  0	sanluis
  1	blanca
  2	crestone
  3	shavano
  4	wetterhorn

• Copy tomcat directory with simple JSP-MySQL web application  demos and the Beer-v1 JSP-Servlet web application with Model-View-Controller design pattern to your public_html directory.
  cd ~<login>/public_html
  cp -r ~cs301/public_html/tomcatChow   .
•  
• Edit ~/.bash_profile to include JAVA_HOME and CATALINA_HOME environment variable and to add $JAVA_HOME/bin into the PATH environment variable.
  • For CSH user, (check “echo $SHELL) edit your .cshrc file with the following
    setenv JAVA_HOME /users/server/students/cs301/public_html/java/jdk1.5.0_03
    setenv path /users/server/students/cs301/public_html/java/jdk1.5.0_03/bin:$PATH
    setenv CATALINA_HOME /users/server/students/<login>/public_html/tomcatChow
  • For BASH user, (check “echo $SHELL) edit .bash_profile PATH=/users/server/students/cs301/public_html/java/jdk1.5.0_03/bin:$PATH :$HOME/bin JAVA_HOME=/users/server/students/cs301/public_html/java/jdk1.5.0_03 CATALINA_HOME=/users/server/students/<login>/public_html/tomcatChow
    export PATH JAVA_HOME CATALINA_HOME
• source .cshrc or source .bash_profile
  so that the environment set up takes effect in the current shell.
  Once this is setup you can use $CATALINA_HOME in shell commands, e.g., “cd $CATALINA_HOME” to get to your own tomcat directory.
• cd $CATALINA_HOME/conf
• configure the server.xml with designated ports and database resource with mysql user/password/database name
• Replace line 13
  <Server port="8005" shutdown="SHUTDOWN">
  with
  <Server port="7<last3digits of your SID>" shutdown="SHUTDOWN">
  This is the port that can receive the remote shutdown admin messages.
• Replace line 77
  <Connector port="8080" maxHttpHeaderSize="8192"
  with
  <Connector port="9<last3digits of your SID>" maxHttpHeaderSize="8192"
  This is the port for receiving plain http requests.
• Replace lines 417-422
   <Resource name="jdbc/InventoryDB" auth="Container"
  type="javax.sql.DataSource"
  maxActive="100" maxIdle="30" maxWait="10000"
  username="cs301" password="cs02web"
  driverClassName="com.mysql.jdbc.Driver"
  url="jdbc:mysql://blanca.uccs.edu:3306/cs301db?autoReconnect=true"/>
  with
   <Resource name="jdbc/InventoryDB" auth="Container"
  type="javax.sql.DataSource"
  maxActive="100" maxIdle="30" maxWait="10000"
  username="<your MySQL login>" password="<your MySQL password>"
  driverClassName="com.mysql.jdbc.Driver"
  url="jdbc:mysql://<your designated mysql server>:3306/<yourMySQLdatabase>?autoReconnect=true"/>
  
  Note that <your MySQL login> is the same as your CS Unix machine login and <your MySQL password> is the 9 digits of your student ID. <your MySQLdatabase> is <yourMySQLlogin>db. <your designated mysql server> is your designated MySQL server.
• Make sure that your server.xml has 700 as access right, i.e., only read by you.
• Replace the Tomcat password in tomcat-users.xml with your choice of password.
• Make sure that your tomcat-users.xml has 700 as access right, i.e., only read by you.
• cd $CATALINE_HOME/bin
• Start the Tomcat with
  ./startup.sh
• Make sure you shutdown Tomcat at the end of the exercise with
  ./shutdown.sh
• Type in http://windom.uccs.edu:9<last3digitsOfSID>/ in a browser and observe the tomcat default web page.
• Try to execute some of the JSP web pages and examine their source code from "JSP Examples" link in the Example section. Same for Servlet Examples.
• Click on the "Tomcat Manager" link in Administration Section on the left side of the default web page.
• Enter the admin as user name and the password you replaced in tomcat-users.xml file.
• You can observe the list of web applications. You can click stop link to stop them, Reload link if you have updated the servlets or Deployment Director. 
• Click the Beer-v1 link
• Click the beerAdvise.html link
• Select one of the color, then the submit query button.
• Take a snapshort of the output of servlet SelectBeer.java
• Email me the url of snapshort image as hw7 part 1.
• Click back and  return to the manager web page.
• Click path /sql to see list of JSP page of the sql web application
• Click join.jsp link to see the result of an JSP page with select join query on Inventory and Price database tables.
• The url should show http://windom.uccs.edu:9<last3digitSID>/sql/join.jsp
• The result should be similar to http://windom.uccs.edu:9888/sql/join.jsp
• Click back and return to the manager web page.
• Click the Stop link in the row of /sql web application. This will stop the application.
• If you click /sq link, it will say the application is currently not available.
• If you type in http://windom.uccs.edu:9<last3digitSID>/sql/join.jsp as url, you may get a cached copy.  But if you do a shift-reload, you will get HTTP Status 503 "This application is not currently available. 503 is a  HTTP response code.
• Click back to the manager web page again. Hit Start link for the /sql web application.
• Try click /sql link again and see if the list of JSP pages re-appear.

2. Run passwd.jsp catalogDB.jsp

• Try http://windom.uccs.edu:9<last3digitSID>/sql/catalogDB.jsp and passwd.jsp
• Add <form> tag in catalogDB.jsp and put action=http://blanca.uccs.edu/~<login>/cgi-bin/processOrderDB.cgi
  of your cgi script and see if it works. A JSP web page called a CGI script.

3. Shutdown Tomcat.

• Make sure you shutdown tomcat.
• $CATALINA_HOME/bin/shutdown.sh
• You will be penalized if you forgot to shutdown you tomcat server.