net.sf.hajdbc.dialect

Class StandardDialect

java.lang.Object

net.sf.hajdbc.dialect.StandardDialect

All Implemented Interfaces:

Dialect, IdentityColumnSupport, SequenceSupport, TriggerSupport

Direct Known Subclasses:

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

public class StandardDialect
extends Object
implements Dialect, SequenceSupport, IdentityColumnSupport, TriggerSupport

Since:

1.1

Author:

Paul Ferraro

Nested Class Summary

Nested classes/interfaces inherited from interface net.sf.hajdbc.TriggerSupport

TriggerSupport.TriggerEventEnum, TriggerSupport.TriggerTimeEnum

Field Summary

Fields

Modifier and Type	Field and Description
protected static String[]	SQL_2003_RESERVED_KEY_WORDS

Constructor Summary

Constructors

Constructor and Description
StandardDialect()

Method Summary

Methods

Modifier and Type	Method and Description
protected String	alterIdentityColumnFormat()
protected String	alterSequenceFormat()
ColumnPropertiesFactory	createColumnPropertiesFactory(IdentifierNormalizer normalizer)
ForeignKeyConstraintFactory	createForeignKeyConstraintFactory(QualifiedNameFactory factory)
protected String	createForeignKeyConstraintFormat()
IdentifierNormalizer	createIdentifierNormalizer(DatabaseMetaData metaData)
QualifiedNameFactory	createQualifiedNameFactory(DatabaseMetaData metaData, IdentifierNormalizer normalizer)
protected String	createSchemaFormat()
SequencePropertiesFactory	createSequencePropertiesFactory(QualifiedNameFactory factory)
protected String	createTriggerFormat()
UniqueConstraintFactory	createUniqueConstraintFactory(IdentifierNormalizer normalizer)
protected String	createUniqueConstraintFormat()
protected String	currentDatePattern()
protected String	currentTimePattern()
protected String	currentTimestampPattern()
protected String	dateLiteralFormat()
protected String	dropConstraintFormat()
protected String	dropForeignKeyConstraintFormat()
protected String	dropSchemaFormat()
protected String	dropTriggerFormat()
protected String	dropUniqueConstraintFormat()
protected String	dummyTable()
String	evaluateCurrentDate(String sql, Date date) Replaces non-deterministic CURRENT_DATE functions with deterministic static values.
String	evaluateCurrentTime(String sql, Time time) Replaces non-deterministic CURRENT_TIME functions with deterministic static values.
String	evaluateCurrentTimestamp(String sql, Timestamp timestamp) Replaces non-deterministic CURRENT_TIMESTAMP functions with deterministic static values.
String	evaluateRand(String sql) Replaces non-deterministic RAND() functions with deterministic static values.
protected String	executeFunction(Connection connection, String function)
protected String	executeFunctionFormat()
protected String	executeFunctionSQL(String function)
protected List<String>	executeQuery(Connection connection, String sql)
protected Set<Integer>	failureXAErrorCodes()
String	getAlterIdentityColumnSQL(TableProperties table, ColumnProperties column, long value) Returns a SQL statement used reset the current value of an identity column.
String	getAlterSequenceSQL(SequenceProperties sequence, long value) Returns a SQL statement used reset the current value of a sequence.
Map<String,ColumnProperties>	getColumns(DatabaseMetaData metaData, QualifiedName table, ColumnPropertiesFactory factory) Returns the columns of the specified table.
int	getColumnType(ColumnProperties properties) Returns the data type of the specified column of the specified schema and table.
<Z,D extends Database<Z>> ConnectionProperties	getConnectionProperties(D database, Decoder decoder)
String	getCreateForeignKeyConstraintSQL(ForeignKeyConstraint key) Returns a SQL statement used to create a foreign key constraint.
String	getCreateSchemaSQL(String schema)
String	getCreateTriggerSQL(String name, TableProperties table, TriggerEvent event, String action)
String	getCreateUniqueConstraintSQL(UniqueConstraint constraint) Returns a SQL statement used to create a unique constraint.
List<String>	getDefaultSchemas(DatabaseMetaData metaData) Returns a search path of schemas
String	getDropForeignKeyConstraintSQL(ForeignKeyConstraint key) Returns a SQL statement used to drop a foreign key constraint.
String	getDropSchemaSQL(String schema)
String	getDropTriggerSQL(String name, TableProperties table)
String	getDropUniqueConstraintSQL(UniqueConstraint constraint) Returns a SQL statement used to drop a unique constraint.
DumpRestoreSupport	getDumpRestoreSupport()
Collection<ForeignKeyConstraint>	getForeignKeyConstraints(DatabaseMetaData metaData, QualifiedName table, ForeignKeyConstraintFactory factory) Returns the foreign key constraints on the specified table.
Collection<String>	getIdentityColumns(Collection<ColumnProperties> columns) Identifies any identity columns from the from the specified collection of columns
IdentityColumnSupport	getIdentityColumnSupport()
String	getNextSequenceValueSQL(SequenceProperties sequence) Returns a SQL statement for obtaining the next value the specified sequence
UniqueConstraint	getPrimaryKey(DatabaseMetaData metaData, QualifiedName table, UniqueConstraintFactory factory) Returns the primary key of the specified table.
Collection<SequenceProperties>	getSequences(DatabaseMetaData metaData, SequencePropertiesFactory factory) Returns a collection of sequences using dialect specific logic.
SequenceSupport	getSequenceSupport()
Collection<QualifiedName>	getTables(DatabaseMetaData metaData, QualifiedNameFactory factory) Returns all tables in this database mapped by schema.
String	getTriggerRowAlias(TriggerTime time)
TriggerSupport	getTriggerSupport()
String	getTruncateTableSQL(TableProperties properties) Returns a SQL statement used to truncate a table.
Map<Integer,Map.Entry<String,Integer>>	getTypes(DatabaseMetaData metaData) Returns a mapping of standard JDBC types to native types
Collection<UniqueConstraint>	getUniqueConstraints(DatabaseMetaData metaData, QualifiedName table, UniqueConstraint primaryKey, UniqueConstraintFactory factory) Returns the unique constraints on the specified table - excluding the primary key of the table.
protected Pattern	identifierPattern(DatabaseMetaData metaData)
protected boolean	indicatesFailure(int code) Indicates whether the specified vendor-specific error code indicates a database failure that should result in a database deactivation.
boolean	indicatesFailure(SQLException e) Determines whether the specified exception indicates a catastrophic error.
protected boolean	indicatesFailure(String sqlState) Indicates whether the specified SQLState indicates a database failure that should result in a database deactivation.
boolean	indicatesFailure(XAException e) Determines whether the specified exception indicates a catastrophic error.
protected String	insertIntoTablePattern()
boolean	isSelectForUpdate(String sql) Determines whether the specified SQL is a SELECT ...
boolean	isValid(Connection connection)
protected String	locatorPattern()
protected boolean	meetsRequirement(int minMajor, int minMinor)
protected String	nextSequenceValueFormat()
protected String	parse(Pattern pattern, String string)
String	parseInsertTable(String sql) Parses a table name from the specified INSERT SQL statement that may contain identity columns.
String	parseSequence(String sql) Parses a sequence name from the specified SQL statement.
protected String	randomPattern()
protected Set<String>	reservedIdentifiers(DatabaseMetaData metaData)
protected String	schemaPattern(DatabaseMetaData metaData)
protected String	selectForUpdatePattern()
protected String	sequencePattern()
protected String	sequenceTableType()
protected String	timeLiteralFormat()
protected String	timestampLiteralFormat()
protected String	truncateTableFormat()
protected String	vendorPattern()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

