During this tutorial series, you will develop a version of an IT ticketing system called Trouble Ticket Tracking System (which can be enhanced to be a full-blown application).
Trouble Ticket Tracking System is a web-based application that manages and maintains lists of tickets submitted for the products of an organization. Customers can submit tickets for a specific product and can view the status of a ticket at any time. The submitted ticket can be picked by a technician from the pool of submitted tickets. Once assigned, the technician is the owner of that ticket and is responsible for resolving it. A submitted ticket can have different life-cycle states such as: NEW, for a newly submitted ticket; ASSIGNED, for when the ticket is assigned to a technician; FIXED, when the problem has been fixed; or CAN_NOT_FIX, if the issue cannot be fixed now. A ticket can have a history for different life-cycle states for tracking purposes.
In this step, you will configure your workspace for Java EE project development and create a new web project for web service development. A Web Project is an Eclipse Java project that contains the source code, web pages, images, resources, and configuration files for building a web application.
Before you start the tutorial steps, download the resources.zip file and unzip it.
The extracted resources folder contains the file TroubleTicketSystem.sql which contains the DDL for creating the database. It also has dao and tests folders that contain the Java DAO classes and test cases respectively. During the later steps, you are required to import and use them.
Note: The required software for this tutorial is as follows:
Oracle Database 10g XE
Oracle W ebLogic Server 10gR3
Oracle Enterprise Pack for Eclipse 11g (184.108.40.206)
Navigate to your eclipse installation and run eclipse.exe. Close the welcome screen. Open the Java EE perspective, if not already open by going to Window > Open Perspective > Other > Java EE.
You will perform following tasks in this step:
In this step, you will create the Dynamic Web Project TroubleTicketSystemServer and add it to the TroubleTicketSystemEAR project as a web module.
In this step, you will use the Data Source Explorer to browse the database structure and relationships. Switch to the JPA perspective .
Click the arrow below to navigate through the tutorial: