EclipseLink 2.2.0, build 'v20110202-r8913' API Reference

org.eclipse.persistence.tools.schemaframework
Class DefaultTableGenerator

java.lang.Object
  extended by org.eclipse.persistence.tools.schemaframework.DefaultTableGenerator

public class DefaultTableGenerator
extends java.lang.Object

DefaultTableGenerator is a utility class used to generate a default table schema for a EclipseLink project object. The utility can be used in EclipseLink CMP for OC4J to perform the table auto creation process, which can be triggered at deployment time when EclipseLink project descriptor is absent (default mapping) or present. The utility can also be used to any EclipseLink application to perform the table drop/creation at runtime. The utility handles all direct/relational mappings, inheritance, multiple tables, interface with/without tables, optimistic version/timestamp lockings, nested relationships, BLOB/CLOB generation. The utility is platform-agnostic. Usage: - CMP 1. set "autocreate-tables=true|false, autodelete-tables=true|false" in oc4j application deployment descriptor files (config/system-application.xml, config/application.xml, or orion-application.xml in an .ear) 2. Default Mapping: the same as CMP, plus system properties setting -Declipselink.defaultmapping.autocreate-tables='true|false' and -Declipselink.defaultmapping.autodelete-tables='true|false' - Non-CMP: 1. Configuration: through sessions.xml 2. Directly runtime call through schema framework: SchemaManager mgr = new SchemaManager(session); mgr.replaceDefaultTables(); //drop and create mgr.createDefaultTables(); //create only The utility currently only supports relational project.

Author:
King Wang
Since:
Oracle TopLink 10.1.3

Field Summary
protected  java.util.Map<org.eclipse.persistence.internal.helper.DatabaseField,org.eclipse.persistence.internal.helper.DatabaseField> databaseFields
          DatabaseField pool (synchronized with above 'fieldMap')
protected  org.eclipse.persistence.internal.databaseaccess.DatabasePlatform databasePlatform
          the target database platform.
protected  java.util.Map<org.eclipse.persistence.internal.helper.DatabaseField,FieldDefinition> fieldMap
          Used to track the field definition: keyed by the database field object, and valued by the field definition.
protected  boolean generateFKConstraints
          When this flag is 'false' EclipseLink will not attempt to create fk constraints.
protected  java.util.Map<java.lang.String,TableDefinition> tableMap
          Used to track the table definition: keyed by the table name, and valued by the table definition object.
 
Constructor Summary
DefaultTableGenerator(Project project)
          Default constructor
DefaultTableGenerator(Project project, boolean generateFKConstraints)
          This constructor will create a DefaultTableGenerator that can be set to create fk constraints
 
Method Summary
protected  void addFieldsForMappedKeyMapContainerPolicy(org.eclipse.persistence.internal.queries.ContainerPolicy cp, TableDefinition table)
          The ContainerPolicy may contain some additional fields that should be added to the table
protected  void addForeignKeyConstraint(TableDefinition sourceTableDef, TableDefinition targetTableDef, java.util.List<java.lang.String> fkFields, java.util.List<java.lang.String> targetFields, boolean cascadeOnDelete)
          Add a foreign key constraint to the source table.
protected  void addForeignKeyFieldToSourceTargetTable(OneToManyMapping mapping)
           
protected  void addForeignKeyFieldToSourceTargetTable(OneToOneMapping mapping)
           
protected  void addForeignMappingFkConstraint(java.util.Map<org.eclipse.persistence.internal.helper.DatabaseField,org.eclipse.persistence.internal.helper.DatabaseField> srcFields, boolean cascadeOnDelete)
           
protected  void addJoinColumnsFkConstraint(java.util.List<org.eclipse.persistence.internal.helper.DatabaseField> fkFields, java.util.List<org.eclipse.persistence.internal.helper.DatabaseField> targetFields, boolean cascadeOnDelete)
           
protected  void addUniqueKeyConstraints(TableDefinition sourceTableDef, java.util.Map<java.lang.String,java.util.List<java.util.List<java.lang.String>>> uniqueConstraintsMap)
           
protected  void buildDirectCollectionTableDefinition(DirectCollectionMapping mapping, ClassDescriptor descriptor)
          Build direct collection table definitions in a EclipseLink descriptor
protected  void buildRelationTableDefinition(ForeignReferenceMapping mapping, RelationTableMechanism relationTableMechanism, org.eclipse.persistence.internal.helper.DatabaseField listOrderField, org.eclipse.persistence.internal.queries.ContainerPolicy cp)
          Build relation table definitions for all many-to-many relationships in a EclipseLink descriptor.
