org.jumpmind.symmetric.db.oracle
Class OracleDbDialect

java.lang.Object
  org.jumpmind.symmetric.db.AbstractDbDialect
      org.jumpmind.symmetric.db.oracle.OracleDbDialect

All Implemented Interfaces:

IDbDialect

public class OracleDbDialect
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

OracleDbDialect()

Method Summary

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	getSelectLastInsertIdSql(java.lang.String sequenceName)
protected java.lang.String	getSequenceName(SequenceIdentifier identifier)
java.lang.String	getSyncTriggersExpression()
java.lang.String	getTransactionTriggerExpression(Trigger trigger)
protected void	initForSpecificDialect()
boolean	isBlobOverrideToBinary()
boolean	isCharSpacePadded()
boolean	isCharSpaceTrimmed()
boolean	isDateOverrideToTimestamp()
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 schemaName, java.lang.String triggerName)
void	removeTrigger(java.lang.String catalogName, java.lang.String schemaName, java.lang.String triggerName, java.lang.String tableName, TriggerHistory oldHistory)
boolean	storesUpperCaseNamesInCatalog()
boolean	supportsTransactionId()

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

addPrefixAndCreateTablesIfNecessary, allowsNullForIdentityColumn, 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, getSqlErrorTranslator, getStreamingResultsFetchSize, getTablePrefix, getTriggerName, getVersion, init, initColumnsForColumn, initColumnsForIndex, initColumnsForPK, initColumnsForTable, initConfigDb, initTrigger, insertWithGeneratedKey, insertWithGeneratedKey, isBlobSyncSupported, isClobSyncSupported, isTransactionIdOverrideSupported, makeAllColumnsPrimaryKeysIfNoPrimaryKeysFound, prefixConfigDatabase, prepareTableForDataLoad, readColumn, readColumns, readColumns, readIndex, readIndices, readPrimaryKeyName, readPrimaryKeyNames, readTable, releaseSavepoint, replaceTemplateVariables, requiresSavepointForFallback, rollbackToSavepoint, setParameterService, setSqlTemplate, setStreamingResultsFetchSize, setTablePrefix, setTransactionTemplate, storesLowerCaseNamesInCatalog, supportsGetGeneratedKeys, 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, isBlobSyncSupported, isClobSyncSupported, isTransactionIdOverrideSupported, prepareTableForDataLoad, releaseSavepoint, replaceTemplateVariables, requiresSavepointForFallback, rollbackToSavepoint, storesLowerCaseNamesInCatalog

Constructor Detail

OracleDbDialect

public OracleDbDialect()

Method Detail

initForSpecificDialect

protected void initForSpecificDialect()

Specified by:

initForSpecificDialect 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

isBlobOverrideToBinary

public boolean isBlobOverrideToBinary()

Specified by:

isBlobOverrideToBinary in interface IDbDialect

Overrides:

isBlobOverrideToBinary in class AbstractDbDialect

isDateOverrideToTimestamp

public boolean isDateOverrideToTimestamp()

Specified by:

isDateOverrideToTimestamp in interface IDbDialect

Overrides:

isDateOverrideToTimestamp in class AbstractDbDialect

removeTrigger

public void removeTrigger(java.lang.String schemaName,
                          java.lang.String triggerName)

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

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

getSequenceName

protected java.lang.String getSequenceName(SequenceIdentifier identifier)

Overrides:

getSequenceName in class AbstractDbDialect

getSelectLastInsertIdSql

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

Specified by:

getSelectLastInsertIdSql in interface IDbDialect

Overrides:

getSelectLastInsertIdSql 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

storesUpperCaseNamesInCatalog

public boolean storesUpperCaseNamesInCatalog()

Specified by:

storesUpperCaseNamesInCatalog in interface IDbDialect

Overrides:

storesUpperCaseNamesInCatalog 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

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

getDefaultCatalog

public java.lang.String getDefaultCatalog()

Specified by:

getDefaultCatalog in interface IDbDialect

getDefaultSchema

public java.lang.String getDefaultSchema()

Specified by:

getDefaultSchema in interface IDbDialect