Package org.jumpmind.db.platform

Class AbstractDatabasePlatform

java.lang.Object

org.jumpmind.db.platform.AbstractDatabasePlatform

All Implemented Interfaces:

IDatabasePlatform

Direct Known Subclasses:

AbstractJdbcDatabasePlatform, CassandraPlatform, KafkaPlatform

public abstract class AbstractDatabasePlatform
extends Object
implements IDatabasePlatform

Field Summary

Fields

Modifier and Type	Field	Description
protected long	clearCacheModelTimeoutInMs
protected IDdlBuilder	ddlBuilder
protected IDdlReader	ddlReader
protected String	defaultCatalog
protected String	defaultSchema
protected final org.slf4j.Logger	log
protected boolean	metadataIgnoreCase
protected static final String	MODEL_DEFAULT_NAME
protected static final String	PERMISSION_TEST_TABLE_NAME
static final String	REQUIRED_FIELD_NULL_SUBSTITUTE
protected SqlTemplateSettings	settings
protected String	sourceNodeId
protected Boolean	storesLowerCaseIdentifiers
protected Boolean	storesMixedCaseIdentifiers
protected Boolean	storesUpperCaseIdentifiers
protected Boolean	supportsMultiThreadedTransactions
protected Boolean	supportsTransactions
protected boolean	supportsTruncate
protected Map<String,Table>	tableCache
protected boolean	useMultiThreadSyncTriggers
static final String	ZERO_DATE_STRING

Constructor Summary

Constructors

Constructor	Description
AbstractDatabasePlatform(SqlTemplateSettings settings)

Method Summary

