net.sf.hajdbc

Interface SequenceSupport

All Known Implementing Classes:

DB2Dialect, DerbyDialect, FirebirdDialect, H2Dialect, HSQLDBDialect, IngresDialect, MaxDBDialect, MckoiDialect, MySQLDialect, OracleDialect, PostgreSQLDialect, StandardDialect, SybaseDialect

public interface SequenceSupport

Author:

Paul Ferraro

Method Summary

Methods

Modifier and Type	Method and Description
SequencePropertiesFactory	createSequencePropertiesFactory(QualifiedNameFactory factory)
String	getAlterSequenceSQL(SequenceProperties sequence, long value) Returns a SQL statement used reset the current value of a sequence.
String	getNextSequenceValueSQL(SequenceProperties sequence) Returns a SQL statement for obtaining the next value the specified sequence
Collection<SequenceProperties>	getSequences(DatabaseMetaData metaData, SequencePropertiesFactory factory) Returns a collection of sequences using dialect specific logic.
String	parseSequence(String sql) Parses a sequence name from the specified SQL statement.

Method Detail

parseSequence

String parseSequence(String sql)
                     throws SQLException

Parses a sequence name from the specified SQL statement.

Parameters:

sql - a SQL statement

Returns:

the name of a sequence, or null if this SQL statement does not reference a sequence or this dialect does not support sequences

Throws:

SQLException

Since:

2.0

getSequences

Collection<SequenceProperties> getSequences(DatabaseMetaData metaData,
                                          SequencePropertiesFactory factory)
                                            throws SQLException

Returns a collection of sequences using dialect specific logic.

Parameters:

metaData - database meta data

Returns:

a collection of sequences

Throws:

SQLException

getNextSequenceValueSQL

String getNextSequenceValueSQL(SequenceProperties sequence)
                               throws SQLException

Returns a SQL statement for obtaining the next value the specified sequence

Parameters:

sequence - a sequence name

Returns:

a SQL statement

Throws:

SQLException

Since:

2.0

getAlterSequenceSQL

String getAlterSequenceSQL(SequenceProperties sequence,
                         long value)
                           throws SQLException

Returns a SQL statement used reset the current value of a sequence.

Parameters:

sequence - a sequence name

value - a sequence value

Returns:

a SQL statement

Throws:

SQLException

Since:

2.0

createSequencePropertiesFactory

SequencePropertiesFactory createSequencePropertiesFactory(QualifiedNameFactory factory)