net.sf.hajdbc.dialect

Class StandardDialect

java.lang.Object

net.sf.hajdbc.dialect.StandardDialect

All Implemented Interfaces:

Dialect

Direct Known Subclasses:

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

public class StandardDialect
extends java.lang.Object
implements Dialect

Since:

1.1

Author:

Paul Ferraro

Constructor Summary

Constructors

Constructor and Description
StandardDialect()

Method Summary

Modifier and Type	Method and Description
protected java.lang.String	alterIdentityColumnFormat()
protected java.lang.String	alterSequenceFormat()
protected java.lang.String	createForeignKeyConstraintFormat()
protected java.lang.String	createUniqueConstraintFormat()
protected java.lang.String	currentDatePattern()
protected java.lang.String	currentTimePattern()
protected java.lang.String	currentTimestampFunction()
protected java.lang.String	currentTimestampPattern()
protected java.lang.String	dateLiteralFormat()
protected java.lang.String	dropConstraintFormat()
protected java.lang.String	dropForeignKeyConstraintFormat()
protected java.lang.String	dropUniqueConstraintFormat()
protected java.lang.String	dummyTable()
java.lang.String	evaluateCurrentDate(java.lang.String sql, java.sql.Date date) Replaces non-deterministic CURRENT_DATE functions with deterministic static values.
java.lang.String	evaluateCurrentTime(java.lang.String sql, java.sql.Time time) Replaces non-deterministic CURRENT_TIME functions with deterministic static values.
java.lang.String	evaluateCurrentTimestamp(java.lang.String sql, java.sql.Timestamp timestamp) Replaces non-deterministic CURRENT_TIMESTAMP functions with deterministic static values.
java.lang.String	evaluateRand(java.lang.String sql) Replaces non-deterministic RAND() functions with deterministic static values.
protected java.lang.String	executeFunction(java.sql.Connection connection, java.lang.String function)
protected java.lang.String	executeFunctionFormat()
protected java.lang.String	executeFunctionSQL(java.lang.String function)
protected java.util.List<java.lang.String>	executeQuery(java.sql.Connection connection, java.lang.String sql)
java.lang.String	getAlterIdentityColumnSQL(TableProperties table, ColumnProperties column, long value) Returns a SQL statement used reset the current value of an identity column.
java.lang.String	getAlterSequenceSQL(SequenceProperties sequence, long value) Returns a SQL statement used reset the current value of a sequence.
int	getColumnType(ColumnProperties properties) Returns the data type of the specified column of the specified schema and table.
java.lang.String	getCreateForeignKeyConstraintSQL(ForeignKeyConstraint key) Returns a SQL statement used to create a foreign key constraint.
java.lang.String	getCreateUniqueConstraintSQL(UniqueConstraint constraint) Returns a SQL statement used to create a unique constraint.
java.util.List<java.lang.String>	getDefaultSchemas(java.sql.DatabaseMetaData metaData) Returns a search path of schemas
java.lang.String	getDropForeignKeyConstraintSQL(ForeignKeyConstraint key) Returns a SQL statement used to drop a foreign key constraint.
java.lang.String	getDropUniqueConstraintSQL(UniqueConstraint constraint) Returns a SQL statement used to drop a unique constraint.
java.util.regex.Pattern	getIdentifierPattern(java.sql.DatabaseMetaData metaData) Returns a pattern for identifiers that do not require quoting
java.lang.String	getNextSequenceValueSQL(SequenceProperties sequence) Returns a SQL statement for obtaining the next value the specified sequence
java.util.Collection<QualifiedName>	getSequences(java.sql.DatabaseMetaData metaData) Returns a collection of all sequences in this database.
java.lang.String	getSimpleSQL() Returns a simple SQL statement used to validate whether a database is alive or not.
java.lang.String	getTruncateTableSQL(TableProperties properties) Returns a SQL statement used to truncate a table.
protected java.lang.String	insertIntoTablePattern()
boolean	isSelectForUpdate(java.lang.String sql) Determines whether the specified SQL is a SELECT ...
protected java.lang.String	nextSequenceValueFormat()
protected java.lang.String	parse(java.util.regex.Pattern pattern, java.lang.String string)
java.lang.String	parseInsertTable(java.lang.String sql) Parses a table name from the specified INSERT SQL statement that may contain identity columns.
java.lang.String	parseSequence(java.lang.String sql) Parses a sequence name from the specified SQL statement.
protected java.lang.String	randomPattern()
protected java.lang.String	selectForUpdatePattern()
protected java.lang.String	sequencePattern()
protected java.lang.String	sequenceTableType()
protected java.lang.String	timeLiteralFormat()
protected java.lang.String	timestampLiteralFormat()
protected java.lang.String	truncateTableFormat()

Methods inherited from class java.lang.Object

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

Constructor Detail

StandardDialect

public StandardDialect()

Method Detail

selectForUpdatePattern

protected java.lang.String selectForUpdatePattern()

insertIntoTablePattern

protected java.lang.String insertIntoTablePattern()

sequencePattern

protected java.lang.String sequencePattern()

currentDatePattern

protected java.lang.String currentDatePattern()

currentTimePattern

protected java.lang.String currentTimePattern()

currentTimestampPattern

protected java.lang.String currentTimestampPattern()

randomPattern

protected java.lang.String randomPattern()

getSimpleSQL

public java.lang.String getSimpleSQL()

Description copied from interface: Dialect

