Skip to main content

Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Texo/ORM JPA Annotations Details

< Texo
Revision as of 17:46, 17 May 2010 by Mtaal.springsite.com (Talk | contribs) (Adding Id/Version features to your model)

Introduction

The Texo ORM generation can be controlled completely through an annotations model. The Texo ORM annotation model is directly based on the [2.0 standard]. The ORM/JPA model annotations make it possible to override/set all ORM 2.0 annotations at model level. You only need to annotate the parts of the model which need extra attention. Texo will automatically add any missing annotations to get to a fully annotated model (while maintaining the manual settings).

Maintaining ORM model annotations

The initial ORM annotations model can be created in the same way as described for code generation, see here. You start with an empty annotation model and create the nodes in the annotations model to add ORM annotations.


Org.eclipse.emf.texo.orm.annotations.model.png


You can add ORM Annotations at each level of your model: EPackage, EClass, EAttribute, EReference and EDataType. By right clicking on an ORM Annotation node you can see which ORM specific annotations can be added:


Org.eclipse.emf.texo.adding.orm.annotation.png


And ORM specific annotations can again have children:


Org.eclipse.emf.texo.adding.orm.annotation2.png


Note: it is possible to specify ORM annotations on an EDataType, these annotations are copied to each EAttribute using that EDataType.

Texo Mapping Decisions

Texo makes the following mapping decisions when generating an orm.xml:

  • as a default all access is set at FIELD (this in contrast to the JPA default which is PROPERTY), only interfaces will use the PROPERTY access type.
  • join tables are named as: entityname_efeaturename. This in contrast to the JPA default which specifies that a join table should be the concatenation of the names of the 2 tables which are joined. Texo uses a different approach as it provides a more robust naming without collisions.
  • Texo will automatically manage which side is the owner in a bi-directional association.
  • Texo chooses the entity name (is the same as the EClass name).

Adding Id/Version features to your model

ORM solutions like EclipseLink require that each type has a primary key and preferably a version property. It can be cumbersome to add this to all the types in your system. An easy approach is therefore to:

  • create a super type (for example called Identifiable) which has an id and version EFeature
  • create an annotation model with a number of ORM annotations:
    • map the Identifiable as a so-called MappedSuperclass. This means that the Identifiable type won't have its own table, its efeatures are mapped in the sub type.
    • add an Id and Version ORM annotation for the id and version EFeature.
  • let all types inherit from this super type (or set the property rootExtendsClass to the class name of Identifiable).

An example of a model with an Identifiable and its annotation model can be downloaded here: File:Org.eclipse.emf.texo.identifiable.zip

Future extensions

For the near future the following topics/improvements will be made:

  • Support the Map type
  • Generate more database schema constructs in the orm.xml (column names for example).
  • Make the database artifact/entity naming logic configurable

Back to the top