Smart Development Environment 4.0 User's Guide

Part 2 Cover

Smart Development Environment 4.0 User's Guide:
SDE 4.0 User's Guide (for ORM)

The software and documentation are furnished under the Smart Development Environment license agreement and may be used only in accordance with the terms of the agreement.

Copyright Information
Copyright© 1999-2007 by Visual Paradigm. All rights reserved.

The material made available by Visual Paradigm in this document is protected under the laws and various international laws and treaties. No portion of this document or the material contained on it may be reproduced in any form or by any means without prior written permission from Visual Paradigm.

Every effort has been made to ensure the accuracy of this document. However, Visual Paradigm makes no warranties with respect to this documentation and disclaims any implied warranties of merchantability and fitness for a particular purpose. The information in this document is subject to change without notice.

All examples with names, company names, or companies that appear in this document are imaginary and do not refer to, or portray, in name or substance, any actual names, companies, entities, or institutions. Any resemblance to any real person, company, entity, or institution is purely coincidental.

Trademark Information

Smart Development Environment is registered trademark of Visual Paradigm.
Sun, Sun ONE, Java, Java2, J2EE and EJB, NetBeans are all registered trademarks of Sun Microsystems, Inc.
Eclipse is registered trademark of Eclipse.
JBuilder is registered trademark of Borland Corporation.
IntelliJ and IntelliJ IDEA are registered trademarks of JetBrains.
Microsoft, Windows, Windows NT, Visio, and the Windows logo are trademarks or registered trademarks of Microsoft Corporation.
Oracle is a registered trademark, and JDeveloper is a trademark or registered trademark of Oracle Corporation.
BEA is registered trademarks of BEA Systems, Inc.
BEA WebLogic Workshop is trademark of BEA Systems, Inc.
Rational Rose is registered trademark of International Business Machines Corporation.
WinZip is a registered trademark of WinZip Computing, Inc.
Other trademarks or service marks referenced herein are property of their respective owners.

Smart Development Environment License Agreement

THE USE OF THE SOFTWARE LICENSED TO YOU IS SUBJECT TO THE TERMS AND CONDITIONS OF THIS SOFTWARE LICENSE AGREEMENT. BY INSTALLING, COPYING, OR OTHERWISE USING THE SOFTWARE, YOU ACKNOWLEDGE THAT YOU HAVE READ THIS AGREEMENT, UNDERSTAND IT, AND AGREE TO BE BOUNDED BY ALL OF THE TERMS AND CONDITIONS OF THIS SOFTWARE LICENSE AGREEMENT.

Limited License Grant. Visual Paradigm grants to you ("the Licensee") a personal, non-exclusive, non-transferable, limited, perpetual, revocable license to install and use Visual Paradigm Products ("the Software" or "the Product"). The Licensee must not re-distribute the Software in whole or in part, either separately or included with a product.
Restrictions. The Software is confidential copyrighted information of Visual Paradigm, and Visual Paradigm and/or its licensors retain title to all copies. The Licensee shall not modify, adapt, decompile, disassemble, decrypt, extract, or otherwise reverse engineer the Software. Software may not be leased, rented, transferred, distributed, assigned, or sublicensed, in whole or in part. The Software contains valuable trade secrets. The Licensee promises not to extract any information or concepts from it as part of an effort to compete with the licensor, nor to assist anyone else in such an effort. The Licensee agrees not to remove, modify, delete or destroy any proprietary right notices of Visual Paradigm and its licensors, including copyright notices, in the Software.
Disclaimer of Warranty. The software and documentation are provided "AS IS," WITH NO WARRANTIES WHATSOEVER. ALL EXPRESS OR IMPLIED REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE OR NON-INFRINGEMENT, ARE HEREBY EXCLUDED. THE ENTIRE RISK AS TO SATISFACTORY QUALITY, PERFORMANCE, ACCURACY AND EFFORT IS WITH THE LICENSEE. THERE IS NO WARRANTY THE DOCUMENTATION, Visual Paradigm's EFFORTS OR THE LICENSED SOFTWARE WILL FULFILL ANY OF LICENSEE'S PARTICULAR PURPOSES OR NEEDS. IF THESE WARRANTIES ARE UNENFORCEABLE UNDER APPLICABLE LAW, THEN Visual Paradigm DISCLAIMS SUCH WARRANTIES TO THE MAXIMUM EXTENT PERMITTED BY SUCH APPLICABLE LAW.
Limitation of Liability. Visual Paradigm AND ITS LICENSORS SHALL NOT BE LIABLE FOR ANY DAMAGES SUFFERED BY THE LICENSEE OR ANY THIRD PARTY AS A RESULT OF USING OR DISTRIBUTING SOFTWARE. IN NO EVENT WILL Visual Paradigm OR ITS LICENSORS BE LIABLE FOR ANY LOST REVENUE, PROFIT OR DATA, OR FOR DIRECT, INDIRECT, EXEMPLARY, SPECIAL, CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES, HOWEVER CAUSED AND REGARDLESS OF THE THEORY OF LIABILITY, ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE, EVEN IF Visual Paradigm HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
Termination. The Licensee may terminate this License at any time by destroying all copies of Software. Visual Paradigm will not be obligated to refund any License Fees, if any, paid by the Licensee for such termination. This License will terminate immediately without notice from Visual Paradigm if the Licensee fails to comply with any provision of this License. Upon such termination, the Licensee must destroy all copies of the Software. Visual Paradigm reserves all rights to terminate this License.