Modifier and Type	Method	Description
boolean	allowsUniqueIndexDuplicatesWithNulls()
String	alterCaseToMatchDatabaseDefaultCase(String value)
String[]	alterCaseToMatchDatabaseDefaultCase(String[] values)
void	alterCaseToMatchDatabaseDefaultCase(Database database)
void	alterCaseToMatchDatabaseDefaultCase(Table table)
void	alterCaseToMatchDatabaseDefaultCase(Table... tables)
void	alterDatabase(Database desiredDatabase, boolean continueOnError)
void	alterDatabase(Database desiredDatabase, boolean continueOnError, IAlterDatabaseInterceptor[] interceptors)
void	alterTables(boolean continueOnError, Table... desiredTables)
void	alterTables(boolean continueOnError, IAlterDatabaseInterceptor[] interceptors, Table... desiredTables)
protected void	appendString(StringBuilder sb, String value)
boolean	canColumnBeUsedInWhereClause(Column column)
List<PermissionResult>	checkSymTablePermissions(PermissionType... permissionTypes)
protected String	cleanNumber(String value)
protected String	cleanTextForTextBasedColumns(String text)
protected Array	createArray(Column column, String value)
void	createDatabase(Database targetDatabase, boolean dropTablesFirst, boolean continueOnError)
DmlStatement	createDmlStatement(DmlStatement.DmlType dmlType, String catalogName, String schemaName, String tableName, Column[] keys, Column[] columns, boolean[] nullKeyValues, String textColumnExpression)
DmlStatement	createDmlStatement(DmlStatement.DmlType dmlType, String catalogName, String schemaName, String tableName, Column[] keys, Column[] columns, boolean[] nullKeyValues, String textColumnExpression, boolean namedParameters)
DmlStatement	createDmlStatement(DmlStatement.DmlType dmlType, Table table, String textColumnExpression)
DmlStatement	createDmlStatement(DmlStatementOptions options)
void	createTables(boolean dropTablesFirst, boolean continueOnError, Table... tables)
void	dropDatabase(Database database, boolean continueOnError)
void	dropTables(boolean continueOnError, Table... tables)
protected PermissionResult	getAlterSymTablePermission(Database database)
String	getCharSetName()
long	getClearCacheModelTimeoutInMs()
protected PermissionResult	getCreateSymFunctionPermission()
protected PermissionResult	getCreateSymRoutinePermission()
protected PermissionResult	getCreateSymTablePermission(Database database)
protected PermissionResult	getCreateSymTriggerPermission()
String	getCsvStringValue(BinaryEncoding encoding, Column[] metaData, Row row, boolean[] isColumnPositionUsingTemplate)
DatabaseInfo	getDatabaseInfo()	Returns information about this platform.
protected String	getDateTimeStringValue(String name, int type, Row row, boolean useVariableDates)
IDdlBuilder	getDdlBuilder()	Returns a new ddl builder for the this platform.
IDdlReader	getDdlReader()	Returns the ddl reader (which reads a database model from a live database) for this platform.
String	getDeleteSql(Table table)
protected PermissionResult	getDropSymTablePermission()
protected PermissionResult	getDropSymTriggerPermission()
long	getEstimatedRowCount(Table table)
protected PermissionResult	getExecuteSymPermission()
List<Column>	getLobColumns(Table table)
PermissionResult	getLogMinePermission()
protected Object	getObjectValue(String value, Column column, BinaryEncoding encoding, boolean useVariableDates, boolean fitToColumn)
Object[]	getObjectValues(BinaryEncoding encoding, String[] values, Column[] orderedMetaData)
Object[]	getObjectValues(BinaryEncoding encoding, String[] values, Column[] orderedMetaData, boolean useVariableDates, boolean fitToColumn)
Object[]	getObjectValues(BinaryEncoding encoding, Table table, String[] columnNames, String[] values)
Object[]	getObjectValues(BinaryEncoding encoding, Table table, String[] columnNames, String[] values, boolean useVariableDates, boolean fitToColumn)
protected Table	getPermissionTableDefinition()
String	getSliceTableSql(String columnName, int sliceNum, int totalSlices)
Map<String,String>	getSqlScriptReplacementTokens()
abstract ISqlTemplate	getSqlTemplate()
abstract ISqlTemplate	getSqlTemplateDirty()
String[]	getStringValues(BinaryEncoding encoding, Column[] metaData, Row row, boolean useVariableDates, boolean indexByPosition)
Table	getTableFromCache(String tableName, boolean forceReread)
Table	getTableFromCache(String catalogName, String schemaName, String tableName, boolean forceReread)
protected String	getTimestampStringValue(String name, int type, Row row, boolean useVariableDates)
protected String	getTimestampTzStringValue(String name, int type, Row row, boolean useVariableDates)
TimeZone	getTimeZone(String value)
List<Transaction>	getTransactions()
String	getTruncateSql(Table table)
boolean	hasMatchingPlatform(Database db)
boolean	isBlob(int type)
boolean	isClob(int type)
boolean	isLob(int type)
boolean	isMetadataIgnoreCase()
boolean	isStoresLowerCaseIdentifiers()
boolean	isStoresMixedCaseQuotedIdentifiers()
boolean	isStoresUpperCaseIdentifiers()
boolean	isUseMultiThreadSyncTriggers()
protected void	logFailedResults(List<PermissionResult> results)
Table	makeAllColumnsPrimaryKeys(Table table)
void	makePlatformSpecific(Database database)
String	massageForLimitOffset(String sql, int limit, int offset)
String	massageForObjectAlreadyExists(String sql)
String	massageForObjectDoesNotExist(String sql)
protected Object	parseBigDecimal(String value)
protected Object	parseBigInteger(String value)
Date	parseDate(int type, String value, boolean useVariableDates)
protected Object	parseFloat(String value)
protected Object	parseInteger(String value)
Map<String,String>	parseQualifiedTableName(String tableName)
Date	parseTimestamp(int type, String value)
protected void	prefixColumnNames(Table table, boolean storesUpperCaseIdentifiers)
void	prefixDatabase(String prefix, Database targetTables)
protected void	prefixForeignKeys(Table table, String tablePrefix, boolean storesUpperCaseIdentifiers)
protected void	prefixIndexes(Table table, String tablePrefix, boolean storesUpperCaseIdentifiers)
Database	readDatabase(String catalog, String schema, String[] tableTypes)	Reads the database model from the live database to which the given connection is pointing.
Database	readDatabaseFromXml(InputStream is, boolean alterCaseToMatchDatabaseDefaultCase)
Database	readDatabaseFromXml(String filePath, boolean alterCaseToMatchDatabaseDefaultCase)
Database	readFromDatabase(Table... tables)
Table	readTableFromDatabase(String catalogName, String schemaName, String tableName)
Table	readTableFromDatabase(ISqlTransaction transaction, String catalogName, String schemaName, String tableName)
protected Table	readTableFromDatabaseAllowException(String catalogName, String schemaName, String tableName)
void	resetCachedTableModel()
String	scrubSql(String sql)
void	setClearCacheModelTimeoutInMs(long clearCacheModelTimeoutInMs)	The amount of time table metadata will be cached when using IDatabasePlatform#getT
void	setMetadataIgnoreCase(boolean metadataIgnoreCase)
boolean	supportsLimitOffset()
boolean	supportsMultiThreadedTransactions()
boolean	supportsParametersInSelect()
boolean	supportsSliceTables()
boolean	supportsTransactions()

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.jumpmind.db.platform.IDatabasePlatform

