Skip Headers

Oracle TopLink Developer's Guide 10g Release 3 (10.1.3) B13593-01 |
| Home | Solution Area | Contents | Index

Previous | Next |

# 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").