Package org.jumpmind.symmetric.db.hsqldb

Class HsqlDbSymmetricDialect

java.lang.Object

org.jumpmind.symmetric.db.AbstractSymmetricDialect

org.jumpmind.symmetric.db.AbstractEmbeddedSymmetricDialect

org.jumpmind.symmetric.db.hsqldb.HsqlDbSymmetricDialect

All Implemented Interfaces:

ISymmetricDialect

public class HsqlDbSymmetricDialect
extends AbstractEmbeddedSymmetricDialect
implements ISymmetricDialect

Field Summary

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

Method Summary

Modifier and Type	Method	Description
boolean	canGapsOccurInCapturedDataIds()
void	createRequiredDatabaseObjectsImpl(StringBuilder ddl)
void	disableSyncTriggers(ISqlTransaction transaction, String nodeId)
protected boolean	doesTriggerExistOnPlatform(StringBuilder sqlBuffer, String catalogName, String schemaName, String tableName, String triggerName)
void	dropRequiredDatabaseObjects()
void	enableSyncTriggers(ISqlTransaction transaction)
BinaryEncoding	getBinaryEncoding()
String	getDatabaseTimeSQL()
String	getSyncTriggersExpression()
String	getTransactionTriggerExpression(String defaultCatalog, String defaultSchema, Trigger trigger)
boolean	isBlobSyncSupported()
boolean	isCharColumnSpaceTrimmed()
boolean	isClobSyncSupported()
boolean	isEmptyStringNulled()
boolean	isNonBlankCharColumnSpacePadded()
void	removeTrigger(StringBuilder sqlBuffer, String catalogName, String schemaName, String triggerName, String tableName, ISqlTransaction transaction)
boolean	supportsTransactionId()
void	truncateTable(String tableName)

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

cleanDatabase, createCsvDataSql, createCsvPrimaryKeySql, createInitialLoadSqlFor, escapesTemplatesForDatabaseInserts, getDefaultCatalog, getInitialLoadTableAlias, preProcessTriggerSqlClause

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

areDatabaseTransactionsPendingSince, buildSqlReplacementTokens, cleanupTriggers, close, createDdlTrigger, createOrAlterTablesIfNecessary, createPostDdlTriggerDDL, createPostTriggerDDL, createPurgeSqlFor, createPurgeSqlFor, createPurgeSqlFor, createPurgeSqlForMultipleTables, createRequiredDatabaseObjects, createTrigger, createTrigger, disableSyncTriggers, doesDdlTriggerExist, doesTriggerExist, dropTablesAndDatabaseObjects, getColumnPositionUsingTemplate, getCreateRequiredDatabaseObjectsDDL, getCreateSymmetricDDL, getCurrentSequenceValue, getDatabaseTime, getDataHasChangedCondition, getDbSpecificDataHasChangedCondition, getDriverName, getDriverVersion, getDropTriggerSql, getEarliestTransactionStartTime, getEngineName, getInitialLoadTwoPassLobLengthSql, getInitialLoadTwoPassLobSql, getMajorVersion, getMasterCollation, getMaxTriggerNameLength, getMinorVersion, getName, getParameterService, getPlatform, getProductVersion, getSequenceKeyName, getSequenceName, getSourceNodeExpression, getSqlKeywords, getSqlReplacementTokens, getSqlTypeForIds, getSymmetricDdlChanges, getSymTablePermissions, getSyncTriggersOnIncomingExpression, getTablePrefix, getTargetDialect, getTargetDialect, getTargetPlatform, getTargetPlatform, getTemplateNumberPrecisionSpec, getTransactionId, getTriggerTemplate, getVersion, initTablesAndDatabaseObjects, insertWithGeneratedKey, insertWithGeneratedKey, install, installed, isInitialLoadTwoPassLob, isTransactionIdOverrideSupported, logSql, massageDataExtractionSql, massageForLob, merge, needsToSelectLobData, orderColumns, postCreateDdlTrigger, postCreateTrigger, prefixConfigDatabase, readDatabaseFromXml, readSymmetricSchemaFromDatabase, readSymmetricSchemaFromXml, removeDdlTrigger, removeTrigger, replaceTokens, requiresAutoCommitFalseToSetFetchSize, setExtensionService, setTargetDialect, supportsBatchUpdates, supportsDdlTriggers, supportsOpenCursorsAcrossCommit, supportsSubselectsInDelete, supportsSubselectsInUpdate, supportsTransactionViews, switchCatalogForTriggerInstall, uninstall, uninstall, verifyDatabaseIsCompatible

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, cleanDatabase, cleanupTriggers, createCsvDataSql, createCsvPrimaryKeySql, createDdlTrigger, createInitialLoadSqlFor, createOrAlterTablesIfNecessary, createPurgeSqlFor, createPurgeSqlFor, createPurgeSqlFor, createPurgeSqlForMultipleTables, createRequiredDatabaseObjects, createTrigger, createTrigger, disableSyncTriggers, doesDdlTriggerExist, doesTriggerExist, dropTablesAndDatabaseObjects, escapesTemplatesForDatabaseInserts, getColumnPositionUsingTemplate, getCreateRequiredDatabaseObjectsDDL, getCreateSymmetricDDL, getCurrentSequenceValue, getDatabaseTime, getDataHasChangedCondition, getDriverName, getDriverVersion, getEarliestTransactionStartTime, getEngineName, getInitialLoadTableAlias, getInitialLoadTwoPassLobSql, getMajorVersion, getMasterCollation, getMaxTriggerNameLength, getMinorVersion, getName, getParameterService, getPlatform, getProductVersion, getSequenceKeyName, getSequenceName, getSourceNodeExpression, getSqlKeywords, getSqlReplacementTokens, getSqlTypeForIds, getSymmetricDdlChanges, getSymTablePermissions, getSyncTriggersOnIncomingExpression, getTablePrefix, getTargetDialect, getTargetDialect, getTargetPlatform, getTargetPlatform, getTemplateNumberPrecisionSpec, getTransactionId, getTriggerTemplate, getVersion, initTablesAndDatabaseObjects, insertWithGeneratedKey, insertWithGeneratedKey, isInitialLoadTwoPassLob, isTransactionIdOverrideSupported, massageDataExtractionSql, massageForLob, needsToSelectLobData, orderColumns, preProcessTriggerSqlClause, readSymmetricSchemaFromXml, removeDdlTrigger, removeTrigger, setExtensionService, setTargetDialect, supportsBatchUpdates, supportsDdlTriggers, supportsOpenCursorsAcrossCommit, supportsSubselectsInDelete, supportsSubselectsInUpdate, supportsTransactionViews, verifyDatabaseIsCompatible

