Package org.jumpmind.db.platform.oracle

Class Oracle122DatabasePlatform

java.lang.Object

org.jumpmind.db.platform.AbstractDatabasePlatform

org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

org.jumpmind.db.platform.oracle.OracleDatabasePlatform

org.jumpmind.db.platform.oracle.Oracle122DatabasePlatform

All Implemented Interfaces:

IDatabasePlatform

Direct Known Subclasses:

Oracle23DatabasePlatform

public class Oracle122DatabasePlatform
extends OracleDatabasePlatform

Field Summary

Fields inherited from class org.jumpmind.db.platform.oracle.OracleDatabasePlatform

JDBC_DRIVER, JDBC_DRIVER_OLD, JDBC_SUBPROTOCOL_OCI8, JDBC_SUBPROTOCOL_THIN, JDBC_SUBPROTOCOL_THIN_OLD

Fields inherited from class org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

dataSource, sqlTemplate, sqlTemplateDirty

Fields inherited from class org.jumpmind.db.platform.AbstractDatabasePlatform

clearCacheModelTimeoutInMs, ddlBuilder, ddlReader, defaultCatalog, defaultSchema, log, metadataIgnoreCase, MODEL_DEFAULT_NAME, PERMISSION_TEST_TABLE_NAME, REQUIRED_FIELD_NULL_SUBSTITUTE, settings, sourceNodeId, storesLowerCaseIdentifiers, storesMixedCaseIdentifiers, storesUpperCaseIdentifiers, supportsMultiThreadedTransactions, supportsTransactions, supportsTruncate, tableCache, useMultiThreadSyncTriggers, ZERO_DATE_STRING

Constructor Summary

Constructors

Constructor	Description
Oracle122DatabasePlatform(DataSource dataSource, SqlTemplateSettings settings)

Method Summary

Modifier and Type	Method	Description
protected OracleDdlBuilder	createDdlBuilder()
String	getName()
String	massageForLimitOffset(String sql, int limit, int offset)
boolean	supportsLimitOffset()

Methods inherited from class org.jumpmind.db.platform.oracle.OracleDatabasePlatform

canColumnBeUsedInWhereClause, createDdlReader, createSqlTemplate, createSqlTemplateDirty, getCharSetName, getCreateSymTriggerPermission, getDefaultCatalog, getDefaultSchema, getEstimatedRowCount, getExecuteSymPermission, getLogMinePermission, getSliceTableSql, getTransactions, massageForObjectAlreadyExists, supportsSliceTables

Methods inherited from class org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

getDataSource, getSqlTemplate, getSqlTemplateDirty, resetDataSource

Methods inherited from class org.jumpmind.db.platform.AbstractDatabasePlatform

allowsUniqueIndexDuplicatesWithNulls, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterDatabase, alterDatabase, alterTables, alterTables, appendString, checkSymTablePermissions, cleanNumber, cleanTextForTextBasedColumns, createArray, createDatabase, createDmlStatement, createDmlStatement, createDmlStatement, createDmlStatement, createTables, dropDatabase, dropTables, getAlterSymTablePermission, getClearCacheModelTimeoutInMs, getCreateSymFunctionPermission, getCreateSymRoutinePermission, getCreateSymTablePermission, getCsvStringValue, getDatabaseInfo, getDateTimeStringValue, getDdlBuilder, getDdlReader, getDeleteSql, getDropSymTablePermission, getDropSymTriggerPermission, getLobColumns, getObjectValue, getObjectValues, getObjectValues, getObjectValues, getObjectValues, getPermissionTableDefinition, getSqlScriptReplacementTokens, getStringValues, getTableFromCache, getTableFromCache, getTimestampStringValue, getTimestampTzStringValue, getTimeZone, getTruncateSql, hasMatchingPlatform, isBlob, isClob, isLob, isMetadataIgnoreCase, isStoresLowerCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, isUseMultiThreadSyncTriggers, logFailedResults, makeAllColumnsPrimaryKeys, makePlatformSpecific, massageForObjectDoesNotExist, parseBigDecimal, parseBigInteger, parseDate, parseFloat, parseInteger, parseQualifiedTableName, parseTimestamp, prefixColumnNames, prefixDatabase, prefixForeignKeys, prefixIndexes, readDatabase, readDatabaseFromXml, readDatabaseFromXml, readFromDatabase, readTableFromDatabase, readTableFromDatabase, readTableFromDatabaseAllowException, resetCachedTableModel, scrubSql, setClearCacheModelTimeoutInMs, setMetadataIgnoreCase, supportsMultiThreadedTransactions, supportsParametersInSelect, supportsTransactions

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

Oracle122DatabasePlatform

public Oracle122DatabasePlatform(DataSource dataSource,
 SqlTemplateSettings settings)

Method Details

createDdlBuilder

protected OracleDdlBuilder createDdlBuilder()

Overrides:

createDdlBuilder in class OracleDatabasePlatform

getName

public String getName()

Specified by:

getName in interface IDatabasePlatform

Overrides:

getName in class OracleDatabasePlatform

Returns:

a constant that represents this database type from DatabaseNamesConstants

See Also:

• DatabaseNamesConstants

supportsLimitOffset

public boolean supportsLimitOffset()

Specified by:

supportsLimitOffset in interface IDatabasePlatform

Overrides:

supportsLimitOffset in class OracleDatabasePlatform

massageForLimitOffset

public String massageForLimitOffset(String sql,
 int limit,
 int offset)

Specified by:

massageForLimitOffset in interface IDatabasePlatform

Overrides:

massageForLimitOffset in class OracleDatabasePlatform