org.jumpmind.symmetric.db.mysql
Class MySqlDbDialect

java.lang.Object
  org.jumpmind.symmetric.db.AbstractDbDialect
      org.jumpmind.symmetric.db.mysql.MySqlDbDialect

All Implemented Interfaces:

IDbDialect

public class MySqlDbDialect
extends AbstractDbDialect
implements IDbDialect

Field Summary

Fields inherited from class org.jumpmind.symmetric.db.AbstractDbDialect

cachedModel, jdbcTemplate, MAX_SYMMETRIC_SUPPORTED_TRIGGER_SIZE, platform, sqlErrorTranslator, sqlTemplate, tablePrefix, transactionTemplate

Constructor Summary

MySqlDbDialect()

Method Summary

protected void	createRequiredFunctions()
void	disableSyncTriggers(java.lang.String nodeId)
protected boolean	doesTriggerExistOnPlatform(java.lang.String catalog, java.lang.String schema, java.lang.String tableName, java.lang.String triggerName)
void	enableSyncTriggers()
BinaryEncoding	getBinaryEncoding()
java.lang.String	getDefaultCatalog()
java.lang.String	getDefaultSchema()
java.lang.String	getIdentifierQuoteString()
java.lang.String	getSelectLastInsertIdSql(java.lang.String sequenceName)
int	getStreamingResultsFetchSize() According to the documentation (and experience) the jdbc driver for mysql requires the fetch size to be as follows.
java.lang.String	getSyncTriggersExpression()
java.lang.String	getTransactionTriggerExpression(Trigger trigger)
protected void	initForSpecificDialect()
boolean	isCharSpacePadded()
boolean	isCharSpaceTrimmed()
boolean	isEmptyStringNulled()
void	purge() Implement this if the database has some type of cleanup functionality that needs to be run when dropping database objects.
void	removeTrigger(java.lang.String catalogName, java.lang.String schemaName, java.lang.String triggerName, java.lang.String tableName, TriggerHistory oldHistory)
boolean	supportsTransactionId()
protected java.lang.String	switchCatalogForTriggerInstall(java.lang.String catalog, java.sql.Connection c) Provide the option switch a connection's schema for trigger installation.

Methods inherited from class org.jumpmind.symmetric.db.AbstractDbDialect

addPrefixAndCreateTablesIfNecessary, allowsNullForIdentityColumn, cleanupAfterDataLoad, createCsvDataSql, createCsvPrimaryKeySql, createInitalLoadSqlFor, createPostTriggerDDL, createPurgeSqlFor, createSavepoint, createSavepointForFallback, createTables, determineAutoIncrementFromResultSetMetaData, disableSyncTriggers, doesDatabaseNeedConfigured, doesTriggerExist, findTable, fixForeignKeys, getConfigDdlDatabase, getConfigDdlXml, getCreateSymmetricDDL, getCreateTableSQL, getCreateTableXML, getDatabaseColumnFilter, getEngineName, getJdbcTemplate, getMajorVersion, getMaxTriggerNameLength, getMetaDataFor, getMetaDataFor, getMinorVersion, getName, getPlatform, getProductVersion, getSequenceName, getSqlErrorTranslator, getTablePrefix, getTriggerName, getVersion, init, initColumnsForColumn, initColumnsForIndex, initColumnsForPK, initColumnsForTable, initConfigDb, initTrigger, insertWithGeneratedKey, insertWithGeneratedKey, isBlobOverrideToBinary, isBlobSyncSupported, isClobSyncSupported, isDateOverrideToTimestamp, isTransactionIdOverrideSupported, makeAllColumnsPrimaryKeysIfNoPrimaryKeysFound, prefixConfigDatabase, prepareTableForDataLoad, readColumn, readColumns, readColumns, readIndex, readIndices, readPrimaryKeyName, readPrimaryKeyNames, readTable, releaseSavepoint, replaceTemplateVariables, requiresSavepointForFallback, rollbackToSavepoint, setParameterService, setSqlTemplate, setStreamingResultsFetchSize, setTablePrefix, setTransactionTemplate, storesLowerCaseNamesInCatalog, storesUpperCaseNamesInCatalog, supportsGetGeneratedKeys

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.jumpmind.symmetric.db.IDbDialect

