Purpose: Defines sequencing through using a SEQUENCE table.
Description This is the default sequencing mechanism. A table defaulting to SEQUENCE is used to generate unique ids. The table has a name field (SEQ_NAME) storing each sequences name, and a counter (SEQ_COUNT) storing the last sequence id generated. There will be a row in the table for each sequence object.
| Modifier and Type | Field and Description |
|---|---|
| protected String | counterFieldName
Hold the name of the column in the sequence table which specifies the sequence numeric value |
| public static final String | defaultTableName
Default sequence table name |
| protected String | nameFieldName
Hold the name of the column in the sequence table which specifies the sequence name |
| protected DatabaseTable | table
Hold the database table |
| Access | Constructor and Description |
|---|---|
| public | |
| public | |
| public | TableSequence(String name, int size)
Create a new sequence with the name and sequence pre-allocation size. |
| public | |
| public | TableSequence(String name, String tableName)
Create a new sequence with the name, and the sequence table name. |
| public | TableSequence(String name, String tableName, String nameFieldName, String counterFieldName)
Create a new sequence with the name, and the sequence table information. |
| public | |
| public | TableSequence(String name, int size, String tableName, String nameFieldName, String counterFieldName)
|
| Modifier and Type | Method and Description |
|---|---|
| protected ValueReadQuery | buildSelectQuery()
Overrides org. |
| protected DataModifyQuery | buildUpdateQuery()
Overrides org. |
| public boolean | equals(Object
the reference object with which to compare. obj)Overrides org. |
| public String | |
| public String | |
| public String | |
| public DatabaseTable | |
| public List | |
| public String | |
| public int | hashCode()
Overrides org. |
| public boolean | |
| public void | |
| public void | |
| public void | |
| public void | |
| public void |
| counterFieldName | back to summary |
|---|---|
| protected String counterFieldName Hold the name of the column in the sequence table which specifies the sequence numeric value | |
| defaultTableName | back to summary |
|---|---|
| public static final String defaultTableName
Deprecated Use an empty string as a default sequence table name instead, that triggers usage of platform.getDefaultSequenceTableName() when the sequence is connected. Default sequence table name | |
| nameFieldName | back to summary |
|---|---|
| protected String nameFieldName Hold the name of the column in the sequence table which specifies the sequence name | |
| table | back to summary |
|---|---|
| protected DatabaseTable table Hold the database table | |
| TableSequence | back to summary |
|---|---|
| public TableSequence() | |
| TableSequence | back to summary |
|---|---|
| public TableSequence(String name) Create a new sequence with the name. | |
| TableSequence | back to summary |
|---|---|
| public TableSequence(String name, int size) Create a new sequence with the name and sequence pre-allocation size. | |
| TableSequence | back to summary |
|---|---|
| public TableSequence(String name, int size, int initialValue) | |
| TableSequence | back to summary |
|---|---|
| public TableSequence(String name, String tableName) Create a new sequence with the name, and the sequence table name. | |
| TableSequence | back to summary |
|---|---|
| public TableSequence(String name, String tableName, String nameFieldName, String counterFieldName) Create a new sequence with the name, and the sequence table information. | |
| TableSequence | back to summary |
|---|---|
| public TableSequence(String name, int size, String tableName) | |
| TableSequence | back to summary |
|---|---|
| public TableSequence(String name, int size, String tableName, String nameFieldName, String counterFieldName) | |
| buildSelectQuery | back to summary |
|---|---|
| protected ValueReadQuery buildSelectQuery() Overrides org. Doc from org. INTERNAL:
| |
| buildUpdateQuery | back to summary |
|---|---|
| protected DataModifyQuery buildUpdateQuery() Overrides org. Doc from org. INTERNAL:
| |
| equals | back to summary |
|---|---|
| public boolean equals(Object obj) Overrides org. Doc from java. Indicates whether some other object is "equal to" this one.
The
An equivalence relation partitions the elements it operates on into equivalence classes; all the members of an equivalence class are equal to each other. Members of an equivalence class are substitutable for each other, at least for some purposes. | |
| getCounterFieldName | back to summary |
|---|---|
| public String getCounterFieldName() | |
| getNameFieldName | back to summary |
|---|---|
| public String getNameFieldName() | |
| getQualifiedTableName | back to summary |
|---|---|
| public String getQualifiedTableName() | |
| getTable | back to summary |
|---|---|
| public DatabaseTable getTable() | |
| getTableIndexes | back to summary |
|---|---|
| public List | |
| getTableName | back to summary |
|---|---|
| public String getTableName() | |
| hashCode | back to summary |
|---|---|
| public int hashCode() Overrides org. Doc from java. Returns a hash code value for the object. This method is
supported for the benefit of hash tables such as those provided by
The general contract of
| |
| isTable | back to summary |
|---|---|
| public boolean isTable() Overrides org.
| |
| onConnect | back to summary |
|---|---|
| public void onConnect() Overrides org. Doc from org. INTERNAL:
| |
| setCounterFieldName | back to summary |
|---|---|
| public void setCounterFieldName(String name) | |
| setNameFieldName | back to summary |
|---|---|
| public void setNameFieldName(String name) | |
| setTable | back to summary |
|---|---|
| public void setTable(DatabaseTable table) | |
| setTableName | back to summary |
|---|---|
| public void setTableName(String name) | |