getDataSource, getDefaultCatalog, getDefaultSchema, getName

Field Details

log

protected final org.slf4j.Logger log

REQUIRED_FIELD_NULL_SUBSTITUTE

public static final String REQUIRED_FIELD_NULL_SUBSTITUTE

See Also:

• Constant Field Values

ZERO_DATE_STRING

public static final String ZERO_DATE_STRING

See Also:

• Constant Field Values

MODEL_DEFAULT_NAME

protected static final String MODEL_DEFAULT_NAME

See Also:

• Constant Field Values

PERMISSION_TEST_TABLE_NAME

protected static final String PERMISSION_TEST_TABLE_NAME

See Also:

• Constant Field Values

ddlReader

protected IDdlReader ddlReader

ddlBuilder

protected IDdlBuilder ddlBuilder

tableCache

protected Map<String,Table> tableCache

clearCacheModelTimeoutInMs

protected long clearCacheModelTimeoutInMs

defaultSchema

protected String defaultSchema

defaultCatalog

protected String defaultCatalog

storesUpperCaseIdentifiers

protected Boolean storesUpperCaseIdentifiers

storesLowerCaseIdentifiers

protected Boolean storesLowerCaseIdentifiers

storesMixedCaseIdentifiers

protected Boolean storesMixedCaseIdentifiers

metadataIgnoreCase

protected boolean metadataIgnoreCase

useMultiThreadSyncTriggers

protected boolean useMultiThreadSyncTriggers

settings

protected SqlTemplateSettings settings

supportsTransactions

protected Boolean supportsTransactions

supportsMultiThreadedTransactions

protected Boolean supportsMultiThreadedTransactions

supportsTruncate

protected boolean supportsTruncate

sourceNodeId

protected String sourceNodeId

Constructor Details

AbstractDatabasePlatform

public AbstractDatabasePlatform(SqlTemplateSettings settings)

Method Details

getDatabaseInfo

public DatabaseInfo getDatabaseInfo()

Description copied from interface: IDatabasePlatform

Returns information about this platform.

Specified by:

getDatabaseInfo in interface IDatabasePlatform

Returns:

The info object

getSqlTemplate

public abstract ISqlTemplate getSqlTemplate()

Specified by:

getSqlTemplate in interface IDatabasePlatform

getSqlTemplateDirty

public abstract ISqlTemplate getSqlTemplateDirty()

Specified by:

getSqlTemplateDirty in interface IDatabasePlatform

createDmlStatement

public DmlStatement createDmlStatement(DmlStatement.DmlType dmlType,
 Table table,
 String textColumnExpression)

Specified by:

