net.sf.hajdbc.dialect.mysql

Class MySQLDialect

java.lang.Object

net.sf.hajdbc.dialect.StandardDialect

net.sf.hajdbc.dialect.mysql.MySQLDialect

All Implemented Interfaces:

Dialect, DumpRestoreSupport, IdentityColumnSupport, SequenceSupport, TriggerSupport

public class MySQLDialect
extends StandardDialect
implements DumpRestoreSupport

Dialect for MySQL

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[]	RESERVED_KEY_WORDS

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

SQL_2003_RESERVED_KEY_WORDS

Constructor Summary

Constructors

Constructor and Description
MySQLDialect()

Method Summary

Methods

Modifier and Type	Method and Description
protected String	alterIdentityColumnFormat()
protected String	createForeignKeyConstraintFormat() Deferrability clause is not supported.
protected String	createUniqueConstraintFormat()
protected String	currentDatePattern()
protected String	currentTimePattern()
protected String	currentTimestampPattern()
protected String	dateLiteralFormat()
protected String	dropForeignKeyConstraintFormat()
protected String	dropUniqueConstraintFormat()
<Z,D extends Database<Z>> void	dump(D database, Decoder decoder, File file, boolean dataOnly)
List<String>	getDefaultSchemas(DatabaseMetaData metaData) Returns a search path of schemas
DumpRestoreSupport	getDumpRestoreSupport()
protected Set<String>	reservedIdentifiers(DatabaseMetaData metaData)
<Z,D extends Database<Z>> void	restore(D database, Decoder decoder, File file, boolean dataOnly)
protected String	timeLiteralFormat()
protected String	timestampLiteralFormat()
protected String	vendorPattern()

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

alterSequenceFormat, createColumnPropertiesFactory, createForeignKeyConstraintFactory, createIdentifierNormalizer, createQualifiedNameFactory, createSchemaFormat, createSequencePropertiesFactory, createTriggerFormat, createUniqueConstraintFactory, dropConstraintFormat, dropSchemaFormat, dropTriggerFormat, dummyTable, evaluateCurrentDate, evaluateCurrentTime, evaluateCurrentTimestamp, evaluateRand, executeFunction, executeFunctionFormat, executeFunctionSQL, executeQuery, failureXAErrorCodes, getAlterIdentityColumnSQL, getAlterSequenceSQL, getColumns, getColumnType, getConnectionProperties, getCreateForeignKeyConstraintSQL, getCreateSchemaSQL, getCreateTriggerSQL, getCreateUniqueConstraintSQL, getDropForeignKeyConstraintSQL, getDropSchemaSQL, getDropTriggerSQL, getDropUniqueConstraintSQL, getForeignKeyConstraints, getIdentityColumns, getIdentityColumnSupport, getNextSequenceValueSQL, getPrimaryKey, getSequences, getSequenceSupport, getTables, getTriggerRowAlias, getTriggerSupport, getTruncateTableSQL, getTypes, getUniqueConstraints, identifierPattern, indicatesFailure, indicatesFailure, indicatesFailure, indicatesFailure, insertIntoTablePattern, isSelectForUpdate, isValid, locatorPattern, meetsRequirement, nextSequenceValueFormat, parse, parseInsertTable, parseSequence, randomPattern, schemaPattern, selectForUpdatePattern, sequencePattern, sequenceTableType, truncateTableFormat

Methods inherited from class java.lang.Object

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

Field Detail

RESERVED_KEY_WORDS

protected static final String[] RESERVED_KEY_WORDS

Constructor Detail

MySQLDialect

public MySQLDialect()

Method Detail

vendorPattern

protected String vendorPattern()

Overrides:

vendorPattern in class StandardDialect

See Also:

StandardDialect.vendorPattern()

reservedIdentifiers

protected Set<String> reservedIdentifiers(DatabaseMetaData metaData)

Overrides:

reservedIdentifiers in class StandardDialect

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

Overrides:

getDefaultSchemas in class StandardDialect

Returns:

a list of schema names

Throws:

SQLException

See Also:

StandardDialect.getDefaultSchemas(java.sql.DatabaseMetaData)

createForeignKeyConstraintFormat

protected String createForeignKeyConstraintFormat()

Deferrability clause is not supported.

Overrides:

createForeignKeyConstraintFormat in class StandardDialect

See Also:

StandardDialect.createForeignKeyConstraintFormat()

createUniqueConstraintFormat

protected String createUniqueConstraintFormat()

Overrides:

createUniqueConstraintFormat in class StandardDialect

See Also:

StandardDialect.createUniqueConstraintFormat()

dropForeignKeyConstraintFormat

protected String dropForeignKeyConstraintFormat()

Overrides:

dropForeignKeyConstraintFormat in class StandardDialect

See Also:

StandardDialect.dropForeignKeyConstraintFormat()

dropUniqueConstraintFormat

protected String dropUniqueConstraintFormat()

Overrides:

dropUniqueConstraintFormat in class StandardDialect

See Also:

StandardDialect.dropUniqueConstraintFormat()

alterIdentityColumnFormat

protected String alterIdentityColumnFormat()

Overrides:

alterIdentityColumnFormat in class StandardDialect

See Also:

StandardDialect.alterIdentityColumnFormat()

currentDatePattern

protected String currentDatePattern()

Overrides:

currentDatePattern in class StandardDialect

See Also:

StandardDialect.currentDatePattern()

currentTimePattern

protected String currentTimePattern()

Overrides:

currentTimePattern in class StandardDialect

See Also:

StandardDialect.currentTimePattern()

currentTimestampPattern

protected String currentTimestampPattern()

Overrides:

currentTimestampPattern in class StandardDialect

See Also:

StandardDialect.currentTimestampPattern()

dateLiteralFormat

protected String dateLiteralFormat()

Overrides:

dateLiteralFormat in class StandardDialect

See Also:

StandardDialect.dateLiteralFormat()

timeLiteralFormat

protected String timeLiteralFormat()

Overrides:

timeLiteralFormat in class StandardDialect

See Also:

StandardDialect.timeLiteralFormat()

timestampLiteralFormat

protected String timestampLiteralFormat()

Overrides:

timestampLiteralFormat in class StandardDialect

See Also:

StandardDialect.timestampLiteralFormat()

getDumpRestoreSupport

public DumpRestoreSupport getDumpRestoreSupport()

Specified by:

getDumpRestoreSupport in interface Dialect

Overrides:

getDumpRestoreSupport in class StandardDialect

See Also:

StandardDialect.getDumpRestoreSupport()

dump

public <Z,D extends Database<Z>> void dump(D database,
                                  Decoder decoder,
                                  File file,
                                  boolean dataOnly)
          throws Exception

Specified by:

dump in interface DumpRestoreSupport

Throws:

Exception

restore

public <Z,D extends Database<Z>> void restore(D database,
                                     Decoder decoder,
                                     File file,
                                     boolean dataOnly)
             throws Exception

Specified by:

restore in interface DumpRestoreSupport

Throws:

Exception