net.sf.hajdbc.dialect

Class MySQLDialect

java.lang.Object

net.sf.hajdbc.dialect.StandardDialect

net.sf.hajdbc.dialect.MySQLDialect

All Implemented Interfaces:

Dialect

public class MySQLDialect
extends StandardDialect

Dialect for MySQL

Author:

Paul Ferraro

Constructor Summary

Constructors

Constructor and Description
MySQLDialect()

Method Summary

Modifier and Type	Method and Description
protected java.lang.String	alterIdentityColumnFormat()
protected java.lang.String	createForeignKeyConstraintFormat() Deferrability clause is not supported.
protected java.lang.String	createUniqueConstraintFormat()
protected java.lang.String	currentDatePattern()
protected java.lang.String	currentTimePattern()
protected java.lang.String	currentTimestampPattern()
protected java.lang.String	dateLiteralFormat()
protected java.lang.String	dropForeignKeyConstraintFormat()
protected java.lang.String	dropUniqueConstraintFormat()
java.util.List<java.lang.String>	getDefaultSchemas(java.sql.DatabaseMetaData metaData) Returns a search path of schemas
java.util.Collection<QualifiedName>	getSequences(java.sql.DatabaseMetaData metaData) Returns a collection of all sequences in this database.
java.lang.String	parseSequence(java.lang.String sql) Parses a sequence name from the specified SQL statement.
protected java.lang.String	timeLiteralFormat()
protected java.lang.String	timestampLiteralFormat()

Methods inherited from class net.sf.hajdbc.dialect.StandardDialect

alterSequenceFormat, currentTimestampFunction, dropConstraintFormat, dummyTable, evaluateCurrentDate, evaluateCurrentTime, evaluateCurrentTimestamp, evaluateRand, executeFunction, executeFunctionFormat, executeFunctionSQL, executeQuery, getAlterIdentityColumnSQL, getAlterSequenceSQL, getColumnType, getCreateForeignKeyConstraintSQL, getCreateUniqueConstraintSQL, getDropForeignKeyConstraintSQL, getDropUniqueConstraintSQL, getIdentifierPattern, getNextSequenceValueSQL, getSimpleSQL, getTruncateTableSQL, insertIntoTablePattern, isSelectForUpdate, nextSequenceValueFormat, parse, parseInsertTable, randomPattern, selectForUpdatePattern, sequencePattern, sequenceTableType, truncateTableFormat

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQLDialect

public MySQLDialect()

Method Detail

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

Overrides:

getDefaultSchemas in class StandardDialect

Returns:

a list of schema names

Throws:

java.sql.SQLException

See Also:

StandardDialect.getDefaultSchemas(java.sql.DatabaseMetaData)

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

Overrides:

parseSequence in class StandardDialect

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:

StandardDialect.parseSequence(java.lang.String)

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

Overrides:

getSequences in class StandardDialect

Parameters:

metaData - database meta data

Returns:

a collection of sequence names

Throws:

java.sql.SQLException

See Also:

StandardDialect.getSequences(java.sql.DatabaseMetaData)

createForeignKeyConstraintFormat

protected java.lang.String createForeignKeyConstraintFormat()

Deferrability clause is not supported.

Overrides:

createForeignKeyConstraintFormat in class StandardDialect

See Also:

StandardDialect.createForeignKeyConstraintFormat()

createUniqueConstraintFormat

protected java.lang.String createUniqueConstraintFormat()

Overrides:

createUniqueConstraintFormat in class StandardDialect

See Also:

StandardDialect.createUniqueConstraintFormat()

dropForeignKeyConstraintFormat

protected java.lang.String dropForeignKeyConstraintFormat()

Overrides:

dropForeignKeyConstraintFormat in class StandardDialect

See Also:

StandardDialect.dropForeignKeyConstraintFormat()

dropUniqueConstraintFormat

protected java.lang.String dropUniqueConstraintFormat()

Overrides:

dropUniqueConstraintFormat in class StandardDialect

See Also:

StandardDialect.dropUniqueConstraintFormat()

alterIdentityColumnFormat

protected java.lang.String alterIdentityColumnFormat()

Overrides:

alterIdentityColumnFormat in class StandardDialect

See Also:

StandardDialect.alterIdentityColumnFormat()

currentDatePattern

protected java.lang.String currentDatePattern()

Overrides:

currentDatePattern in class StandardDialect

See Also:

StandardDialect.currentDatePattern()

currentTimePattern

protected java.lang.String currentTimePattern()

Overrides:

currentTimePattern in class StandardDialect

See Also:

StandardDialect.currentTimePattern()

currentTimestampPattern

protected java.lang.String currentTimestampPattern()

Overrides:

currentTimestampPattern in class StandardDialect

See Also:

StandardDialect.currentTimestampPattern()

dateLiteralFormat

protected java.lang.String dateLiteralFormat()

Overrides:

dateLiteralFormat in class StandardDialect

See Also:

StandardDialect.dateLiteralFormat()

timeLiteralFormat

protected java.lang.String timeLiteralFormat()

Overrides:

timeLiteralFormat in class StandardDialect

See Also:

StandardDialect.timeLiteralFormat()

timestampLiteralFormat

protected java.lang.String timestampLiteralFormat()

Overrides:

timestampLiteralFormat in class StandardDialect

See Also:

StandardDialect.timestampLiteralFormat()