SQL dialect.
| Modifier and Type | Method and Description |
|---|---|
| public default String | Returns: The sequence creation commandThe name of the sequence sequenceName)Typically dialects which support sequences can create a sequence with a single command. |
| public default String | Returns: The sequence creation commandThe name of the sequence sequenceName, int The initial value to apply to 'create sequence' statement initialValue, int The increment value to apply to 'create sequence' statement incrementSize)Typically dialects which support sequences can create a sequence with a single command. |
| public default String[] | Returns: The sequence creation commandsThe name of the sequence sequenceName, int The initial value to apply to 'create sequence' statement initialValue, int The increment value to apply to 'create sequence' statement incrementSize)An optional multi-line form for databases which |
| public default String | Returns: The sequence drop commandsThe name of the sequence sequenceName)Typically dialects which support sequences can drop a sequence with a single command. |
| public default String[] | Returns: The sequence drop commandsThe name of the sequence sequenceName)The multiline script used to drop a sequence. |
| public default String | |
| public String | Returns: The "next value" fragment.the name of the sequence sequenceName)Generate the select expression fragment that will retrieve the next value of a sequence as part of another (typically DML) statement. |
| public default String | Returns: The "previous value" fragment.the name of the sequence sequenceName)Generate the select expression fragment that will retrieve the previous value of a sequence as part of another (typically DML) statement. |
| public default String | Returns: String The select "next value" statement.the name of the sequence sequenceName)Generate the appropriate select statement to to retrieve the next value of a sequence. |
| public default String | Returns: String The select "next value" statement.the name of the sequence sequenceName, int the increment, in case it needs to be passed explicitly increment)Generate the appropriate select statement to to retrieve the next value of a sequence. |
| public default String | Returns: String The select "previous value" statement.the name of the sequence sequenceName)Generate the appropriate select statement to to retrieve the previous value of a sequence. |
| public default boolean | sometimesNeedsStartingValue()
Do we need to explicitly specify |
| public default String | |
| public default boolean | Returns: True if such "pooled" sequences are supported; false otherwise.Does this dialect support "pooled" sequences. |
| public default boolean | Returns: True if sequences supported; false otherwise.Does this dialect support sequences? |
| getCreateSequenceString | back to summary |
|---|---|
| public default String getCreateSequenceString(String sequenceName) throws MappingException Typically dialects which support sequences can create a sequence with
a single command. This method is a convenience making it easier to
implement
The default definition is to return
Dialects which support sequences and can create a sequence in a single
command need *only* override this method. Dialects which support
sequences but require multiple commands to create a sequence should
override
| |
| getCreateSequenceString | back to summary |
|---|---|
| public default String getCreateSequenceString(String sequenceName, int initialValue, int incrementSize) throws MappingException Typically dialects which support sequences can create a sequence with
a single command. This method is a convenience making it easier to
implement
Overloaded form of getCreateSequenceString(String)
with the string: start with initialValue increment by incrementSize
for the arguments initialValue and incrementSize. Dialects
need to override this method if different key phrases are used to apply the
allocation information.
| |
| getCreateSequenceStrings | back to summary |
|---|---|
| public default String[] getCreateSequenceStrings(String sequenceName, int initialValue, int incrementSize) throws MappingException An optional multi-line form for databases which
| |
| getDropSequenceString | back to summary |
|---|---|
| public default String getDropSequenceString(String sequenceName) throws MappingException Typically dialects which support sequences can drop a sequence
with a single command. This is convenience form of
Dialects which support sequences and can drop a sequence in a
single command need *only* override this method. Dialects
which support sequences but require multiple commands to drop
a sequence should instead override
| |
| getDropSequenceStrings | back to summary |
|---|---|
| public default String[] getDropSequenceStrings(String sequenceName) throws MappingException The multiline script used to drop a sequence.
| |
| getFromDual | back to summary |
|---|---|
| public default String getFromDual() | |
| getSelectSequenceNextValString | back to summary |
|---|---|
| public String getSelectSequenceNextValString(String sequenceName) throws MappingException Generate the select expression fragment that will retrieve the next value of a sequence as part of another (typically DML) statement.
This differs from
| |
| getSelectSequencePreviousValString | back to summary |
|---|---|
| public default String getSelectSequencePreviousValString(String sequenceName) throws MappingException Generate the select expression fragment that will retrieve the previous value of a sequence as part of another (typically DML) statement.
This differs from
| |
| getSequenceNextValString | back to summary |
|---|---|
| public default String getSequenceNextValString(String sequenceName) throws MappingException Generate the appropriate select statement to to retrieve the next value of a sequence. This should be a stand alone select statement.
| |
| getSequenceNextValString | back to summary |
|---|---|
| public default String getSequenceNextValString(String sequenceName, int increment) throws MappingException Generate the appropriate select statement to to retrieve the next value of a sequence. This should be a stand alone select statement.
| |
| getSequencePreviousValString | back to summary |
|---|---|
| public default String getSequencePreviousValString(String sequenceName) throws MappingException Generate the appropriate select statement to to retrieve the previous value of a sequence. This should be a stand alone select statement.
| |
| sometimesNeedsStartingValue | back to summary |
|---|---|
| public default boolean sometimesNeedsStartingValue() Do we need to explicitly specify | |
| startingValue | back to summary |
|---|---|
| public default String startingValue(int initialValue, int incrementSize) | |
| supportsPooledSequences | back to summary |
|---|---|
| public default boolean supportsPooledSequences() Does this dialect support "pooled" sequences. Not aware of a better name for this. Essentially can we specify the initial and increment values?
| |
| supportsSequences | back to summary |
|---|---|
| public default boolean supportsSequences() Does this dialect support sequences?
| |