Overview

In this tutorial, you will create an Employment Management System for your company to be deployed in a three-tier environment using JSP servlets. By the end of the tutorial, you will know how to store data from a Java class into a relational database, and to access existing database information from Java classes.

Specifically, you will learn how to:

• Create a new TopLink Workbench project

• Enable and add Java classes

• Create and import database tables

• Associate descriptors to tables

• Implement direct and relationship mappings (including self-relationships)

• Use indirection and value holders

• Apply several advanced features such as multiple tables and optimistic locking

• Write TopLink queries

• Create and manage database sessions

• Package and deploy a TopLink application

Before you Begin

Before building the tutorial project, do the following:

1. Download the TopLink_Tutorial.zip file to a host from which you can access your database and application server.

   You can obtain the TopLink_Tutorial.zip file from:

   http://www.oracle.com/technology/products/ias/toplink/doc/1013/MAIN/_tutorial/TopLink_Tutorial.zip

   This file contains all required tutorial files, including Java source, JSP, SQL scripts to create and populate the database, and Ant scripts to build the EAR file and deploy it to OC4J.

2. UnZIP the TopLink_Tutorial.zip file to a local directory (<TUTORIAL_HOME>).

   For more information about the contents of the TopLink_Tutorial.zip file, see the <TUTORIAL_HOME>\readme.htm file.

3. Configure tutorial environment settings file (<TUTORIAL_HOME>\env.properties) by following the instructions in the <TUTORIAL_HOME>\config.htm file.

4. Configure the TopLink Workbench environment (see "Configuring the TopLink Workbench Environment").

5. Create and populate the database tables used in this tutorial (see "Creating and Populating Database Tables").