SQL_2003_RESERVED_KEY_WORDS

protected static final String[] SQL_2003_RESERVED_KEY_WORDS

Constructor Detail

StandardDialect

public StandardDialect()

Method Detail

vendorPattern

protected String vendorPattern()

locatorPattern

protected String locatorPattern()

selectForUpdatePattern

protected String selectForUpdatePattern()

insertIntoTablePattern

protected String insertIntoTablePattern()

sequencePattern

protected String sequencePattern()

currentDatePattern

protected String currentDatePattern()

currentTimePattern

protected String currentTimePattern()

currentTimestampPattern

protected String currentTimestampPattern()

randomPattern

protected String randomPattern()

schemaPattern

protected String schemaPattern(DatabaseMetaData metaData)
                        throws SQLException

Throws:

SQLException

executeFunctionFormat

protected String executeFunctionFormat()

executeFunctionSQL

protected String executeFunctionSQL(String function)

dummyTable

protected String dummyTable()

getTruncateTableSQL

public String getTruncateTableSQL(TableProperties properties)

Description copied from interface: Dialect

Returns a SQL statement used to truncate a table.

Specified by:

getTruncateTableSQL in interface Dialect

Parameters:

properties - table meta data

Returns:

a SQL statement

See Also:

Dialect.getTruncateTableSQL(net.sf.hajdbc.TableProperties)