createDmlStatement in interface IDatabasePlatform

createDmlStatement

public DmlStatement createDmlStatement(DmlStatement.DmlType dmlType,
 String catalogName,
 String schemaName,
 String tableName,
 Column[] keys,
 Column[] columns,
 boolean[] nullKeyValues,
 String textColumnExpression)

Specified by:

createDmlStatement in interface IDatabasePlatform

createDmlStatement

public DmlStatement createDmlStatement(DmlStatement.DmlType dmlType,
 String catalogName,
 String schemaName,
 String tableName,
 Column[] keys,
 Column[] columns,
 boolean[] nullKeyValues,
 String textColumnExpression,
 boolean namedParameters)

Specified by:

createDmlStatement in interface IDatabasePlatform

createDmlStatement

public DmlStatement createDmlStatement(DmlStatementOptions options)

Specified by:

createDmlStatement in interface IDatabasePlatform

getDdlReader

public IDdlReader getDdlReader()

Description copied from interface: IDatabasePlatform

Returns the ddl reader (which reads a database model from a live database) for this platform.

Specified by:

getDdlReader in interface IDatabasePlatform

Returns:

The model reader

getDdlBuilder

public IDdlBuilder getDdlBuilder()

Description copied from interface: IDatabasePlatform

Returns a new ddl builder for the this platform.

Specified by:

getDdlBuilder in interface IDatabasePlatform

setClearCacheModelTimeoutInMs

public void setClearCacheModelTimeoutInMs(long clearCacheModelTimeoutInMs)

Description copied from interface: IDatabasePlatform

The amount of time table metadata will be cached when using IDatabasePlatform#getT

Specified by:

setClearCacheModelTimeoutInMs in interface IDatabasePlatform

getClearCacheModelTimeoutInMs

public long getClearCacheModelTimeoutInMs()

Specified by:

getClearCacheModelTimeoutInMs in interface IDatabasePlatform

dropTables

public void dropTables(boolean continueOnError,
 Table... tables)

Specified by:

dropTables in interface IDatabasePlatform

dropDatabase

public void dropDatabase(Database database,
 boolean continueOnError)

Specified by:

dropDatabase in interface IDatabasePlatform

createTables

public void createTables(boolean dropTablesFirst,
 boolean continueOnError,
 Table... tables)

Specified by:

createTables in interface IDatabasePlatform

createDatabase

public void createDatabase(Database targetDatabase,
 boolean dropTablesFirst,
 boolean continueOnError)

Specified by:

createDatabase in interface IDatabasePlatform

alterDatabase

public void alterDatabase(Database desiredDatabase,
 boolean continueOnError,
 IAlterDatabaseInterceptor[] interceptors)

Specified by:

alterDatabase in interface IDatabasePlatform

alterDatabase

public void alterDatabase(Database desiredDatabase,
 boolean continueOnError)

Specified by:

alterDatabase in interface IDatabasePlatform

alterTables

public void alterTables(boolean continueOnError,
 Table... desiredTables)

Specified by:

alterTables in interface IDatabasePlatform

alterTables

public void alterTables(boolean continueOnError,
 IAlterDatabaseInterceptor[] interceptors,
 Table... desiredTables)

Specified by:

alterTables in interface IDatabasePlatform

readDatabase

public Database readDatabase(String catalog,
 String schema,
 String[] tableTypes)

Description copied from interface: IDatabasePlatform

Reads the database model from the live database to which the given connection is pointing.

Specified by:

readDatabase in interface IDatabasePlatform

readFromDatabase

public Database readFromDatabase(Table... tables)

Specified by:

readFromDatabase in interface IDatabasePlatform

readTableFromDatabase

public Table readTableFromDatabase(String catalogName,
 String schemaName,
 String tableName)

Specified by:

readTableFromDatabase in interface IDatabasePlatform

readTableFromDatabaseAllowException

protected Table readTableFromDatabaseAllowException(String catalogName,
 String schemaName,
 String tableName)

