org.jumpmind.symmetric.db.hsqldb
Class HsqlDbDialect

java.lang.Object
  org.jumpmind.symmetric.db.AbstractDbDialect
      org.jumpmind.symmetric.db.hsqldb.HsqlDbDialect

All Implemented Interfaces:

IDbDialect

public class HsqlDbDialect
extends AbstractDbDialect
implements IDbDialect

Field Summary

static java.lang.String

DUAL_TABLE

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

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

Constructor Summary

HsqlDbDialect()

Method Summary

protected boolean	allowsNullForIdentityColumn()
void	disableSyncTriggers(java.lang.String nodeId)
protected boolean	doesTriggerExistOnPlatform(java.lang.String catalogName, 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	getSelectLastInsertIdSql(java.lang.String sequenceName)
java.lang.String	getSyncNodeDisabled()
java.lang.String	getSyncTriggersExpression()
java.lang.String	getTransactionTriggerExpression(Trigger trigger) This is not used by the HSQLDB Java triggers
protected void	initForSpecificDialect()
boolean	isBlobSyncSupported()
boolean	isCharSpacePadded()
boolean	isCharSpaceTrimmed()
boolean	isClobSyncSupported()
boolean	isEmptyStringNulled()
boolean	isSyncEnabled()
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)
void	removeTrigger(java.lang.String schemaName, java.lang.String triggerName, TriggerHistory hist)
void	setInitializeDatabase(boolean initializeDatabase)
boolean	storesUpperCaseNamesInCatalog()
boolean	supportsGetGeneratedKeys()

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

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

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, getIdentifierQuoteString, getJdbcTemplate, getMajorVersion, getMaxTriggerNameLength, getMetaDataFor, getMetaDataFor, getMinorVersion, getName, getPlatform, getProductVersion, getSqlErrorTranslator, getStreamingResultsFetchSize, getTablePrefix, getTriggerName, getVersion, initConfigDb, initTrigger, insertWithGeneratedKey, insertWithGeneratedKey, isBlobOverrideToBinary, isDateOverrideToTimestamp, isTransactionIdOverrideSupported, prepareTableForDataLoad, releaseSavepoint, replaceTemplateVariables, requiresSavepointForFallback, rollbackToSavepoint, storesLowerCaseNamesInCatalog, supportsTransactionId

Field Detail

DUAL_TABLE

public static java.lang.String DUAL_TABLE

Constructor Detail

HsqlDbDialect

public HsqlDbDialect()

Method Detail

initForSpecificDialect

protected void initForSpecificDialect()

Specified by:

initForSpecificDialect in class AbstractDbDialect

doesTriggerExistOnPlatform

protected boolean doesTriggerExistOnPlatform(java.lang.String catalogName,
                                             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 schemaName,
                          java.lang.String triggerName,
                          TriggerHistory hist)

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

isBlobSyncSupported

public boolean isBlobSyncSupported()

Specified by:

isBlobSyncSupported in interface IDbDialect

Overrides:

isBlobSyncSupported in class AbstractDbDialect

isClobSyncSupported

public boolean isClobSyncSupported()

Specified by:

isClobSyncSupported in interface IDbDialect

Overrides:

isClobSyncSupported in class AbstractDbDialect

isSyncEnabled

public boolean isSyncEnabled()

getSyncNodeDisabled

public java.lang.String getSyncNodeDisabled()

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)

This is not used by the HSQLDB Java triggers

Specified by:

getTransactionTriggerExpression in interface IDbDialect

Overrides:

getTransactionTriggerExpression in class AbstractDbDialect

getSelectLastInsertIdSql

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

Specified by:

getSelectLastInsertIdSql in interface IDbDialect

Overrides:

getSelectLastInsertIdSql in class AbstractDbDialect

getBinaryEncoding

public BinaryEncoding getBinaryEncoding()

Specified by:

getBinaryEncoding in interface IDbDialect

Overrides:

getBinaryEncoding 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

storesUpperCaseNamesInCatalog

public boolean storesUpperCaseNamesInCatalog()

Specified by:

storesUpperCaseNamesInCatalog in interface IDbDialect

Overrides:

storesUpperCaseNamesInCatalog in class AbstractDbDialect

supportsGetGeneratedKeys

public boolean supportsGetGeneratedKeys()

Overrides:

supportsGetGeneratedKeys in class AbstractDbDialect

allowsNullForIdentityColumn

protected boolean allowsNullForIdentityColumn()

Overrides:

allowsNullForIdentityColumn in class AbstractDbDialect

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

getDefaultCatalog

public java.lang.String getDefaultCatalog()

Specified by:

getDefaultCatalog in interface IDbDialect

getDefaultSchema

public java.lang.String getDefaultSchema()

Specified by:

getDefaultSchema in interface IDbDialect

setInitializeDatabase

public void setInitializeDatabase(boolean initializeDatabase)