truncateTableFormat

protected String truncateTableFormat()

getCreateForeignKeyConstraintSQL

public String getCreateForeignKeyConstraintSQL(ForeignKeyConstraint key)

Description copied from interface: Dialect

Returns a SQL statement used to create a foreign key constraint.

Specified by:

getCreateForeignKeyConstraintSQL in interface Dialect

Parameters:

key - foreign key constraint meta data

Returns:

a SQL statement

See Also:

Dialect.getCreateForeignKeyConstraintSQL(net.sf.hajdbc.ForeignKeyConstraint)

createForeignKeyConstraintFormat

protected String createForeignKeyConstraintFormat()

getDropForeignKeyConstraintSQL

public String getDropForeignKeyConstraintSQL(ForeignKeyConstraint key)

Description copied from interface: Dialect

Returns a SQL statement used to drop a foreign key constraint.

Specified by:

getDropForeignKeyConstraintSQL in interface Dialect

Parameters:

key - foreign key constraint meta data

Returns:

a SQL statement

See Also:

Dialect.getDropForeignKeyConstraintSQL(net.sf.hajdbc.ForeignKeyConstraint)

dropForeignKeyConstraintFormat

protected String dropForeignKeyConstraintFormat()

dropConstraintFormat

protected String dropConstraintFormat()

getCreateUniqueConstraintSQL

public String getCreateUniqueConstraintSQL(UniqueConstraint constraint)

Description copied from interface: Dialect

Returns a SQL statement used to create a unique constraint.

Specified by:

getCreateUniqueConstraintSQL in interface Dialect

Parameters:

constraint - unique constraint meta data

Returns:

a SQL statement

See Also:

Dialect.getCreateUniqueConstraintSQL(net.sf.hajdbc.UniqueConstraint)

createUniqueConstraintFormat

protected String createUniqueConstraintFormat()

getDropUniqueConstraintSQL

public String getDropUniqueConstraintSQL(UniqueConstraint constraint)

Description copied from interface: Dialect

Returns a SQL statement used to drop a unique constraint.

Specified by:

getDropUniqueConstraintSQL in interface Dialect

Parameters:

constraint - unique constraint meta data

Returns:

a SQL statement

See Also:

Dialect.getDropUniqueConstraintSQL(net.sf.hajdbc.UniqueConstraint)

dropUniqueConstraintFormat

protected String dropUniqueConstraintFormat()

isSelectForUpdate

public boolean isSelectForUpdate(String sql)

Description copied from interface: Dialect

Determines whether the specified SQL is a SELECT ... FOR UPDATE statement

Specified by:

isSelectForUpdate in interface Dialect

Parameters:

sql - a SQL statement

Returns:

true if this is a SELECT ... FOR UPDATE statement, false if it is not

See Also:

Dialect.isSelectForUpdate(java.lang.String)

getDefaultSchemas

public List<String> getDefaultSchemas(DatabaseMetaData metaData)
                               throws SQLException

Description copied from interface: Dialect

Returns a search path of schemas

Specified by:

getDefaultSchemas in interface Dialect

Returns:

a list of schema names

Throws:

SQLException

See Also:

Dialect.getDefaultSchemas(java.sql.DatabaseMetaData)

executeFunction

protected String executeFunction(Connection connection,
                     String function)
                          throws SQLException

Throws:

SQLException

executeQuery

protected List<String> executeQuery(Connection connection,
                        String sql)
                             throws SQLException

Throws:

SQLException

getSequenceSupport

public SequenceSupport getSequenceSupport()

Specified by:

getSequenceSupport in interface Dialect

See Also:

Dialect.getSequenceSupport()

parseSequence

public String parseSequence(String sql)

Description copied from interface: SequenceSupport

Parses a sequence name from the specified SQL statement.

Specified by:

parseSequence in interface SequenceSupport

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

See Also:

SequenceSupport.parseSequence(java.lang.String)

getColumnType

public int getColumnType(ColumnProperties properties)

Description copied from interface: Dialect

Returns the data type of the specified column of the specified schema and table. This method is intended to correct JDBC driver type mapping quirks.

Specified by:

getColumnType in interface Dialect

Parameters:

properties - table column meta data

Returns:

