Annotation Interface TableGenerator


Defines a primary key generator that may be referenced by name when a generator element is specified for the GeneratedValue annotation. A table generator may be specified on the entity class or on the primary key field or property. The scope of the generator name is global to the persistence unit (across all generator types).
    Example 1:
    
    @Entity public class Employee {
        ...
        @TableGenerator(
            name="empGen", 
            table="ID_GEN", 
            pkColumnName="GEN_KEY", 
            valueColumnName="GEN_VALUE", 
            pkColumnValue="EMP_ID", 
            allocationSize=1)
        @Id
        @GeneratedValue(strategy=TABLE, generator="empGen")
        int id;
        ...
    }
    
    Example 2:
    
    @Entity public class Address {
        ...
        @TableGenerator(
            name="addressGen", 
            table="ID_GEN", 
            pkColumnName="GEN_KEY", 
            valueColumnName="GEN_VALUE", 
            pkColumnValue="ADDR_ID")
        @Id
        @GeneratedValue(strategy=TABLE, generator="addressGen")
        int id;
        ...
    }
 
Since:
Java Persistence 1.0
See Also:
  • Required Element Summary

    Required Elements
    Modifier and Type
    Required Element
    Description
    (Required) A unique generator name that can be referenced by one or more classes to be the generator for id values.
  • Optional Element Summary

    Optional Elements
    Modifier and Type
    Optional Element
    Description
    int
    (Optional) The amount to increment by when allocating id numbers from the generator.
    (Optional) The catalog of the table.
    (Optional) Indexes for the table.
    int
    (Optional) The initial value to be used to initialize the column that stores the last value generated.
    (Optional) Name of the primary key column in the table.
    (Optional) The primary key value in the generator table that distinguishes this set of generated values from others that may be stored in the table.
    (Optional) The schema of the table.
    (Optional) Name of table that stores the generated id values.
    (Optional) Unique constraints that are to be placed on the table.
    (Optional) Name of the column that stores the last value generated.
  • Element Details

    • name

      String name
      (Required) A unique generator name that can be referenced by one or more classes to be the generator for id values.
    • table

      String table
      (Optional) Name of table that stores the generated id values.

      Defaults to a name chosen by persistence provider.

      Default:
      ""
    • catalog

      String catalog
      (Optional) The catalog of the table.

      Defaults to the default catalog.

      Default:
      ""
    • schema

      String schema
      (Optional) The schema of the table.

      Defaults to the default schema for user.

      Default:
      ""
    • pkColumnName

      String pkColumnName
      (Optional) Name of the primary key column in the table.

      Defaults to a provider-chosen name.

      Default:
      ""
    • valueColumnName

      String valueColumnName
      (Optional) Name of the column that stores the last value generated.

      Defaults to a provider-chosen name.

      Default:
      ""
    • pkColumnValue

      String pkColumnValue
      (Optional) The primary key value in the generator table that distinguishes this set of generated values from others that may be stored in the table.

      Defaults to a provider-chosen value to store in the primary key column of the generator table

      Default:
      ""
    • initialValue

      int initialValue
      (Optional) The initial value to be used to initialize the column that stores the last value generated.
      Default:
      0
    • allocationSize

      int allocationSize
      (Optional) The amount to increment by when allocating id numbers from the generator.
      Default:
      50
    • uniqueConstraints

      UniqueConstraint[] uniqueConstraints
      (Optional) Unique constraints that are to be placed on the table. These are only used if table generation is in effect. These constraints apply in addition to primary key constraints.

      Defaults to no additional constraints.

      Default:
      {}
    • indexes

      Index[] indexes
      (Optional) Indexes for the table. These are only used if table generation is in effect. Note that it is not necessary to specify an index for a primary key, as the primary key index will be created automatically.
      Since:
      Java Persistence 2.1
      Default:
      {}