cleanupAfterDataLoad, createCsvDataSql, createCsvPrimaryKeySql, createInitalLoadSqlFor, createPurgeSqlFor, createSavepoint, createSavepointForFallback, createTables, disableSyncTriggers, doesDatabaseNeedConfigured, doesTriggerExist, getCreateSymmetricDDL, getCreateTableSQL, getCreateTableXML, getDatabaseColumnFilter, getEngineName, getJdbcTemplate, getMajorVersion, getMaxTriggerNameLength, getMetaDataFor, getMetaDataFor, getMinorVersion, getName, getPlatform, getProductVersion, getSqlErrorTranslator, getTablePrefix, getTriggerName, getVersion, initConfigDb, initTrigger, insertWithGeneratedKey, insertWithGeneratedKey, isBlobOverrideToBinary, isBlobSyncSupported, isClobSyncSupported, isDateOverrideToTimestamp, isTransactionIdOverrideSupported, prepareTableForDataLoad, releaseSavepoint, replaceTemplateVariables, requiresSavepointForFallback, rollbackToSavepoint, storesLowerCaseNamesInCatalog, storesUpperCaseNamesInCatalog

Constructor Detail

MySqlDbDialect

public MySqlDbDialect()

Method Detail

initForSpecificDialect

protected void initForSpecificDialect()

Specified by:

initForSpecificDialect in class AbstractDbDialect

createRequiredFunctions

protected void createRequiredFunctions()

Overrides:

createRequiredFunctions in class AbstractDbDialect

doesTriggerExistOnPlatform

protected boolean doesTriggerExistOnPlatform(java.lang.String catalog,
                                             java.lang.String schema,
                                             java.lang.String tableName,
                                             java.lang.String triggerName)

Specified by:

doesTriggerExistOnPlatform in class AbstractDbDialect

removeTrigger

public void removeTrigger(java.lang.String catalogName,
                          java.lang.String schemaName,
                          java.lang.String triggerName,
                          java.lang.String tableName,
                          TriggerHistory oldHistory)

Specified by:

removeTrigger in interface IDbDialect

disableSyncTriggers

public void disableSyncTriggers(java.lang.String nodeId)

Specified by:

disableSyncTriggers in interface IDbDialect

enableSyncTriggers

public void enableSyncTriggers()

Specified by:

enableSyncTriggers in interface IDbDialect

getSyncTriggersExpression

public java.lang.String getSyncTriggersExpression()

Specified by:

getSyncTriggersExpression in interface IDbDialect

getTransactionTriggerExpression

public java.lang.String getTransactionTriggerExpression(Trigger trigger)

Specified by:

getTransactionTriggerExpression in interface IDbDialect

Overrides:

getTransactionTriggerExpression in class AbstractDbDialect

supportsTransactionId

public boolean supportsTransactionId()

Specified by:

supportsTransactionId in interface IDbDialect

Overrides:

supportsTransactionId in class AbstractDbDialect

getSelectLastInsertIdSql

public java.lang.String getSelectLastInsertIdSql(java.lang.String sequenceName)

Specified by:

getSelectLastInsertIdSql in interface IDbDialect

Overrides:

getSelectLastInsertIdSql in class AbstractDbDialect

isCharSpacePadded

public boolean isCharSpacePadded()

Specified by:

isCharSpacePadded in interface IDbDialect

isCharSpaceTrimmed

public boolean isCharSpaceTrimmed()

Specified by:

isCharSpaceTrimmed in interface IDbDialect

isEmptyStringNulled

public boolean isEmptyStringNulled()

Specified by:

isEmptyStringNulled in interface IDbDialect

purge

public void purge()

Description copied from interface: IDbDialect

Implement this if the database has some type of cleanup functionality that needs to be run when dropping database objects. An example is Oracle's 'purge recyclebin'

Specified by:

purge in interface IDbDialect

getDefaultSchema

public java.lang.String getDefaultSchema()

Specified by:

getDefaultSchema in interface IDbDialect

getDefaultCatalog

public java.lang.String getDefaultCatalog()

Specified by:

getDefaultCatalog in interface IDbDialect

switchCatalogForTriggerInstall

protected java.lang.String switchCatalogForTriggerInstall(java.lang.String catalog,
                                                          java.sql.Connection c)
                                                   throws java.sql.SQLException

Description copied from class: AbstractDbDialect

Provide the option switch a connection's schema for trigger installation.

Overrides:

switchCatalogForTriggerInstall in class AbstractDbDialect

Throws:

java.sql.SQLException

getStreamingResultsFetchSize

public int getStreamingResultsFetchSize()

According to the documentation (and experience) the jdbc driver for mysql requires the fetch size to be as follows.

Specified by:

getStreamingResultsFetchSize in interface IDbDialect

Overrides:

getStreamingResultsFetchSize in class AbstractDbDialect

getBinaryEncoding

public BinaryEncoding getBinaryEncoding()

Specified by:

getBinaryEncoding in interface IDbDialect

Overrides:

getBinaryEncoding in class AbstractDbDialect

getIdentifierQuoteString

public java.lang.String getIdentifierQuoteString()

Specified by:

getIdentifierQuoteString in interface IDbDialect

Overrides:

getIdentifierQuoteString in class AbstractDbDialect