Returns a simple SQL statement used to validate whether a database is alive or not.

Specified by:

getSimpleSQL in interface Dialect

Returns:

a SQL statement

See Also:

Dialect.getSimpleSQL()

executeFunctionFormat

protected java.lang.String executeFunctionFormat()

executeFunctionSQL

protected java.lang.String executeFunctionSQL(java.lang.String function)

currentTimestampFunction

protected java.lang.String currentTimestampFunction()

dummyTable

protected java.lang.String dummyTable()

getTruncateTableSQL

public java.lang.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 java.lang.String truncateTableFormat()

getCreateForeignKeyConstraintSQL

public java.lang.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 java.lang.String createForeignKeyConstraintFormat()

getDropForeignKeyConstraintSQL

public java.lang.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 java.lang.String dropForeignKeyConstraintFormat()

dropConstraintFormat

protected java.lang.String dropConstraintFormat()

getCreateUniqueConstraintSQL

public java.lang.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 java.lang.String createUniqueConstraintFormat()

getDropUniqueConstraintSQL

public java.lang.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 java.lang.String dropUniqueConstraintFormat()

isSelectForUpdate

public boolean isSelectForUpdate(java.lang.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)

parseInsertTable

public java.lang.String parseInsertTable(java.lang.String sql)

Description copied from interface: Dialect

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

Specified by:

parseInsertTable in interface Dialect

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

See Also:

Dialect.parseInsertTable(java.lang.String)

getDefaultSchemas

public java.util.List<java.lang.String> getDefaultSchemas(java.sql.DatabaseMetaData metaData)
                                                   throws java.sql.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:

java.sql.SQLException

See Also:

Dialect.getDefaultSchemas(java.sql.DatabaseMetaData)

executeFunction

protected java.lang.String executeFunction(java.sql.Connection connection,
                                           java.lang.String function)
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQuery

protected java.util.List<java.lang.String> executeQuery(java.sql.Connection connection,
                                                        java.lang.String sql)
                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

parseSequence

public java.lang.String parseSequence(java.lang.String sql)

Description copied from interface: Dialect

Parses a sequence name from the specified SQL statement.

Specified by:

parseSequence in interface Dialect

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:

Dialect.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 java.util.Collection<QualifiedName> getSequences(java.sql.DatabaseMetaData metaData)
                                                 throws java.sql.SQLException

Description copied from interface: Dialect

Returns a collection of all sequences in this database.

Specified by:

getSequences in interface Dialect

Parameters:

metaData - database meta data

Returns:

a collection of sequence names

Throws:

java.sql.SQLException

See Also:

Dialect.getSequences(java.sql.DatabaseMetaData)

sequenceTableType

protected java.lang.String sequenceTableType()

getNextSequenceValueSQL

public java.lang.String getNextSequenceValueSQL(SequenceProperties sequence)

Description copied from interface: Dialect

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

Specified by:

getNextSequenceValueSQL in interface Dialect

Parameters:

sequence - a sequence name

Returns:

a SQL statement

See Also:

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

nextSequenceValueFormat

protected java.lang.String nextSequenceValueFormat()

getAlterSequenceSQL

public java.lang.String getAlterSequenceSQL(SequenceProperties sequence,
                                            long value)

Description copied from interface: Dialect

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

Specified by:

getAlterSequenceSQL in interface Dialect

Parameters:

sequence - a sequence name

value - a sequence value

Returns:

a SQL statement

See Also:

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

alterSequenceFormat

protected java.lang.String alterSequenceFormat()

getAlterIdentityColumnSQL

public java.lang.String getAlterIdentityColumnSQL(TableProperties table,
                                                  ColumnProperties column,
                                                  long value)
                                           throws java.sql.SQLException

Description copied from interface: Dialect

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

Specified by:

getAlterIdentityColumnSQL in interface Dialect

Parameters:

table - a sequence name

column - a sequence name

value - a sequence value

Returns:

a SQL statement

Throws:

java.sql.SQLException

alterIdentityColumnFormat

protected java.lang.String alterIdentityColumnFormat()

getIdentifierPattern

public java.util.regex.Pattern getIdentifierPattern(java.sql.DatabaseMetaData metaData)
                                             throws java.sql.SQLException

Description copied from interface: Dialect

Returns a pattern for identifiers that do not require quoting

Specified by:

getIdentifierPattern in interface Dialect

Returns:

a regular expression pattern

Throws:

java.sql.SQLException

See Also:

Dialect.getIdentifierPattern(java.sql.DatabaseMetaData)

parse

protected java.lang.String parse(java.util.regex.Pattern pattern,
                                 java.lang.String string)

evaluateCurrentDate

public java.lang.String evaluateCurrentDate(java.lang.String sql,
                                            java.sql.Date date)

Description copied from interface: Dialect

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 java.lang.String dateLiteralFormat()

evaluateCurrentTime

public java.lang.String evaluateCurrentTime(java.lang.String sql,
                                            java.sql.Time time)

Description copied from interface: Dialect

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 java.lang.String timeLiteralFormat()

evaluateCurrentTimestamp

public java.lang.String evaluateCurrentTimestamp(java.lang.String sql,
                                                 java.sql.Timestamp timestamp)

Description copied from interface: Dialect

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 java.lang.String timestampLiteralFormat()

evaluateRand

public java.lang.String evaluateRand(java.lang.String sql)

Description copied from interface: Dialect

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)