Constructor Details

HsqlDbSymmetricDialect

public HsqlDbSymmetricDialect(IParameterService parameterService,
 IDatabasePlatform platform)

Method Details

doesTriggerExistOnPlatform

protected boolean doesTriggerExistOnPlatform(StringBuilder sqlBuffer,
 String catalogName,
 String schemaName,
 String tableName,
 String triggerName)

Specified by:

doesTriggerExistOnPlatform in class AbstractSymmetricDialect

createRequiredDatabaseObjectsImpl

public void createRequiredDatabaseObjectsImpl(StringBuilder ddl)

Overrides:

createRequiredDatabaseObjectsImpl in class AbstractSymmetricDialect

dropRequiredDatabaseObjects

public void dropRequiredDatabaseObjects()

Specified by:

dropRequiredDatabaseObjects in interface ISymmetricDialect

Specified by:

dropRequiredDatabaseObjects in class AbstractSymmetricDialect

removeTrigger

public void removeTrigger(StringBuilder sqlBuffer,
 String catalogName,
 String schemaName,
 String triggerName,
 String tableName,
 ISqlTransaction transaction)

Specified by:

removeTrigger in interface ISymmetricDialect

Overrides:

removeTrigger in class AbstractSymmetricDialect

isBlobSyncSupported

public boolean isBlobSyncSupported()

Specified by:

isBlobSyncSupported in interface ISymmetricDialect

Overrides:

isBlobSyncSupported in class AbstractSymmetricDialect

isClobSyncSupported

public boolean isClobSyncSupported()

Specified by:

isClobSyncSupported in interface ISymmetricDialect

Overrides:

isClobSyncSupported in class AbstractSymmetricDialect

disableSyncTriggers

public void disableSyncTriggers(ISqlTransaction transaction,
 String nodeId)

Specified by:

disableSyncTriggers in interface ISymmetricDialect

enableSyncTriggers

public void enableSyncTriggers(ISqlTransaction transaction)

Specified by:

enableSyncTriggers in interface ISymmetricDialect

getSyncTriggersExpression

public String getSyncTriggersExpression()

Specified by:

getSyncTriggersExpression in interface ISymmetricDialect

getTransactionTriggerExpression

public String getTransactionTriggerExpression(String defaultCatalog,
 String defaultSchema,
 Trigger trigger)

Specified by:

getTransactionTriggerExpression in interface ISymmetricDialect

Overrides:

getTransactionTriggerExpression in class AbstractSymmetricDialect

getBinaryEncoding

public BinaryEncoding getBinaryEncoding()

Specified by:

getBinaryEncoding in interface ISymmetricDialect

Specified by:

getBinaryEncoding in class AbstractSymmetricDialect

isNonBlankCharColumnSpacePadded

public boolean isNonBlankCharColumnSpacePadded()

isCharColumnSpaceTrimmed

public boolean isCharColumnSpaceTrimmed()

isEmptyStringNulled

public boolean isEmptyStringNulled()

supportsTransactionId

public boolean supportsTransactionId()

Specified by:

supportsTransactionId in interface ISymmetricDialect

Overrides:

supportsTransactionId in class AbstractSymmetricDialect

truncateTable

public void truncateTable(String tableName)

Specified by:

truncateTable in interface ISymmetricDialect

Overrides:

truncateTable in class AbstractSymmetricDialect

canGapsOccurInCapturedDataIds

public boolean canGapsOccurInCapturedDataIds()

Specified by:

canGapsOccurInCapturedDataIds in interface ISymmetricDialect

Overrides:

canGapsOccurInCapturedDataIds in class AbstractSymmetricDialect

getDatabaseTimeSQL

public String getDatabaseTimeSQL()

Specified by:

getDatabaseTimeSQL in interface ISymmetricDialect

Overrides:

getDatabaseTimeSQL in class AbstractSymmetricDialect