Package org.jumpmind.symmetric.db.mssql

Class MsSql2008SymmetricDialect

java.lang.Object

org.jumpmind.symmetric.db.AbstractSymmetricDialect

org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect

org.jumpmind.symmetric.db.mssql.MsSql2008SymmetricDialect

All Implemented Interfaces:

ISymmetricDialect

Direct Known Subclasses:

MsSql2016SymmetricDialect

public class MsSql2008SymmetricDialect
extends MsSqlSymmetricDialect

Field Summary

Fields inherited from class org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect

noCount, SQL_DROP_FUNCTION, SQL_FUNCTION_INSTALLED, supportsDisableTriggers

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

databaseMajorVersion, databaseMinorVersion, databaseName, databaseProductVersion, driverName, driverVersion, extensionService, isSpatialTypesEnabled, log, MAX_SYMMETRIC_SUPPORTED_TRIGGER_SIZE, parameterService, platform, sqlKeywords, sqlReplacementTokens, supportsDdlTriggers, supportsGetGeneratedKeys, supportsSubselectsInDelete, supportsSubselectsInUpdate, supportsTransactionViews, tablePrefixLowerCase, targetDialect, triggerTemplate

Constructor Summary

Constructors

Constructor	Description
MsSql2008SymmetricDialect(IParameterService parameterService, IDatabasePlatform platform)

Method Summary

Modifier and Type	Method	Description
boolean	doesDdlTriggerExist(String catalogName, String schema, String triggerName)
protected String	getDbSpecificDataHasChangedCondition(Trigger trigger)

Methods inherited from class org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect

alterLockEscalation, cleanDatabase, createBase64EncodeFunction, createNodeDisabledFunction, createOrAlterTablesIfNecessary, createRequiredDatabaseObjectsImpl, createTriggersDisabledFunction, disableSyncTriggers, doesTriggerExistOnPlatform, dropBase64EncodeFunction, dropNodeDisabledFunction, dropRequiredDatabaseObjects, dropTriggersDisabledFunction, enableSyncTriggers, getBinaryEncoding, getCurrentSequenceValue, getSymTablePermissions, getSyncTriggersExpression, getSyncTriggersOnIncomingExpression, getTransactionTriggerExpression, isTransactionIdOverrideSupported, needsToSelectLobData, postCreateTrigger, readSymmetricSchemaFromXml, removeDdlTrigger, removeTrigger, setColumnToNtext, setColumnToVarChar, supportsDisableTriggers, supportsTransactionId, switchCatalogForTriggerInstall, verifyDatabaseIsCompatible

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

areDatabaseTransactionsPendingSince, buildSqlReplacementTokens, canGapsOccurInCapturedDataIds, cleanupTriggers, close, createCsvDataSql, createCsvPrimaryKeySql, createDdlTrigger, createInitialLoadSqlFor, createPostDdlTriggerDDL, createPostTriggerDDL, createPurgeSqlFor, createPurgeSqlFor, createPurgeSqlFor, createPurgeSqlForMultipleTables, createRequiredDatabaseObjects, createTrigger, createTrigger, disableSyncTriggers, doesTriggerExist, dropTablesAndDatabaseObjects, escapesTemplatesForDatabaseInserts, getColumnPositionUsingTemplate, getCreateRequiredDatabaseObjectsDDL, getCreateSymmetricDDL, getDatabaseTime, getDatabaseTimeSQL, getDataHasChangedCondition, getDriverName, getDriverVersion, getDropTriggerSql, getEarliestTransactionStartTime, getEngineName, getInitialLoadTableAlias, getInitialLoadTwoPassLobLengthSql, getInitialLoadTwoPassLobSql, getMajorVersion, getMasterCollation, getMaxTriggerNameLength, getMinorVersion, getName, getParameterService, getPlatform, getProductVersion, getSequenceKeyName, getSequenceName, getSourceNodeExpression, getSqlKeywords, getSqlReplacementTokens, getSqlTypeForIds, getSymmetricDdlChanges, getTablePrefix, getTargetDialect, getTargetDialect, getTargetPlatform, getTargetPlatform, getTemplateNumberPrecisionSpec, getTransactionId, getTriggerTemplate, getVersion, initTablesAndDatabaseObjects, insertWithGeneratedKey, insertWithGeneratedKey, install, installed, isBlobSyncSupported, isClobSyncSupported, isInitialLoadTwoPassLob, logSql, massageDataExtractionSql, massageForLob, merge, orderColumns, postCreateDdlTrigger, prefixConfigDatabase, preProcessTriggerSqlClause, readDatabaseFromXml, readSymmetricSchemaFromDatabase, removeTrigger, replaceTokens, requiresAutoCommitFalseToSetFetchSize, setExtensionService, setTargetDialect, supportsBatchUpdates, supportsDdlTriggers, supportsOpenCursorsAcrossCommit, supportsSubselectsInDelete, supportsSubselectsInUpdate, supportsTransactionViews, truncateTable, uninstall, uninstall

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.ISymmetricDialect

areDatabaseTransactionsPendingSince, canGapsOccurInCapturedDataIds, cleanupTriggers, createCsvDataSql, createCsvPrimaryKeySql, createDdlTrigger, createInitialLoadSqlFor, createPurgeSqlFor, createPurgeSqlFor, createPurgeSqlFor, createPurgeSqlForMultipleTables, createRequiredDatabaseObjects, createTrigger, createTrigger, disableSyncTriggers, doesTriggerExist, dropTablesAndDatabaseObjects, escapesTemplatesForDatabaseInserts, getColumnPositionUsingTemplate, getCreateRequiredDatabaseObjectsDDL, getCreateSymmetricDDL, getDatabaseTime, getDatabaseTimeSQL, getDataHasChangedCondition, getDriverName, getDriverVersion, getEarliestTransactionStartTime, getEngineName, getInitialLoadTableAlias, getInitialLoadTwoPassLobSql, getMajorVersion, getMasterCollation, getMaxTriggerNameLength, getMinorVersion, getName, getParameterService, getPlatform, getProductVersion, getSequenceKeyName, getSequenceName, getSourceNodeExpression, getSqlKeywords, getSqlReplacementTokens, getSqlTypeForIds, getSymmetricDdlChanges, getTablePrefix, getTargetDialect, getTargetDialect, getTargetPlatform, getTargetPlatform, getTemplateNumberPrecisionSpec, getTransactionId, getTriggerTemplate, getVersion, initTablesAndDatabaseObjects, insertWithGeneratedKey, insertWithGeneratedKey, isBlobSyncSupported, isClobSyncSupported, isInitialLoadTwoPassLob, massageDataExtractionSql, massageForLob, orderColumns, preProcessTriggerSqlClause, removeTrigger, setExtensionService, setTargetDialect, supportsBatchUpdates, supportsDdlTriggers, supportsOpenCursorsAcrossCommit, supportsSubselectsInDelete, supportsSubselectsInUpdate, supportsTransactionViews, truncateTable

Constructor Details

MsSql2008SymmetricDialect

public MsSql2008SymmetricDialect(IParameterService parameterService,
 IDatabasePlatform platform)

Method Details

getDbSpecificDataHasChangedCondition

protected String getDbSpecificDataHasChangedCondition(Trigger trigger)

Overrides:

getDbSpecificDataHasChangedCondition in class MsSqlSymmetricDialect

doesDdlTriggerExist

public boolean doesDdlTriggerExist(String catalogName,
 String schema,
 String triggerName)

Specified by:

doesDdlTriggerExist in interface ISymmetricDialect

Overrides:

doesDdlTriggerExist in class AbstractSymmetricDialect