Chapter 7 Creating J2EE Applications for IBM WebSphere 5.0

Defining O/R Mapping

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 mapping.

For O/R mapping, PowerDesigner supports:

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

The syntax of SQL queries and stored-procedures may vary depending on the application server. For WebSphere Application Server, PowerDesigner generates WebSphere Application Server specific SQL statements.

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