Skip Headers

# Sequencing Configuration Options

Previous

Next

You can configure sequencing using either TopLink Workbench or Java (but not both).

Using TopLink Workbench, create one sequence with a single preallocation size that applies to all descriptors that require sequencing. You can configure table sequencing (see "Table Sequencing") or native sequencing (see "Native Sequencing With an Oracle Database Platform"). If you choose table sequencing, you can either use default table and column names or specify your own (see "Default Versus Custom Sequence Table"). Oracle recommends using TopLink Workbench to configure sequencing. Using TopLink Workbench, you can easily configure the sequencing options applicable to most applications. For more information, see "Configuring Sequencing at the Project Level" or "Configuring Sequencing at the Session Level".

Using Java, you can configure any sequence type that TopLink supports (see "Sequencing Types"). You can create any number and combination of sequences per project. You can create a sequence object explicitly or use the platform default sequence (see "Default Sequencing"). You can associate the same sequence with more than one descriptor or associate different sequences (and different sequence types) to various descriptors. You can configure a separate preallocation size for each descriptor's sequence. For more information, see "Using Java".