the JDBC data type of this column

See Also:

Dialect.getColumnType(net.sf.hajdbc.ColumnProperties)

getSequences

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

Returns a collection of sequences using dialect specific logic.

Specified by:

getSequences in interface SequenceSupport

Parameters:

metaData - database meta data

Returns:

a collection of sequences

Throws:

SQLException

See Also:

SequenceSupport.getSequences(java.sql.DatabaseMetaData, net.sf.hajdbc.SequencePropertiesFactory)

sequenceTableType

protected String sequenceTableType()

getNextSequenceValueSQL

public String getNextSequenceValueSQL(SequenceProperties sequence)

Description copied from interface: SequenceSupport

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

Specified by:

getNextSequenceValueSQL in interface SequenceSupport

Parameters:

sequence - a sequence name

Returns:

a SQL statement

See Also:

SequenceSupport.getNextSequenceValueSQL(net.sf.hajdbc.SequenceProperties)

nextSequenceValueFormat

protected String nextSequenceValueFormat()

getAlterSequenceSQL

public String getAlterSequenceSQL(SequenceProperties sequence,
                         long value)

Description copied from interface: SequenceSupport

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

Specified by:

getAlterSequenceSQL in interface SequenceSupport

Parameters:

sequence - a sequence name

value - a sequence value

Returns:

a SQL statement

See Also:

SequenceSupport.getAlterSequenceSQL(net.sf.hajdbc.SequenceProperties, long)

alterSequenceFormat

protected String alterSequenceFormat()

getIdentityColumnSupport

public IdentityColumnSupport getIdentityColumnSupport()

Specified by:

getIdentityColumnSupport in interface Dialect

See Also:

Dialect.getIdentityColumnSupport()

parseInsertTable

public String parseInsertTable(String sql)

Description copied from interface: IdentityColumnSupport

Parses a table name from the specified INSERT SQL statement that may contain identity columns.

Specified by:

parseInsertTable in interface IdentityColumnSupport

Parameters:

sql - a SQL statement

Returns:

the name of a table, or null if this SQL statement is not an INSERT statement or this dialect does not support identity columns

getAlterIdentityColumnSQL

public String getAlterIdentityColumnSQL(TableProperties table,
                               ColumnProperties column,
                               long value)

Description copied from interface: IdentityColumnSupport

Returns a SQL statement used reset the current value of an identity column.

Specified by:

getAlterIdentityColumnSQL in interface IdentityColumnSupport

Parameters:

table - a sequence name

column - a sequence name

value - a sequence value

Returns:

a SQL statement

alterIdentityColumnFormat

protected String alterIdentityColumnFormat()

parse

protected String parse(Pattern pattern,
           String string)

evaluateCurrentDate

public String evaluateCurrentDate(String sql,
                         Date date)

Replaces non-deterministic CURRENT_DATE functions with deterministic static values.

Specified by:

evaluateCurrentDate in interface Dialect

Parameters:

sql - an SQL statement

date - the replacement date

Returns:

an equivalent deterministic SQL statement

See Also:

Dialect.evaluateCurrentDate(java.lang.String, java.sql.Date)

dateLiteralFormat

protected String dateLiteralFormat()

evaluateCurrentTime

public String evaluateCurrentTime(String sql,
                         Time time)

Replaces non-deterministic CURRENT_TIME functions with deterministic static values.

Specified by:

evaluateCurrentTime in interface Dialect

Parameters:

sql - an SQL statement

time - the replacement time

Returns:

an equivalent deterministic SQL statement

See Also:

Dialect.evaluateCurrentTime(java.lang.String, java.sql.Time)

timeLiteralFormat

protected String timeLiteralFormat()

evaluateCurrentTimestamp

public String evaluateCurrentTimestamp(String sql,
                              Timestamp timestamp)

Replaces non-deterministic CURRENT_TIMESTAMP functions with deterministic static values.

Specified by:

evaluateCurrentTimestamp in interface Dialect

Parameters:

sql - an SQL statement

timestamp - the replacement timestamp

Returns:

an equivalent deterministic SQL statement

See Also:

Dialect.evaluateCurrentTimestamp(java.lang.String, java.sql.Timestamp)

timestampLiteralFormat

protected String timestampLiteralFormat()

evaluateRand

public String evaluateRand(String sql)

Replaces non-deterministic RAND() functions with deterministic static values.

Specified by:

evaluateRand in interface Dialect

Parameters:

