Fee Management Tool

This is a web application used by staff of a college or institute to handle all transactions related to fees. It generates arrears report, receipts report etc.

Technologies and Products used

The following are the steps to related to be taken to run the existing part of the application :

  1. Create fmt account with password fmt in Oracle10g Express Edition. This must be done by after you log in as SYSTEM user.
          create user fmt identified by fmt;
          grant connect,resource to fmt;
        
  2. Create required tables in fmt account by using commands in tables.sql file of fmt.zip.
  3. Download fmt.zip and unzip it into d:\fmt directory. You can substitue d:\ with another path if you like.
  4. Start NetBeans 5.0 or above
  5. Open fmt project in NetBeans using File->Open Project option.
  6. Add Oracle Library - ojdbc14.jar, JSTL library and Java Mail library (mail.jar and activation.jar) to fmt project.
  7. Build and deploy the project to embeded Tomcat of NetBeans.
  8. Run this project - you must see login.jsp page.
  9. Before you run Send Mails program, make sure you create required mail addresses in CMail Server.

Deploying Web Application In Tomcat of JBoss

The following procedure explains how to deploy a web application fmt, developed with Tomcat that is embeded with NetBeans to Tomcat embeded in JBOSS application server.
  1. You better change port number at which Tomcat in JBoss is running using JBOSS_HOME\server\default\deploy\jbossweb-tomcat55.sar\server.xml file. Change port number of HTTP Container from 8080 to 9999.
    This is required as Oracle10g also uses 8080.
  2. Copy fmt.war from dist directory of fmt project into JBOSS_HOME\server\default\deploy directory.
  3. Run the application using the following url:
       http://localhost:9999/fmt
     
  4. You should see login page of the application.