Table of Content

Part 2 Cover

Part 2 - Working with Object-Relational Mapping

Chapter 11 - Introduction to Object-Relational Mapping

Introduction
Key Benefits

Chapter 12 - Getting Started with Object-Relational Mapping

Database Configuration

Database Configuration for Java Project

Configuring Multiple Database Settings

Database Configuration for .Net Project

Configuring Multiple Database Settings

Specifying JDBC Driver File, .NET Driver File and Adapter File

Automatic Downloading JDBC Driver
Automatic Downloading .NET Driver and Adapter File

Supported Database, JDBC Drivers and .NET Drivers

Supporting Multiple Database

Assigning Data Types from Multiple Database
Porting to Other Database
Displaying Data Type based on Default Database

Chapter 13 -Using ORM Wizard

Introduction
Generating Code from Database

Chapter 14 - Object Model

Introduction
Object Models

Creating a Class Diagram

Drawing a Class Diagram

Creating a new Class element to the Class Diagram
Modifying the Class Specification
Adding new Attribute to the Class
Adding Association to the Classes
Editing Association Specification
Setting Stereotypes of classes be ORM Persistable

Synchronizing from a Data Model to an Object Model

Defining Package for Classes
Specifying Inheritance Strategy
Specifying Collection Type
Defining ORM Qualifier
Customizing SQL
Mapping an Object Model to a Data Model

Mapping Classes to Entities
Mapping Attributes to Columns
Mapping Data Type
Mapping Primary Key
Mapping Association
Mapping Aggregation
Mapping Composite Aggregation
Mapping Multiplicity
Mapping Many-to-Many Association
Mapping Inheritance/Generalization

Using Table per Class Hierarchy Strategy
Using Table per Subclass Strategy
Using Mixed Strategies

Mapping Collection of Objects to Array Table
Mapping Object Model Terminology

Showing Mapping between Object and Data Models by ORM Diagram

Creating an ORM Diagram from Existing Diagrams
Drawing an ORM Diagram

Creating ORM-Persistable Class and Mapping Entity to the ORM Diagram

Creating Associated ORM-Persistable Class to the ORM Diagram
Creating Mapping Entity to the ORM Diagram

Showing Attribute Mapping
Supporting Real-time Synchronization

Forming a Class Diagram
Modifying ORM-Persistable Class
Modifying Entity

Switching the View of Mapping

Using ORM Pane

Class View
Database View

Reverse Engineering Java Classes to Object Model
Reverse Engineering Hibernate Model to Object Model

Enterprise JavaBeans Modeling

Creating an EJB Diagram

Drawing an EJB Diagram

Creating a new Entity Bean element to the EJB Diagram
Creating a new Message-Driven Bean element to the EJB Diagram
Creating a new Session Bean to the EJB Diagram
Modifying the Class Specification of Entity, Message Driven and Session Bean
Adding new Attribute to the Entity, Message Driven and Session Bean
Adding Association to the Entity Bean
Editing Association Specification

Synchronizing from a Data Model to an Enterprise JavaBeans Model

Defining Primary Key
Creating a Creator Method
Creating a Finder Method
Mapping an Enterprise JavaBeans Model to a Data Model

Mapping Entity Beans to Entities
Mapping Attributes to Columns
Mapping Data Type
Mapping Primary Key
Mapping Association
Mapping Multiplicity
Mapping Many-to-Many Association
Mapping Enterprise JavaBeans Model Terminology

Chapter 15 -Data Model

Introduction
Entity Relationship Diagram

Creating an Entity Relationship Diagram

Drawing an Entity Relationship Diagram (ERD)

Creating a new Entity element to the ERD
Modifying the Entity Specification
Adding new Column to the Entity
Adding Relationship to the Entities
Editing Relationship Specification

Reverse Engineering an existing Relational Database

Step 1: Select Language
Step 2: Database Configuration
Step 3: Selecting Tables

Synchronizing from an Object Model to a Data Model
Synchronizing from the Enterprise JavaBeans Model to Data Model

Specifying Index Column
Using the ID Generator
Defining Discriminator

Defining Discriminator Column for Entity
Defining Discriminator Value for Class

Creating an Array Table

Defining an Array Table
Defining an Array Type for Attribute in Class
Creating a Partial Table
Splitting Table
Converting to a Partial Table

Copying SQL statements from Tables

Copying SQL statements from Specified Scope

Mapping a Data Model to an Object Model

Mapping Entities to Classes
Mapping Columns to Attributes
Mapping Data Type
Mapping Primary Key
Mapping Relationship

Mapping Identifying Relationship
Mapping Non-identifying Relationship

Mapping Cardinality
Mapping Many-to-Many Relationship
Mapping Array Table to Collection of Objects
Mapping Data Model Terminology

Mapping a Data Model to an Enterprise JavaBeans Model

Mapping Entities to Entity Bean Classes
Mapping Columns to Attributes
Mapping Data Type
Mapping Primary Key
Mapping Relationship

Mapping Non-identifying Relationship

Mapping Cardinality
Mapping Many-to-Many Relationship
Mapping Data Model Terminology

Chapter 16 -Database Schema

Introduction
Generating Data Definition Language and Database

Generating Database from Data Model

Using Database Code Generation Dialog Box

Generating Database for Java Project
Generating Database for .NET Project

Using Wizard

Generating Database from Object Model