SPECIFIC DISCLAIMER FOR HIGH-RISK ACTIVITIES. The SOFTWARE is not designed or intended for use in high-risk activities including, without restricting the generality of the foregoing, on-line control of aircraft, air traffic, aircraft navigation or aircraft communications; or in the design, construction, operation or maintenance of any nuclear facility. Visual Paradigm disclaims any express or implied warranty of fitness for such purposes or any other purposes.

NOTICE. The Product is not intended for personal, family or household use; rather, it is intended exclusively for professional use. Its utilization requires skills that differ from those needed to use consumer software products such as word processing or spreadsheet software.

Acknowledgements

Table of Contents

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
Database Configuration for .NET Project
Specifying JDBC Driver File, .NET Driver File and Adapter File
Supported Database, JDBC Drivers and .NET Drivers
Supporting Multiple Database

Chapter 13 - Using ORM Wizard

Introduction
Generating Code from Database
Generating Code and Database from ERD
Generating Code and Database from Class Diagram

Chapter 14 - Object Model

Introduction
Object Models
Creating a Class Diagram
Defining Package for Classes
Specifying Inheritance Strategy
Specifying Collection Type
Defining ORM Qualifier
Customizing SQL
Mapping an Object Model to a Data Model
Showing Mapping between Object and Data Models by ORM Diagram
Using ORM Pane
Reverse Engineering Java Classes to Object Model
Reverse Engineering Hibernate Model to Object Model
Enterprise JavaBeans Modeling
Creating an EJB Diagram
Defining Primary Key
Creating a Creator Method
Creating a Finder Method
Mapping an Enterprise JavaBeans Model to a Data Model

Chapter 15 - Data Model

Introduction
Entity Relationship Diagram
Creating an Entity Relationship Diagram
Specifying Index Column
Using the ID Generator
Defining Discriminator
Creating an Array Table
Creating a Partial Table
Copying SQL statements from Tables
Mapping a Data Model to an Object Model
Mapping a Data Model to an Enterprise JavaBeans Model

Chapter 16 - Database Schema

Introduction
Generating Data Definition Language and Database
Generating Database from Data Model
Generating Database from Object Model
Mapping Data Model to Data Definition Language

Chapter 17 - Implementation

Introduction
ORM-Persistable Class
Generating ORM-Persistable Class from Data Model
Generating ORM-Persistable Class from Object Model
Generating ORM-Persistable Class from Database
Mapping Object Model to ORM-Persistable Java Class
Mapping Classes, Attributes and Data Type
Mapping Primary Key
Mapping Generalization
Mapping Association and Multiplicity
Mapping Object Model to ORM-Persistable .NET Class
Mapping Classes, Attributes and Data Type
Mapping Primary Key
Mapping Generalization
Mapping Association and Multiplicity
Enterprise JavaBean (EJB)
Generating Enterprise JavaBeans from Enterprise JavaBean Model
Mapping Enterprise JavaBean Model to Enterprise JavaBean
Mapping Entity Bean
Mapping Primary Key
Mapping Association and Multiplicity
Mapping Message-Driven Bean
Mapping Session Bean
Deploying Enterprise JavaBean on Application Servers
Configuring Application Servers
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
Persistent API
Running the Sample Code
Running the Script File
Using Entity Bean
Creating an Entity Bean
Loading an Entity Bean
Updating an Entity Bean
Deleting an Entity Bean Instance
Manipulating Association
Creating a Message Driven Bean
Creating a Session Bean
Transactions

Chapter 19 - Manipulating Persistent Data with .NET

Introduction
Using ORM-Persistable .NET Class
Model API
Persistent API
Running the Sample Code
Applying .NET Persistence Code to different .NET Language

Appendix D - JDBC and .NET Drivers

Appendix E - Glossary

Visual Paradigm International Limited
Website:	www.visual-paradigm.com
E-mail:	support@visual-paradigm.com