sql - an SQL statement

Returns:

an equivalent deterministic SQL statement

See Also:

Dialect.evaluateRand(java.lang.String)

indicatesFailure

public boolean indicatesFailure(SQLException e)

Determines whether the specified exception indicates a catastrophic error.

Specified by:

indicatesFailure in interface Dialect

Parameters:

e - an exception

Returns:

true, if the exception indicates catastrophe, false otherwise

See Also:

Dialect.indicatesFailure(java.sql.SQLException)

indicatesFailure

protected boolean indicatesFailure(String sqlState)

Indicates whether the specified SQLState indicates a database failure that should result in a database deactivation.

Parameters:

sqlState - a SQL:2003 or X/Open SQLState

Returns:

true if the SQLState indicate a failure, false otherwise

indicatesFailure

protected boolean indicatesFailure(int code)

Indicates whether the specified vendor-specific error code indicates a database failure that should result in a database deactivation.

Parameters:

code - a vendor-specific error code

Returns:

true if the error code indicate a failure, false otherwise

indicatesFailure

public boolean indicatesFailure(XAException e)

Determines whether the specified exception indicates a catastrophic error.

Specified by:

indicatesFailure in interface Dialect

Parameters:

e - an exception

Returns:

true, if the exception indicates catastrophe, false otherwise

See Also:

Dialect.indicatesFailure(javax.transaction.xa.XAException)

failureXAErrorCodes

protected Set<Integer> failureXAErrorCodes()

getDumpRestoreSupport

public DumpRestoreSupport getDumpRestoreSupport()

Specified by:

getDumpRestoreSupport in interface Dialect

See Also:

Dialect.getDumpRestoreSupport()

getTriggerSupport

public TriggerSupport getTriggerSupport()

Specified by:

getTriggerSupport in interface Dialect

See Also:

Dialect.getTriggerSupport()

getCreateTriggerSQL

public String getCreateTriggerSQL(String name,
                         TableProperties table,
                         TriggerEvent event,
                         String action)

Specified by:

getCreateTriggerSQL in interface TriggerSupport

See Also:

TriggerSupport.getCreateTriggerSQL(java.lang.String, net.sf.hajdbc.TableProperties, net.sf.hajdbc.TriggerEvent, java.lang.String)

createTriggerFormat

protected String createTriggerFormat()

getDropTriggerSQL

public String getDropTriggerSQL(String name,
                       TableProperties table)

Specified by:

getDropTriggerSQL in interface TriggerSupport

See Also:

TriggerSupport.getDropTriggerSQL(String, net.sf.hajdbc.TableProperties)

dropTriggerFormat

protected String dropTriggerFormat()

getTriggerRowAlias

public String getTriggerRowAlias(TriggerTime time)

Specified by:

getTriggerRowAlias in interface TriggerSupport

See Also:

TriggerSupport.getTriggerRowAlias(net.sf.hajdbc.TriggerTime)

getCreateSchemaSQL

public String getCreateSchemaSQL(String schema)

Specified by:

getCreateSchemaSQL in interface Dialect

See Also:

Dialect.getCreateSchemaSQL(java.lang.String)

createSchemaFormat

protected String createSchemaFormat()

getDropSchemaSQL

public String getDropSchemaSQL(String schema)

Specified by:

getDropSchemaSQL in interface Dialect

See Also:

Dialect.getDropSchemaSQL(java.lang.String)

dropSchemaFormat

protected String dropSchemaFormat()

meetsRequirement

protected boolean meetsRequirement(int minMajor,
                       int minMinor)

getTables

public Collection<QualifiedName> getTables(DatabaseMetaData metaData,
                                  QualifiedNameFactory factory)
                                    throws SQLException

Returns all tables in this database mapped by schema.

Specified by:

getTables in interface Dialect

Parameters:

metaData - a DatabaseMetaData implementation

Returns:

a Map of schema name to Collection of table names

Throws:

SQLException - if an error occurs access DatabaseMetaData

getColumns

public Map<String,ColumnProperties> getColumns(DatabaseMetaData metaData,
                                      QualifiedName table,
                                      ColumnPropertiesFactory factory)
                                        throws SQLException

Returns the columns of the specified table.

Specified by:

getColumns in interface Dialect

Parameters:

metaData - a DatabaseMetaData implementation

table - a schema qualified table name

Returns:

a Map of column name to column properties

Throws:

SQLException - if an error occurs access DatabaseMetaData