protected  void buildRelationTableFields(ForeignReferenceMapping mapping, TableDefinition table, java.util.List<org.eclipse.persistence.internal.helper.DatabaseField> fkFields, java.util.List<org.eclipse.persistence.internal.helper.DatabaseField> targetFields)
          Build field definitions and foreign key constraints for all many-to-many relation table.
protected  void createAggregateTargetTable(AggregateCollectionMapping mapping)
          Add the foreign key to the aggregate collection mapping target table.
 TableCreator generateDefaultTableCreator()
          Generate a default TableCreator object from the EclipseLink project object.
 TableCreator generateFilteredDefaultTableCreator(org.eclipse.persistence.internal.sessions.AbstractSession session)
          Generate a default TableCreator object from the EclipseLink project object, and perform the table existence check through jdbc table metadata, and filter out tables which are already in the database.
protected  FieldDefinition getFieldDefFromDBField(org.eclipse.persistence.internal.helper.DatabaseField dbField)
          Build a field definition object from a database field.
protected  TableDefinition getTableDefFromDBTable(org.eclipse.persistence.internal.helper.DatabaseTable databaseTable)
          Build a table definition object from a database table object
protected  void initTableSchema(ClassDescriptor descriptor)
          Build tables/fields information into the table creator object from a EclipseLink descriptor.
protected  void postInitTableSchema(ClassDescriptor descriptor)
          Build additional table/field definitions for the descriptor, like relation table and direct-collection, direct-map table, as well as reset LOB type for serialized object mapping and type conversion mapping for LOB usage
protected  void processAdditionalTablePkFields(ClassDescriptor descriptor)
           
protected  void resetFieldTypeForLOB(DirectToFieldMapping mapping)
          Reset field type to use BLOB/CLOB with type conversion mapping fix for 4k oracle thin driver bug.
protected  void resetTransformedFieldType(TransformationMapping mapping)
          Reset the transformation mapping field types
protected  org.eclipse.persistence.internal.helper.DatabaseField resolveDatabaseField(org.eclipse.persistence.internal.helper.DatabaseField childField, org.eclipse.persistence.internal.helper.DatabaseField parentField)
          Resolve the foreign key database field metadata in relation table or direct collection/map table.
protected  void setFieldToRelationTable(org.eclipse.persistence.internal.helper.DatabaseField dbField, TableDefinition table)
          Build and add a field definition object to relation table
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

databasePlatform

protected org.eclipse.persistence.internal.databaseaccess.DatabasePlatform databasePlatform
the target database platform.


tableMap

protected java.util.Map<java.lang.String,TableDefinition> tableMap
Used to track the table definition: keyed by the table name, and valued by the table definition object.


fieldMap

protected java.util.Map<org.eclipse.persistence.internal.helper.DatabaseField,FieldDefinition> fieldMap
Used to track the field definition: keyed by the database field object, and valued by the field definition.


databaseFields

protected java.util.Map<org.eclipse.persistence.internal.helper.DatabaseField,org.eclipse.persistence.internal.helper.DatabaseField> databaseFields
DatabaseField pool (synchronized with above 'fieldMap')


generateFKConstraints

protected boolean generateFKConstraints
When this flag is 'false' EclipseLink will not attempt to create fk constraints.

Constructor Detail

DefaultTableGenerator

public DefaultTableGenerator(Project project)
Default constructor


DefaultTableGenerator

public DefaultTableGenerator(Project project,
                             boolean generateFKConstraints)
This constructor will create a DefaultTableGenerator that can be set to create fk constraints

Method Detail

generateDefaultTableCreator

public TableCreator generateDefaultTableCreator()
Generate a default TableCreator object from the EclipseLink project object.


generateFilteredDefaultTableCreator

public TableCreator generateFilteredDefaultTableCreator(org.eclipse.persistence.internal.sessions.AbstractSession session)
                                                 throws DatabaseException
Generate a default TableCreator object from the EclipseLink project object, and perform the table existence check through jdbc table metadata, and filter out tables which are already in the database.

Throws:
DatabaseException

initTableSchema

protected void initTableSchema(ClassDescriptor descriptor)
Build tables/fields information into the table creator object from a EclipseLink descriptor. This should handle most of the direct/relational mappings except many-to-many and direct collection/map mappings, which must be down in postInit method.


postInitTableSchema

protected void postInitTableSchema(ClassDescriptor descriptor)
Build additional table/field definitions for the descriptor, like relation table and direct-collection, direct-map table, as well as reset LOB type for serialized object mapping and type conversion mapping for LOB usage