readTableFromDatabase

public Table readTableFromDatabase(ISqlTransaction transaction,
 String catalogName,
 String schemaName,
 String tableName)

Specified by:

readTableFromDatabase in interface IDatabasePlatform

resetCachedTableModel

public void resetCachedTableModel()

Specified by:

resetCachedTableModel in interface IDatabasePlatform

getTableFromCache

public Table getTableFromCache(String tableName,
 boolean forceReread)

Specified by:

getTableFromCache in interface IDatabasePlatform

getTableFromCache

public Table getTableFromCache(String catalogName,
 String schemaName,
 String tableName,
 boolean forceReread)

Specified by:

getTableFromCache in interface IDatabasePlatform

getObjectValues

public Object[] getObjectValues(BinaryEncoding encoding,
 Table table,
 String[] columnNames,
 String[] values)

Specified by:

getObjectValues in interface IDatabasePlatform

getObjectValues

public Object[] getObjectValues(BinaryEncoding encoding,
 Table table,
 String[] columnNames,
 String[] values,
 boolean useVariableDates,
 boolean fitToColumn)

Specified by:

getObjectValues in interface IDatabasePlatform

getObjectValues

public Object[] getObjectValues(BinaryEncoding encoding,
 String[] values,
 Column[] orderedMetaData)

Specified by:

getObjectValues in interface IDatabasePlatform

getObjectValues

public Object[] getObjectValues(BinaryEncoding encoding,
 String[] values,
 Column[] orderedMetaData,
 boolean useVariableDates,
 boolean fitToColumn)

Specified by:

getObjectValues in interface IDatabasePlatform

getObjectValue

protected Object getObjectValue(String value,
 Column column,
 BinaryEncoding encoding,
 boolean useVariableDates,
 boolean fitToColumn)
                         throws org.apache.commons.codec.DecoderException

Throws:

org.apache.commons.codec.DecoderException

parseFloat

protected Object parseFloat(String value)

parseBigDecimal

protected Object parseBigDecimal(String value)

parseBigInteger

protected Object parseBigInteger(String value)

parseInteger

protected Object parseInteger(String value)

cleanNumber

protected String cleanNumber(String value)

getStringValues

public String[] getStringValues(BinaryEncoding encoding,
 Column[] metaData,
 Row row,
 boolean useVariableDates,
 boolean indexByPosition)

Specified by:

getStringValues in interface IDatabasePlatform

getCsvStringValue

public String getCsvStringValue(BinaryEncoding encoding,
 Column[] metaData,
 Row row,
 boolean[] isColumnPositionUsingTemplate)

Specified by:

getCsvStringValue in interface IDatabasePlatform

appendString

protected void appendString(StringBuilder sb,
 String value)

getDateTimeStringValue

protected String getDateTimeStringValue(String name,
 int type,
 Row row,
 boolean useVariableDates)

getTimestampStringValue

protected String getTimestampStringValue(String name,
 int type,
 Row row,
 boolean useVariableDates)

getTimestampTzStringValue

protected String getTimestampTzStringValue(String name,
 int type,
 Row row,
 boolean useVariableDates)

getSqlScriptReplacementTokens

public Map<String,String> getSqlScriptReplacementTokens()

Specified by:

getSqlScriptReplacementTokens in interface IDatabasePlatform

scrubSql

public String scrubSql(String sql)

Specified by:

scrubSql in interface IDatabasePlatform

createArray

protected Array createArray(Column column,
 String value)

cleanTextForTextBasedColumns

protected String cleanTextForTextBasedColumns(String text)

parseDate

public Date parseDate(int type,
 String value,
 boolean useVariableDates)

Specified by:

parseDate in interface IDatabasePlatform

parseQualifiedTableName

public Map<String,String> parseQualifiedTableName(String tableName)

Specified by:

parseQualifiedTableName in interface IDatabasePlatform

makeAllColumnsPrimaryKeys