getPrimaryKey

public UniqueConstraint getPrimaryKey(DatabaseMetaData metaData,
                             QualifiedName table,
                             UniqueConstraintFactory factory)
                               throws SQLException

Returns the primary key of the specified table.

Specified by:

getPrimaryKey in interface Dialect

Parameters:

metaData - a DatabaseMetaData implementation

table - a schema qualified table name

Returns:

a unique constraint

Throws:

SQLException - if an error occurs access DatabaseMetaData

getForeignKeyConstraints

public Collection<ForeignKeyConstraint> getForeignKeyConstraints(DatabaseMetaData metaData,
                                                        QualifiedName table,
                                                        ForeignKeyConstraintFactory factory)
                                                          throws SQLException

Returns the foreign key constraints on the specified table.

Specified by:

getForeignKeyConstraints in interface Dialect

Parameters:

metaData - a DatabaseMetaData implementation

table - a schema qualified table name

Returns:

a Collection of foreign key constraints.

Throws:

SQLException - if an error occurs access DatabaseMetaData

getUniqueConstraints

public Collection<UniqueConstraint> getUniqueConstraints(DatabaseMetaData metaData,
                                                QualifiedName table,
                                                UniqueConstraint primaryKey,
                                                UniqueConstraintFactory factory)
                                                  throws SQLException

Returns the unique constraints on the specified table - excluding the primary key of the table.

Specified by:

getUniqueConstraints in interface Dialect

Parameters:

metaData - a schema qualified table name

table - a qualified table name

primaryKey - the primary key of this table

Returns:

a Collection of unique constraints.

Throws:

SQLException - if an error occurs access DatabaseMetaData

getIdentityColumns

public Collection<String> getIdentityColumns(Collection<ColumnProperties> columns)
                                      throws SQLException

Identifies any identity columns from the from the specified collection of columns

Specified by:

getIdentityColumns in interface Dialect

Parameters:

columns - the columns of a table

Returns:

a collection of column names

Throws:

SQLException

getTypes

public Map<Integer,Map.Entry<String,Integer>> getTypes(DatabaseMetaData metaData)
                                                throws SQLException

Returns a mapping of standard JDBC types to native types

Specified by:

getTypes in interface Dialect

Parameters:

metaData - database meta data

Returns:

a map of JDBC types

Throws:

SQLException

See Also:

Dialect.getTypes(java.sql.DatabaseMetaData)

createIdentifierNormalizer

public IdentifierNormalizer createIdentifierNormalizer(DatabaseMetaData metaData)
                                                throws SQLException

Specified by:

createIdentifierNormalizer in interface Dialect

Throws:

SQLException

identifierPattern

protected Pattern identifierPattern(DatabaseMetaData metaData)
                             throws SQLException

Throws:

SQLException

reservedIdentifiers

protected Set<String> reservedIdentifiers(DatabaseMetaData metaData)
                                   throws SQLException

Throws:

SQLException

createQualifiedNameFactory

public QualifiedNameFactory createQualifiedNameFactory(DatabaseMetaData metaData,
                                              IdentifierNormalizer normalizer)
                                                throws SQLException

Specified by:

createQualifiedNameFactory in interface Dialect

Throws:

SQLException

createColumnPropertiesFactory

public ColumnPropertiesFactory createColumnPropertiesFactory(IdentifierNormalizer normalizer)

Specified by:

createColumnPropertiesFactory in interface Dialect

createSequencePropertiesFactory

public SequencePropertiesFactory createSequencePropertiesFactory(QualifiedNameFactory factory)

Specified by:

createSequencePropertiesFactory in interface SequenceSupport

createForeignKeyConstraintFactory

public ForeignKeyConstraintFactory createForeignKeyConstraintFactory(QualifiedNameFactory factory)

Specified by:

createForeignKeyConstraintFactory in interface Dialect

createUniqueConstraintFactory

public UniqueConstraintFactory createUniqueConstraintFactory(IdentifierNormalizer normalizer)

Specified by:

createUniqueConstraintFactory in interface Dialect

isValid

public boolean isValid(Connection connection)
                throws SQLException

Specified by:

isValid in interface Dialect

Throws:

SQLException

getConnectionProperties

public <Z,D extends Database<Z>> ConnectionProperties getConnectionProperties(D database,
                                                                     Decoder decoder)
                                             throws SQLException

Specified by:

getConnectionProperties in interface Dialect

Throws:

SQLException