Package org.jumpmind.symmetric.db.mssql

Class MsSql2016SymmetricDialect

java.lang.Object

org.jumpmind.symmetric.db.AbstractSymmetricDialect

org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect

org.jumpmind.symmetric.db.mssql.MsSql2008SymmetricDialect

org.jumpmind.symmetric.db.mssql.MsSql2016SymmetricDialect

All Implemented Interfaces:

ISymmetricDialect

public class MsSql2016SymmetricDialect
extends MsSql2008SymmetricDialect

Field Summary

Fields

Modifier and Type	Field	Description
protected Boolean	supportsSessionContext

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
MsSql2016SymmetricDialect(IParameterService parameterService, IDatabasePlatform platform)

Method Summary

Modifier and Type	Method	Description
protected void	createNodeDisabledFunction(StringBuilder ddl)
protected void	createTriggersDisabledFunction(StringBuilder ddl)
void	disableSyncTriggers(ISqlTransaction transaction, String nodeId)
void	enableSyncTriggers(ISqlTransaction transaction)
protected boolean	supportsDisableTriggers()
protected boolean	supportsSessionContext()

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

doesDdlTriggerExist, getDbSpecificDataHasChangedCondition

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

alterLockEscalation, cleanDatabase, createBase64EncodeFunction, createOrAlterTablesIfNecessary, createRequiredDatabaseObjectsImpl, doesTriggerExistOnPlatform, dropBase64EncodeFunction, dropNodeDisabledFunction, dropRequiredDatabaseObjects, dropTriggersDisabledFunction, getBinaryEncoding, getCurrentSequenceValue, getSymTablePermissions, getSyncTriggersExpression, getSyncTriggersOnIncomingExpression, getTransactionTriggerExpression, isTransactionIdOverrideSupported, needsToSelectLobData, postCreateTrigger, readSymmetricSchemaFromXml, removeDdlTrigger, removeTrigger, setColumnToNtext, setColumnToVarChar, 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

Field Details

supportsSessionContext

protected Boolean supportsSessionContext

Constructor Details

MsSql2016SymmetricDialect

public MsSql2016SymmetricDialect(IParameterService parameterService,
 IDatabasePlatform platform)

Method Details

createTriggersDisabledFunction

protected void createTriggersDisabledFunction(StringBuilder ddl)

Overrides:

createTriggersDisabledFunction in class MsSqlSymmetricDialect

createNodeDisabledFunction

protected void createNodeDisabledFunction(StringBuilder ddl)

Overrides:

createNodeDisabledFunction in class MsSqlSymmetricDialect

supportsDisableTriggers

protected boolean supportsDisableTriggers()

Overrides:

supportsDisableTriggers in class MsSqlSymmetricDialect

supportsSessionContext

protected boolean supportsSessionContext()

disableSyncTriggers

public void disableSyncTriggers(ISqlTransaction transaction,
 String nodeId)

Specified by:

disableSyncTriggers in interface ISymmetricDialect

Overrides:

disableSyncTriggers in class MsSqlSymmetricDialect

enableSyncTriggers

public void enableSyncTriggers(ISqlTransaction transaction)

Specified by:

enableSyncTriggers in interface ISymmetricDialect

Overrides:

enableSyncTriggers in class MsSqlSymmetricDialect