public Table makeAllColumnsPrimaryKeys(Table table)

Specified by:

makeAllColumnsPrimaryKeys in interface IDatabasePlatform

isLob

public boolean isLob(int type)

Specified by:

isLob in interface IDatabasePlatform

isClob

public boolean isClob(int type)

Specified by:

isClob in interface IDatabasePlatform

isBlob

public boolean isBlob(int type)

Specified by:

isBlob in interface IDatabasePlatform

getLobColumns

public List<Column> getLobColumns(Table table)

Specified by:

getLobColumns in interface IDatabasePlatform

setMetadataIgnoreCase

public void setMetadataIgnoreCase(boolean metadataIgnoreCase)

Specified by:

setMetadataIgnoreCase in interface IDatabasePlatform

isMetadataIgnoreCase

public boolean isMetadataIgnoreCase()

Specified by:

isMetadataIgnoreCase in interface IDatabasePlatform

isStoresLowerCaseIdentifiers

public boolean isStoresLowerCaseIdentifiers()

Specified by:

isStoresLowerCaseIdentifiers in interface IDatabasePlatform

isStoresMixedCaseQuotedIdentifiers

public boolean isStoresMixedCaseQuotedIdentifiers()

Specified by:

isStoresMixedCaseQuotedIdentifiers in interface IDatabasePlatform

isStoresUpperCaseIdentifiers

public boolean isStoresUpperCaseIdentifiers()

Specified by:

isStoresUpperCaseIdentifiers in interface IDatabasePlatform

readDatabaseFromXml

public Database readDatabaseFromXml(String filePath,
 boolean alterCaseToMatchDatabaseDefaultCase)

Specified by:

readDatabaseFromXml in interface IDatabasePlatform

prefixDatabase

public void prefixDatabase(String prefix,
 Database targetTables)

Specified by:

prefixDatabase in interface IDatabasePlatform

prefixColumnNames

protected void prefixColumnNames(Table table,
 boolean storesUpperCaseIdentifiers)

prefixForeignKeys

protected void prefixForeignKeys(Table table,
 String tablePrefix,
 boolean storesUpperCaseIdentifiers)
                          throws CloneNotSupportedException

Throws:

CloneNotSupportedException

prefixIndexes

protected void prefixIndexes(Table table,
 String tablePrefix,
 boolean storesUpperCaseIdentifiers)
                      throws CloneNotSupportedException

Throws:

CloneNotSupportedException

alterCaseToMatchDatabaseDefaultCase

public void alterCaseToMatchDatabaseDefaultCase(Database database)

Specified by:

alterCaseToMatchDatabaseDefaultCase in interface IDatabasePlatform

alterCaseToMatchDatabaseDefaultCase

public String[] alterCaseToMatchDatabaseDefaultCase(String[] values)

Specified by:

alterCaseToMatchDatabaseDefaultCase in interface IDatabasePlatform

alterCaseToMatchDatabaseDefaultCase

public String alterCaseToMatchDatabaseDefaultCase(String value)

Specified by:

alterCaseToMatchDatabaseDefaultCase in interface IDatabasePlatform

alterCaseToMatchDatabaseDefaultCase

public void alterCaseToMatchDatabaseDefaultCase(Table... tables)

Specified by:

alterCaseToMatchDatabaseDefaultCase in interface IDatabasePlatform

alterCaseToMatchDatabaseDefaultCase

public void alterCaseToMatchDatabaseDefaultCase(Table table)

Specified by:

alterCaseToMatchDatabaseDefaultCase in interface IDatabasePlatform

readDatabaseFromXml

public Database readDatabaseFromXml(InputStream is,
 boolean alterCaseToMatchDatabaseDefaultCase)

Specified by:

readDatabaseFromXml in interface IDatabasePlatform

canColumnBeUsedInWhereClause

public boolean canColumnBeUsedInWhereClause(Column column)

Specified by:

canColumnBeUsedInWhereClause in interface IDatabasePlatform

