Jakarta Project

NOTE: This page describes a Tomcat 5 webserver running on port 8080. This is used by COSC students who have an account on triton.towson.edu.

To get started, all you need to do is execute this command script from the triton shell prompt (after logging in to triton with ssh):

~schmitt/bin/webappacl

This script asks for a password and stores it (encrypted) in a file as ~/.passwd Re-run the script if you wish to change your password. This password is only for the purpose of accessing the "Manage your Webapp" see the link below.

If you have a web application on your triton files starting at ~/web-app there is a command that makes a war file for you. This war file will contain files from your triton web-app directory.

~schmitt/bin/makewar

The makewar command will create a war file stored in /tmp and the filename will be your userid (with suffix .war). This war file can be deployed after logging into the tomcat webapp manaager.

New web applications should be developed and debugged using NetBeans. NetBeans will automatically create the war file. To deploy one of these NetBeans web applications, use secure FTP to upload the war file to triton (usually the /tmp directory since filestorage quota is not a problem there). Once the war file is on triton, it can be deployed by the tomcat webapp manager.

To obtain the secure FTP client, visit OTS Downloads Download the SSH client which includes the secure FTP client. Do not use the FTP (File Transfer Protocol) Client "WS-FTP LE for Windows"

Using NetBeans -- general information on the Netbeans IDE

Using NetBeans -- to create your war file

Manage Your Webapp -- Requires login

http://triton.towson.edu:8080 --

Web Application Server

News:

web-app/WEB-INF/lib
Database access: Try your database settings in this page to confirm proper access.
MySql Driver: com.mysql.jdbc.Driver
MySql URL: jdbc:mysql://triton.towson.edu:5030/web01s3

<sql:setDataSource var="mysql" url="jdbc:mysql://localhost:5030/web01s3" driver="com.mysql.jdbc.Driver" user="your_userid" password="your_password" />
HSQL Driver: org.hsqldb.jdbcDriver"
HSQL URL: jdbc:hsqldb:/home/users/some_user/db
This 100% java database runs on the same JVM as your servlet. The database name db is located in the user's file system in the folder given in the HSQL URL. This example gives the user's home directory and the database name is db.
Note that HSQL saves files:
- db.data -- binary data
- db.properties -- definitions
- db.log -- a log file to re-build the database if the system crashes
Use CREATE CACHED TABLE instead of CREATE TABLE so that the table is kept on disk rather than in high-speed memory
Userid: "sa"
Passwd: ""
Oracle Driver: oracle.jdbc.driver.OracleDriver
Oracle URL: jdbc:oracle:thin:@orion.towson.edu:1521:cosc

<sql:setDataSource var="mysql" url="jdbc:oracle:thin:@orion.towson.edu:1521:cosc" driver="oracle.jdbc.driver.OracleDriver" user="your_userid" password="your_password" />

Additional resources

JSTL tag libraries To use JSTL, your web application must have a web.xml and the appropriate .tld tag library files. All these files must be in the WEB-INF directory.
JSTL Files
Web Application Design
java.sun.com/products/jsp/jstl
http://java.sun.com/webservices/nutshell.html
http://www.oop-reserch.com/mysql.html
http://developer.java.sun.com/developer/technicalArticles/WebServices/JWSDP_1.1/
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/class-loader-howto.html