Package org.hibernate.id.enhanced
Class TableGenerator
- java.lang.Object
-
- org.hibernate.id.enhanced.TableGenerator
-
- All Implemented Interfaces:
ExportableProducer,Configurable,IdentifierGenerator,PersistentIdentifierGenerator
public class TableGenerator extends java.lang.Object implements PersistentIdentifierGenerator
An enhanced version of table-based id generation. Unlike the simplistic legacy one (which, btw, was only ever intended for subclassing support) we "segment" the table into multiple values. Thus a single table can actually serve as the persistent storage for multiple independent generators. One approach would be to segment the values by the name of the entity for which we are performing generation, which would mean that we would have a row in the generator table for each entity name. Or any configuration really; the setup is very flexible. In this respect it is very similar to the legacyMultipleHiLoPerTableGeneratorin terms of the underlying storage structure (namely a single table capable of holding multiple generator values). The differentiator is, as withSequenceStyleGeneratoras well, the externalized notion of an optimizer. NOTE that by default we use a single row for all generators (based onDEF_SEGMENT_VALUE). The configuration parameterCONFIG_PREFER_SEGMENT_PER_ENTITYcan be used to change that to instead default to using a row for each entity name. Configuration parameters:NAME DEFAULT DESCRIPTION TABLE_PARAMDEF_TABLEThe name of the table to use to store/retrieve values VALUE_COLUMN_PARAMDEF_VALUE_COLUMNThe name of column which holds the sequence value for the given segment SEGMENT_COLUMN_PARAMDEF_SEGMENT_COLUMNThe name of the column which holds the segment key SEGMENT_VALUE_PARAMDEF_SEGMENT_VALUEThe value indicating which segment is used by this generator; refers to values in the SEGMENT_COLUMN_PARAMcolumnSEGMENT_LENGTH_PARAMDEF_SEGMENT_LENGTHThe data length of the SEGMENT_COLUMN_PARAMcolumn; used for schema creationINITIAL_PARAMDEFAULT_INITIAL_VALUEThe initial value to be stored for the given segment INCREMENT_PARAMDEFAULT_INCREMENT_SIZEThe increment size for the underlying segment; see the discussion on Optimizerfor more details.OPT_PARAMdepends on defined increment size Allows explicit definition of which optimization strategy to use
-
-
Field Summary
Fields Modifier and Type Field Description static java.lang.StringCONFIG_PREFER_SEGMENT_PER_ENTITYBy default (in the absence of aSEGMENT_VALUE_PARAMsetting) we use a single row for all generators.static java.lang.StringDEF_SEGMENT_COLUMNThe defaultSEGMENT_COLUMN_PARAMvaluestatic intDEF_SEGMENT_LENGTHThe defaultSEGMENT_LENGTH_PARAMvaluestatic java.lang.StringDEF_SEGMENT_VALUEThe defaultSEGMENT_VALUE_PARAMvalue, unlessCONFIG_PREFER_SEGMENT_PER_ENTITYis specifiedstatic java.lang.StringDEF_TABLEThe defaultTABLE_PARAMvaluestatic java.lang.StringDEF_VALUE_COLUMNThe defaultVALUE_COLUMN_PARAMvaluestatic intDEFAULT_INCREMENT_SIZEThe defaultINCREMENT_PARAMvaluestatic intDEFAULT_INITIAL_VALUEThe defaultINITIAL_PARAMvaluestatic java.lang.StringINCREMENT_PARAMIndicates the increment size to use.static java.lang.StringINITIAL_PARAMIndicates the initial value to use.static java.lang.StringOPT_PARAMIndicates the optimizer to use, either naming aOptimizerimplementation class or by naming aStandardOptimizerDescriptorby namestatic java.lang.StringSEGMENT_COLUMN_PARAMThe name of the column which holds the segment key.static java.lang.StringSEGMENT_LENGTH_PARAMIndicates the length of the column defined bySEGMENT_COLUMN_PARAM.static java.lang.StringSEGMENT_VALUE_PARAMThe value indicating which segment is used by this generator, as indicated by the actual value stored in the column indicated bySEGMENT_COLUMN_PARAM.static java.lang.StringTABLE_PARAMConfigures the name of the table to use.static java.lang.StringVALUE_COLUMN_PARAMThe name of column which holds the sequence value.-
Fields inherited from interface org.hibernate.id.IdentifierGenerator
ENTITY_NAME, GENERATOR_NAME, JPA_ENTITY_NAME
-
Fields inherited from interface org.hibernate.id.PersistentIdentifierGenerator
CATALOG, IDENTIFIER_NORMALIZER, PK, SCHEMA, TABLE, TABLES
-
-
Constructor Summary
Constructors Constructor Description TableGenerator()
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description protected java.lang.StringbuildInsertQuery(java.lang.String formattedPhysicalTableName, SqlStringGenerationContext context)protected java.lang.StringbuildSelectQuery(java.lang.String formattedPhysicalTableName, SqlStringGenerationContext context)protected java.lang.StringbuildUpdateQuery(java.lang.String formattedPhysicalTableName, SqlStringGenerationContext context)voidconfigure(Type type, java.util.Properties params, ServiceRegistry serviceRegistry)Configure this instance, given the value of parameters specified by the user as <param> elements.protected java.lang.StringdetermineDefaultSegmentValue(java.util.Properties params)Used in the cases wheredetermineSegmentValue(java.util.Properties)is unable to determine the value to use.protected QualifiedNamedetermineGeneratorTableName(java.util.Properties params, JdbcEnvironment jdbcEnvironment, ServiceRegistry serviceRegistry)Determine the table name to use for the generator values.protected intdetermineIncrementSize(java.util.Properties params)protected intdetermineInitialValue(java.util.Properties params)protected java.lang.StringdetermineSegmentColumnName(java.util.Properties params, JdbcEnvironment jdbcEnvironment)Determine the name of the column used to indicate the segment for each row.protected intdetermineSegmentColumnSize(java.util.Properties params)Determine the size of thesegment columnprotected java.lang.StringdetermineSegmentValue(java.util.Properties params)Determine the segment value corresponding to this generator instance.protected java.lang.StringdetermineValueColumnName(java.util.Properties params, JdbcEnvironment jdbcEnvironment)Determine the name of the column in which we will store the generator persistent value.java.io.Serializablegenerate(SharedSessionContractImplementor session, java.lang.Object obj)Generate a new identifier.protected InitCommandgenerateInsertInitCommand(SqlStringGenerationContext context)java.lang.ObjectgeneratorKey()Deprecated.java.lang.String[]getAllSqlForTests()Deprecated.Exposed for tests only.TypegetIdentifierType()Type mapping for the identifier.intgetIncrementSize()The amount of increment to use.intgetInitialValue()The initial value to use when we find no previous state in the generator table corresponding to our sequence.OptimizergetOptimizer()The optimizer being used by this generator.java.lang.StringgetSegmentColumnName()The name of the column in which we store the segment to which each row belongs.java.lang.StringgetSegmentValue()The value insegment columncorresponding to this generator instance.intgetSegmentValueLength()The size of thesegment columnin the underlying table.longgetTableAccessCount()Getter for property 'tableAccessCount'.java.lang.StringgetTableName()The name of the table in which we store this generator's persistent state.java.lang.StringgetValueColumnName()The name of the column in which we store our persistent generator value.voidinitialize(SqlStringGenerationContext context)Initializes this instance, in particular pre-generates SQL as necessary.voidregisterExportables(Database database)Register database objects used by this identifier generator, e.g.-
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface org.hibernate.id.IdentifierGenerator
supportsJdbcBatchInserts
-
-
-
-
Field Detail
-
CONFIG_PREFER_SEGMENT_PER_ENTITY
public static final java.lang.String CONFIG_PREFER_SEGMENT_PER_ENTITY
By default (in the absence of aSEGMENT_VALUE_PARAMsetting) we use a single row for all generators. This setting can be used to change that to instead default to using a row for each entity name.- See Also:
- Constant Field Values
-
TABLE_PARAM
public static final java.lang.String TABLE_PARAM
Configures the name of the table to use. The default value isDEF_TABLE- See Also:
- Constant Field Values
-
DEF_TABLE
public static final java.lang.String DEF_TABLE
The defaultTABLE_PARAMvalue- See Also:
- Constant Field Values
-
VALUE_COLUMN_PARAM
public static final java.lang.String VALUE_COLUMN_PARAM
The name of column which holds the sequence value. The default value isDEF_VALUE_COLUMN- See Also:
- Constant Field Values
-
DEF_VALUE_COLUMN
public static final java.lang.String DEF_VALUE_COLUMN
The defaultVALUE_COLUMN_PARAMvalue- See Also:
- Constant Field Values
-
SEGMENT_COLUMN_PARAM
public static final java.lang.String SEGMENT_COLUMN_PARAM
The name of the column which holds the segment key. The segment defines the different buckets (segments) of values currently tracked in the table. The default value isDEF_SEGMENT_COLUMN- See Also:
- Constant Field Values
-
DEF_SEGMENT_COLUMN
public static final java.lang.String DEF_SEGMENT_COLUMN
The defaultSEGMENT_COLUMN_PARAMvalue- See Also:
- Constant Field Values
-
SEGMENT_VALUE_PARAM
public static final java.lang.String SEGMENT_VALUE_PARAM
The value indicating which segment is used by this generator, as indicated by the actual value stored in the column indicated bySEGMENT_COLUMN_PARAM. The default value for setting isDEF_SEGMENT_VALUE, althoughCONFIG_PREFER_SEGMENT_PER_ENTITYeffects the default as well.- See Also:
- Constant Field Values
-
DEF_SEGMENT_VALUE
public static final java.lang.String DEF_SEGMENT_VALUE
The defaultSEGMENT_VALUE_PARAMvalue, unlessCONFIG_PREFER_SEGMENT_PER_ENTITYis specified- See Also:
- Constant Field Values
-
SEGMENT_LENGTH_PARAM
public static final java.lang.String SEGMENT_LENGTH_PARAM
Indicates the length of the column defined bySEGMENT_COLUMN_PARAM. Used in schema export. The default value isDEF_SEGMENT_LENGTH- See Also:
- Constant Field Values
-
DEF_SEGMENT_LENGTH
public static final int DEF_SEGMENT_LENGTH
The defaultSEGMENT_LENGTH_PARAMvalue- See Also:
- Constant Field Values
-
INITIAL_PARAM
public static final java.lang.String INITIAL_PARAM
Indicates the initial value to use. The default value isDEFAULT_INITIAL_VALUE- See Also:
- Constant Field Values
-
DEFAULT_INITIAL_VALUE
public static final int DEFAULT_INITIAL_VALUE
The defaultINITIAL_PARAMvalue- See Also:
- Constant Field Values
-
INCREMENT_PARAM
public static final java.lang.String INCREMENT_PARAM
Indicates the increment size to use. The default value isDEFAULT_INCREMENT_SIZE- See Also:
- Constant Field Values
-
DEFAULT_INCREMENT_SIZE
public static final int DEFAULT_INCREMENT_SIZE
The defaultINCREMENT_PARAMvalue- See Also:
- Constant Field Values
-
OPT_PARAM
public static final java.lang.String OPT_PARAM
Indicates the optimizer to use, either naming aOptimizerimplementation class or by naming aStandardOptimizerDescriptorby name- See Also:
- Constant Field Values
-
-
Method Detail
-
generatorKey
@Deprecated public java.lang.Object generatorKey()
Deprecated.Description copied from interface:PersistentIdentifierGeneratorReturn a key unique to the underlying database objects. Prevents us from trying to create/remove them multiple times.- Specified by:
generatorKeyin interfacePersistentIdentifierGenerator- Returns:
- Object an identifying key for this generator
-
getIdentifierType
public final Type getIdentifierType()
Type mapping for the identifier.- Returns:
- The identifier type mapping.
-
getTableName
public final java.lang.String getTableName()
The name of the table in which we store this generator's persistent state.- Returns:
- The table name.
-
getSegmentColumnName
public final java.lang.String getSegmentColumnName()
The name of the column in which we store the segment to which each row belongs. The value here acts as PK.- Returns:
- The segment column name
-
getSegmentValue
public final java.lang.String getSegmentValue()
The value insegment columncorresponding to this generator instance. In other words this value indicates the row in which this generator instance will store values.- Returns:
- The segment value for this generator instance.
-
getSegmentValueLength
public final int getSegmentValueLength()
The size of thesegment columnin the underlying table. NOTE : should really have been called 'segmentColumnLength' or even better 'segmentColumnSize'- Returns:
- the column size.
-
getValueColumnName
public final java.lang.String getValueColumnName()
The name of the column in which we store our persistent generator value.- Returns:
- The name of the value column.
-
getInitialValue
public final int getInitialValue()
The initial value to use when we find no previous state in the generator table corresponding to our sequence.- Returns:
- The initial value to use.
-
getIncrementSize
public final int getIncrementSize()
The amount of increment to use. The exact implications of this depends on theoptimizerbeing used.- Returns:
- The increment amount.
-
getOptimizer
public final Optimizer getOptimizer()
The optimizer being used by this generator.- Returns:
- Out optimizer.
-
getTableAccessCount
public final long getTableAccessCount()
Getter for property 'tableAccessCount'. Only really useful for unit test assertions.- Returns:
- Value for property 'tableAccessCount'.
-
getAllSqlForTests
@Deprecated public java.lang.String[] getAllSqlForTests()
Deprecated.Exposed for tests only.
-
configure
public void configure(Type type, java.util.Properties params, ServiceRegistry serviceRegistry) throws MappingException
Description copied from interface:IdentifierGeneratorConfigure this instance, given the value of parameters specified by the user as <param> elements.This method is called just once, following instantiation, and before
IdentifierGenerator.registerExportables(Database).- Specified by:
configurein interfaceConfigurable- Specified by:
configurein interfaceIdentifierGenerator- Parameters:
type- The id property type descriptorparams- param values, keyed by parameter nameserviceRegistry- Access to service that may be needed.- Throws:
MappingException- If configuration fails.
-
determineGeneratorTableName
protected QualifiedName determineGeneratorTableName(java.util.Properties params, JdbcEnvironment jdbcEnvironment, ServiceRegistry serviceRegistry)
Determine the table name to use for the generator values. Called duringconfiguration.- Parameters:
params- The params supplied in the generator config (plus some standard useful extras).jdbcEnvironment- The JDBC environment- Returns:
- The table name to use.
- See Also:
getTableName()
-
determineSegmentColumnName
protected java.lang.String determineSegmentColumnName(java.util.Properties params, JdbcEnvironment jdbcEnvironment)Determine the name of the column used to indicate the segment for each row. This column acts as the primary key. Called duringconfiguration.- Parameters:
params- The params supplied in the generator config (plus some standard useful extras).jdbcEnvironment- The JDBC environment- Returns:
- The name of the segment column
- See Also:
getSegmentColumnName()
-
determineValueColumnName
protected java.lang.String determineValueColumnName(java.util.Properties params, JdbcEnvironment jdbcEnvironment)Determine the name of the column in which we will store the generator persistent value. Called duringconfiguration.- Parameters:
params- The params supplied in the generator config (plus some standard useful extras).jdbcEnvironment- The JDBC environment- Returns:
- The name of the value column
- See Also:
getValueColumnName()
-
determineSegmentValue
protected java.lang.String determineSegmentValue(java.util.Properties params)
Determine the segment value corresponding to this generator instance. Called duringconfiguration.- Parameters:
params- The params supplied in the generator config (plus some standard useful extras).- Returns:
- The name of the value column
- See Also:
getSegmentValue()
-
determineDefaultSegmentValue
protected java.lang.String determineDefaultSegmentValue(java.util.Properties params)
Used in the cases wheredetermineSegmentValue(java.util.Properties)is unable to determine the value to use.- Parameters:
params- The params supplied in the generator config (plus some standard useful extras).- Returns:
- The default segment value to use.
-
determineSegmentColumnSize
protected int determineSegmentColumnSize(java.util.Properties params)
Determine the size of thesegment columnCalled duringconfiguration.- Parameters:
params- The params supplied in the generator config (plus some standard useful extras).- Returns:
- The size of the segment column
- See Also:
getSegmentValueLength()
-
determineInitialValue
protected int determineInitialValue(java.util.Properties params)
-
determineIncrementSize
protected int determineIncrementSize(java.util.Properties params)
-
buildSelectQuery
protected java.lang.String buildSelectQuery(java.lang.String formattedPhysicalTableName, SqlStringGenerationContext context)
-
buildUpdateQuery
protected java.lang.String buildUpdateQuery(java.lang.String formattedPhysicalTableName, SqlStringGenerationContext context)
-
buildInsertQuery
protected java.lang.String buildInsertQuery(java.lang.String formattedPhysicalTableName, SqlStringGenerationContext context)
-
generateInsertInitCommand
protected InitCommand generateInsertInitCommand(SqlStringGenerationContext context)
-
generate
public java.io.Serializable generate(SharedSessionContractImplementor session, java.lang.Object obj)
Description copied from interface:IdentifierGeneratorGenerate a new identifier.- Specified by:
generatein interfaceIdentifierGenerator- Parameters:
session- The session from which the request originatesobj- the entity or collection (idbag) for which the id is being generated- Returns:
- a new identifier
-
registerExportables
public void registerExportables(Database database)
Description copied from interface:IdentifierGeneratorRegister database objects used by this identifier generator, e.g. sequences, tables, etc.This method is called just once, after
IdentifierGenerator.configure(Type, Properties, ServiceRegistry).- Specified by:
registerExportablesin interfaceExportableProducer- Specified by:
registerExportablesin interfaceIdentifierGenerator- Parameters:
database- The database instance
-
initialize
public void initialize(SqlStringGenerationContext context)
Description copied from interface:IdentifierGeneratorInitializes this instance, in particular pre-generates SQL as necessary.This method is called after
IdentifierGenerator.registerExportables(Database), before first use.- Specified by:
initializein interfaceIdentifierGenerator- Parameters:
context- A context to help generate SQL strings
-
-