parseTimestamp

public Date parseTimestamp(int type,
 String value)

getTimeZone

public TimeZone getTimeZone(String value)

makePlatformSpecific

public void makePlatformSpecific(Database database)

Specified by:

makePlatformSpecific in interface IDatabasePlatform

hasMatchingPlatform

public boolean hasMatchingPlatform(Database db)

Specified by:

hasMatchingPlatform in interface IDatabasePlatform

checkSymTablePermissions

public List<PermissionResult> checkSymTablePermissions(PermissionType... permissionTypes)

Specified by:

checkSymTablePermissions in interface IDatabasePlatform

logFailedResults

protected void logFailedResults(List<PermissionResult> results)

getPermissionTableDefinition

protected Table getPermissionTableDefinition()

getCreateSymTablePermission

protected PermissionResult getCreateSymTablePermission(Database database)

getDropSymTablePermission

protected PermissionResult getDropSymTablePermission()

getAlterSymTablePermission

protected PermissionResult getAlterSymTablePermission(Database database)

getDropSymTriggerPermission

protected PermissionResult getDropSymTriggerPermission()

getCreateSymTriggerPermission

protected PermissionResult getCreateSymTriggerPermission()

getExecuteSymPermission

protected PermissionResult getExecuteSymPermission()

getCreateSymRoutinePermission

protected PermissionResult getCreateSymRoutinePermission()

getCreateSymFunctionPermission

protected PermissionResult getCreateSymFunctionPermission()

getLogMinePermission

public PermissionResult getLogMinePermission()

Specified by:

getLogMinePermission in interface IDatabasePlatform

isUseMultiThreadSyncTriggers

public boolean isUseMultiThreadSyncTriggers()

Specified by:

isUseMultiThreadSyncTriggers in interface IDatabasePlatform

supportsTransactions

public boolean supportsTransactions()

Specified by:

supportsTransactions in interface IDatabasePlatform

supportsMultiThreadedTransactions

public boolean supportsMultiThreadedTransactions()

Specified by:

supportsMultiThreadedTransactions in interface IDatabasePlatform

getEstimatedRowCount

public long getEstimatedRowCount(Table table)

Specified by:

getEstimatedRowCount in interface IDatabasePlatform

getTruncateSql

public String getTruncateSql(Table table)

Specified by:

getTruncateSql in interface IDatabasePlatform

getDeleteSql

public String getDeleteSql(Table table)

Specified by:

getDeleteSql in interface IDatabasePlatform

getTransactions

public List<Transaction> getTransactions()

Specified by:

getTransactions in interface IDatabasePlatform

supportsLimitOffset

public boolean supportsLimitOffset()

Specified by:

supportsLimitOffset in interface IDatabasePlatform

massageForLimitOffset

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

Specified by:

massageForLimitOffset in interface IDatabasePlatform

massageForObjectAlreadyExists

public String massageForObjectAlreadyExists(String sql)

Specified by:

massageForObjectAlreadyExists in interface IDatabasePlatform

massageForObjectDoesNotExist

public String massageForObjectDoesNotExist(String sql)

Specified by:

massageForObjectDoesNotExist in interface IDatabasePlatform

supportsSliceTables

public boolean supportsSliceTables()

Specified by:

supportsSliceTables in interface IDatabasePlatform

getSliceTableSql

public String getSliceTableSql(String columnName,
 int sliceNum,
 int totalSlices)

Specified by:

getSliceTableSql in interface IDatabasePlatform

getCharSetName

public String getCharSetName()

Specified by:

getCharSetName in interface IDatabasePlatform

supportsParametersInSelect

public boolean supportsParametersInSelect()

Specified by:

supportsParametersInSelect in interface IDatabasePlatform

allowsUniqueIndexDuplicatesWithNulls

public boolean allowsUniqueIndexDuplicatesWithNulls()

Specified by:

allowsUniqueIndexDuplicatesWithNulls in interface IDatabasePlatform