addFieldsForMappedKeyMapContainerPolicy

protected void addFieldsForMappedKeyMapContainerPolicy(org.eclipse.persistence.internal.queries.ContainerPolicy cp,
                                                       TableDefinition table)
The ContainerPolicy may contain some additional fields that should be added to the table

See Also:
MappedKeyMapContainerPolicy

buildRelationTableDefinition

protected void buildRelationTableDefinition(ForeignReferenceMapping mapping,
                                            RelationTableMechanism relationTableMechanism,
                                            org.eclipse.persistence.internal.helper.DatabaseField listOrderField,
                                            org.eclipse.persistence.internal.queries.ContainerPolicy cp)
Build relation table definitions for all many-to-many relationships in a EclipseLink descriptor.


buildRelationTableFields

protected void buildRelationTableFields(ForeignReferenceMapping mapping,
                                        TableDefinition table,
                                        java.util.List<org.eclipse.persistence.internal.helper.DatabaseField> fkFields,
                                        java.util.List<org.eclipse.persistence.internal.helper.DatabaseField> targetFields)
Build field definitions and foreign key constraints for all many-to-many relation table.


buildDirectCollectionTableDefinition

protected void buildDirectCollectionTableDefinition(DirectCollectionMapping mapping,
                                                    ClassDescriptor descriptor)
Build direct collection table definitions in a EclipseLink descriptor


resetFieldTypeForLOB

protected void resetFieldTypeForLOB(DirectToFieldMapping mapping)
Reset field type to use BLOB/CLOB with type conversion mapping fix for 4k oracle thin driver bug.


resetTransformedFieldType

protected void resetTransformedFieldType(TransformationMapping mapping)
Reset the transformation mapping field types


createAggregateTargetTable

protected void createAggregateTargetTable(AggregateCollectionMapping mapping)
Add the foreign key to the aggregate collection mapping target table. Also add listOrderField if specified.


addForeignKeyFieldToSourceTargetTable

protected void addForeignKeyFieldToSourceTargetTable(OneToOneMapping mapping)

addForeignKeyFieldToSourceTargetTable

protected void addForeignKeyFieldToSourceTargetTable(OneToManyMapping mapping)

addForeignMappingFkConstraint

protected void addForeignMappingFkConstraint(java.util.Map<org.eclipse.persistence.internal.helper.DatabaseField,org.eclipse.persistence.internal.helper.DatabaseField> srcFields,
                                             boolean cascadeOnDelete)

getTableDefFromDBTable

protected TableDefinition getTableDefFromDBTable(org.eclipse.persistence.internal.helper.DatabaseTable databaseTable)
Build a table definition object from a database table object


resolveDatabaseField

protected org.eclipse.persistence.internal.helper.DatabaseField resolveDatabaseField(org.eclipse.persistence.internal.helper.DatabaseField childField,
                                                                                     org.eclipse.persistence.internal.helper.DatabaseField parentField)
Resolve the foreign key database field metadata in relation table or direct collection/map table. Those metadata includes type, and maybe dbtype/size/subsize if DatabaseField carries those info.


getFieldDefFromDBField

protected FieldDefinition getFieldDefFromDBField(org.eclipse.persistence.internal.helper.DatabaseField dbField)
Build a field definition object from a database field.


setFieldToRelationTable

protected void setFieldToRelationTable(org.eclipse.persistence.internal.helper.DatabaseField dbField,
                                       TableDefinition table)
Build and add a field definition object to relation table


processAdditionalTablePkFields

protected void processAdditionalTablePkFields(ClassDescriptor descriptor)

addJoinColumnsFkConstraint

protected void addJoinColumnsFkConstraint(java.util.List<org.eclipse.persistence.internal.helper.DatabaseField> fkFields,
                                          java.util.List<org.eclipse.persistence.internal.helper.DatabaseField> targetFields,
                                          boolean cascadeOnDelete)

addForeignKeyConstraint

protected void addForeignKeyConstraint(TableDefinition sourceTableDef,
                                       TableDefinition targetTableDef,
                                       java.util.List<java.lang.String> fkFields,
                                       java.util.List<java.lang.String> targetFields,
                                       boolean cascadeOnDelete)
Add a foreign key constraint to the source table.


addUniqueKeyConstraints

protected void addUniqueKeyConstraints(TableDefinition sourceTableDef,
                                       java.util.Map<java.lang.String,java.util.List<java.util.List<java.lang.String>>> uniqueConstraintsMap)

EclipseLink 2.2.0, build 'v20110202-r8913' API Reference