Introductory Tutorial

In the introductory tutorial, you will create mappings from a simple database three-tier application using OracleAS TopLink Mapping Workbench. You will learn how to:

• Create a new project

• Enable and add Java classes (provided with the tutorial)

• Create and import database tables

• Associate descriptors to tables

• Implement mappings

By the end of the tutorial, you will be able to store data from a Java class into a relational database and access existing database information from Java classes.

Overview

This tutorial project manages the employee database at the ACME Leisure Company. The system tracks each employee's name, address, and phone number.

The system uses these classes:

• Employee – Represents both full-time ACME employees and temporary contractors working on ACME projects. It includes the employees' personal information as well as references to their home addresses and phone numbers.

• Address – Represents the employee's home address. The class contains country, street, city, province, and postal code information.

• PhoneNumber – Contains the telephone number(s) for each employee and contractor (number, area code, and type information). The class also includes a reference to the employee who owns the phone number.

Figure B-1 illustrates the object model for this system.

Figure B-1 Simple ACME Object Model

Description of the illustration intrmod.gif