Introduction to Database and O/R Mapping Tools

Most of the Workshop Studio views (Workshop perspective) are shown in the following illustration. You can click the callouts to view specific topics. Note that the EJB3 Persistence Entities Editor is not shown.

Workshop Studio provides several views through which you can:

• Explore databases. Using the DbXplorer, you can connect Workshop Studio to databases you want to work with, then interact with these connections.
• View database diagrams. The DbXaminer provides a diagram view of the database schema.
• Execute queries. You can use the DbXaminer to try out query expressions with SQL, EJBQL, or HQL.
• Generate object relational mappings for EJB 3.0 or Hibernate. Whether you're using EJB3 persistence or Hibernate, you can generate persistence entities.
• Manage entity relationships. You can edit either EJB3 persistence and Hibernate entities with an Entities Editor.
• Configure the persistence provider. A configuration file editor eases editing of EJB3 configuration files or Hibernate configuration files.

Exploring Databases with the DbXplorer

Viewing Database Diagrams and Running Queries

Generating Hibernate Object Relational Mappings

Managing Hibernate Entity Relationships

Configuring Hibernate Properties

Generating JPA Mappings

Managing JPA Entity Relationships

Configuring JPA Properties