Sequencing Options

Use the following information to specify sequencing options:

Field | Description
--- | ---
Use Sequencing | Specify if this descriptor uses sequencing. If selected, specify the Name, Table, and Field for sequencing.

Name

Enter the name of the sequence.

- For table sequencing: Enter the name of the value in the sequence name column (for default table sequencing, the column named `SEQ_NAME`) of the sequence table (for default table sequencing, the table named `SEQUENCE`) that TopLink uses to look up the corresponding sequence count value (for default table sequencing, the corresponding value in the `SEQ_COUNT` column) for this descriptor's reference class. For more information, see "Table Sequencing".

- For native sequencing (Oracle platform): Enter the name of the sequence object that Oracle Database creates to manage sequencing for this descriptor's reference class. For more information, see "Native Sequencing With an Oracle Database Platform"

- For native sequencing (non-Oracle platform): For database compatibility, enter a generic name for the sequence, such as `SEQ`. For more information, see "Native Sequencing With a Non-Oracle Database Platform".

Table | Specify the name of the database table that contains the field (see Field) into which TopLink is to write the sequence value when a new instance of this descriptor's reference class is created. This is almost always this descriptor's primary table.

Field

Specify the name of the field in the specified table (see Table) into which TopLink is to write the sequence value when a new instance of this descriptor's reference class is created. This field is almost always the class's primary key (see "Configuring Primary Keys").

- For native sequencing (non-Oracle platform): Ensure that your database schema specifies the correct type for this field (see "Native Sequencing With a Non-Oracle Database Platform").

See Also

  Configuring Sequencing at the Descriptor Level
  Configuring Sequencing at the Project Level
  Configuring Sequencing at the Session Level