Documents the persistence framework.


Persistence is handled by the JPA framework with a default Hibernate implementation.

The mapping tool includes a JPA-enabled implementation of the Domain Model objects that use annotations to define the connections, cascading, and other relationships between the various objects.  For persistence interdependence, we have defined four categories of objects


Where there are connections between these worlds (say a MapRecord refers to a Concept) the reference is by identifier field rather than by direct connection.  In a sense, these are layers built on top of one another that do not require tight coupling.  The downside of this is that it introduces potential referential integrity problems.  The upside is that it allows flexible connections to exist and be resolved at a later time. 


Some principles:



The JPA configuration is in the standard config.properties file. 

PropertyDefault Value 
hibernate.dialectorg.hibernate.dialect.MySQLDialectThe default is MySQL though simply changing this should support other hibernate-supported environments.
javax.persistence.jdbc.drivercom.mysql.jdbc.DriverJDBC driver, this requires the MySQL connector to be in the classpath
javax.persistence.jdbc.urljdbc:mysql:// connection URL to a "mappingservicedb" database
javax.persistence.jdbc.usern/aMySQL user
javax.persistence.jdbc.passwordn/aMySQL user's password
hibernate.show_sqlfalseUseful debug setting, change to "true" to see all queries executed by JPA layer.
hibernate.format_sqltrueFormats SQL when showing queries
hibernate.use_sql_commentstrueAdd comments when showing SQL to explain what is happening.
hibernate.jdbc.batch_size500Batch size for bulk operations.
hibernate.jdbc.default_batch_fetch_size500Batch size for fetch operations.


Annotations Used

@ColumnDefine columns, column names, and specifications about size and nullability.
@ElementCollection, @CollectionTableUsed to define collections of non JPA objects (like a set of String).
@EntityUsed to define JPA-tracked objects.
@EnumeratedUsed to indicate fields that have enumerated values.
@id @GeneratedValueUsed to managed identifier fields and ID strategy.
@ManyToOne, @OneToOne, @OneToManyUsed to define object relationships between different @Entity annotated classes.
@MappedSuperclassUsed for abstract superclasses to indicate their fields should be included in persistence of concrete subclasses.
@TableUsed to indicate table names for objects. Default underscore-based naming convention is used.
@TemporalUsed for date fields.
@TransientUsed to avoid persistence of fields, these are typically used for DTO fields as we reuse the objects for data transfer.
@UniqueConstraintUsed to index columns that would otherwise not have indexes. Not actually used for uniqueness.