Chapter 6 Creating J2EE Applications for BEA WebLogic

Defining O/R Mappings

When you generate an OOM from a PDM or a PDM from an OOM, the default O/R mapping can be generated and saved in the OOM. You can also manually define complex O/R mappings. The following screenshot shows the Attribute Mapping of the Customer class, generated from the PDM.

For O/R mappings, PowerDesigner supports:

• Mapping a class to one or several tables or views
• Mapping an attribute to a column or an expression
• Select, insert, update and delete queries for a class
• Query for an operation
• Mapping an association to a table or reference
• Select, insert and delete queries for an association
• Stored-procedures

The SQL queries and stored-procedure syntaxes may vary for each application server.

Copyright (C) 2006. Sybase Inc. All rights reserved.