Mapping Data Model to Data Definition Language

Chapter 17 - Implementation

Introduction
ORM-Persistable Class

Generating ORM-Persistable Class from Model

Using ORM WizardUsing Database Code Generation Dialog Box

Configuring Code Generation Setting for Java

Using ORM Wizard

Generating ORM-Persistable Class from Object Model

Using Database Code Generation Dialog Box
Using ORM Wizard

Generating ORM-Persistable Class from Database

Mapping Object Model to ORM-Persistable Java Class

Mapping Classes, Attributes and Data Type

Mapping Data Type

Mapping Primary Key
Mapping Generalization
Mapping Association and Multiplicity

Mapping Navigable Association

Mapping Object Model to ORM-Persistable .NET Class

Mapping Classes, Attributes and Data Type

Mapping Data Type

Mapping Primary Key
Mapping Generalization
Mapping Association and Multiplicity

Mapping Navigable Association

Enterprise JavaBeans (EJB)

Generating Enterprise JavaBeans from Enterprise JavaBeans Model

Specifying Entity Bean Code Detail
Specifying Message-Driven Bean Code Detail
Specifying Session Bean Code Detail
Using Update Code

Mapping Enterprise JavaBeans Model to Enterprise JavaBeans

Mapping Entity Bean
Mapping Primary Key
Mapping Association and Multiplicity

Mapping Navigable Association

Mapping Message-Driven Bean
Mapping Session Bean

Deploying Enterprise JavaBeans on Application Servers

Configuring Application Servers

JBoss Application Server
IBM WebSphere Application Server
BEA WebLogic Application Server
Oracle Application Server
JOnAS Application Server

Deploying Beans on the Application Server

Developing a Client Program

Parameter Value for Context Environment in JBoss Client Program
Parameter Value for Context Environment in WebLogic Client Program
Parameter Value for Context Environment in WebSphere Client Program
Parameter Value for Context Environment in Oracle Client Program
Parameter Value for Context Environment in JOnAS Client Program

Chapter 18 - Manipulating Persistent Data with Java

Introduction
Using ORM-Persistable Class

Model API

Manipulating Attributes
Manipulating Association

Smart Association Handling

One-to-One Association
One-to-Many Association
Many-to-Many Association
Using Collection

Standard Association Handling

One-to-One Association
One-to-Many Association
Many-to-Many Association
Using Collection

Persistent API

Using Static Method

Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying

Loading a Collection of Persistent Objects
Using ORM Qualifier
Using Criteria Class

Using Factory Class

Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying

Loading a Collection of Persistent Objects
Using ORM Qualifier
Using Criteria Class

Using POJO

Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying

Loading a Collection of Persistent Objects

Using DAO

Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying

Loading a Collection of Persistent Objects
Using ORM Qualifier
Using Criteria Class

Using Criteria Class

Applying Restriction to Property
Sorting Retrieved Records
Setting the Number of Retrieved Records
Loading Retrieved Records

Using Transactions
Using ORM Implementation

Inserting an ORM Implementation Class
Code Sample

Running the Sample Code

Creating Database Table
Inserting Record
Retrieving and Updating Record

Retrieving Record by ORM Qualifier
Retrieving Record by Criteria Class

Deleting Record
Retrieving a Number of Records

Retrieving a Number of Records by ORM Qualifier
Retrieving a Number of Records by Criteria

Dropping Database Table

Running the Script File

Using Entity Bean

Creating an Entity Bean
Loading an Entity Bean

Using Finder Method

Updating an Entity Bean
Deleting an Entity Bean Instance
Manipulating Association

One-to-One Association
One-to-Many Association
Many-to-Many Association

Creating a Message Driven Bean
Creating a Session Bean
Transactions

Using Container-Managed Transaction

Configuring Transaction Attribute

Using Bean-Managed Transaction

Chapter 19 - Manipulating Persistent Data with .NET

Introduction
Using ORM-Persistable .NET Class

Model API

Manipulating Attributes
Manipulating Association

Smart Association Handling

One-to-One Association
One-to-Many Association
Many-to-Many Association
Using Collection

Standard Association Handling

One-to-One Association
One-to-Many Association
Many-to-Many Association
Using Collection

Persistent API

Using Static Method

Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying

Loading a Collection of Persistent Objects
Using ORM Qualifier
Using Criteria Class

Using Factory Class

Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying

Loading a Collection of Persistent Objects
Using ORM Qualifier
Using Criteria Class

Using POJO

Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying

Loading a Collection of Persistent Objects

Using DAO

Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying

Loading a Collection of Persistent Objects
Using ORM Qualifier
Using Criteria Class

Using Criteria Class

Applying Restriction to Property
Sorting Retrieved Records
Setting the Number of Retrieved Records
Loading Retrieved Records

Using Transactions
Using ORM Implementation

Inserting an ORM Implementation Class
Code Sample

Running the Sample Code

Creating Database Table
Inserting Record
Retrieving and Updating Record

Retrieving Record by ORM Qualifier
Retrieving Record by Criteria Class

Deleting Record
Retrieving a Number of Records

Retrieving a Number of Records by ORM Qualifier
Retrieving a Number of Records by Criteria

Dropping Database Table

Applying .NET Persistence Class to different .NET Language

Appendix E - JDBC and .NET Drivers

JDBC Drivers
.NET Drivers

Appendix F - Glossary

Glossary