Package org.jumpmind.db.platform.mssql

Class MsSql2005DatabasePlatform

java.lang.Object

org.jumpmind.db.platform.AbstractDatabasePlatform

org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

org.jumpmind.db.platform.mssql.MsSql2000DatabasePlatform

org.jumpmind.db.platform.mssql.MsSql2005DatabasePlatform

All Implemented Interfaces:

IDatabasePlatform

Direct Known Subclasses:

MsSql2008DatabasePlatform

public class MsSql2005DatabasePlatform
extends MsSql2000DatabasePlatform

Field Summary

Fields inherited from class org.jumpmind.db.platform.mssql.MsSql2000DatabasePlatform

JDBC_DRIVER, JDBC_SUBPROTOCOL

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
MsSql2005DatabasePlatform(DataSource dataSource, SqlTemplateSettings settings)

Method Summary

Modifier and Type	Method	Description
protected IDdlBuilder	createDdlBuilder()
String	getCharSetName()
String	getDefaultSchema()
String	getName()
String	getSliceTableSql(String columnName, int sliceNum, int totalSlices)
List<Transaction>	getTransactions()
String	massageForLimitOffset(String sql, int limit, int offset)
boolean	supportsLimitOffset()
boolean	supportsSliceTables()

Methods inherited from class org.jumpmind.db.platform.mssql.MsSql2000DatabasePlatform

allowsUniqueIndexDuplicatesWithNulls, canColumnBeUsedInWhereClause, createDdlReader, createSqlTemplate, getCreateSymFunctionPermission, getCreateSymTriggerPermission, getDefaultCatalog, getEngineEdition, getLogMinePermission, isClob, massageForObjectAlreadyExists, massageForObjectDoesNotExist, parseFloat

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

createSqlTemplateDirty, getDataSource, getSqlTemplate, getSqlTemplateDirty, resetDataSource

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

alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterDatabase, alterDatabase, alterTables, alterTables, appendString, checkSymTablePermissions, cleanNumber, cleanTextForTextBasedColumns, createArray, createDatabase, createDmlStatement, createDmlStatement, createDmlStatement, createDmlStatement, createTables, dropDatabase, dropTables, getAlterSymTablePermission, getClearCacheModelTimeoutInMs, getCreateSymRoutinePermission, getCreateSymTablePermission, getCsvStringValue, getDatabaseInfo, getDateTimeStringValue, getDdlBuilder, getDdlReader, getDeleteSql, getDropSymTablePermission, getDropSymTriggerPermission, getEstimatedRowCount, getExecuteSymPermission, getLobColumns, getObjectValue, getObjectValues, getObjectValues, getObjectValues, getObjectValues, getPermissionTableDefinition, getSqlScriptReplacementTokens, getStringValues, getTableFromCache, getTableFromCache, getTimestampStringValue, getTimestampTzStringValue, getTimeZone, getTruncateSql, hasMatchingPlatform, isBlob, isLob, isMetadataIgnoreCase, isStoresLowerCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, isUseMultiThreadSyncTriggers, logFailedResults, makeAllColumnsPrimaryKeys, makePlatformSpecific, parseBigDecimal, parseBigInteger, parseDate, 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

MsSql2005DatabasePlatform

public MsSql2005DatabasePlatform(DataSource dataSource,
 SqlTemplateSettings settings)

Method Details

createDdlBuilder

protected IDdlBuilder createDdlBuilder()

Overrides:

createDdlBuilder in class MsSql2000DatabasePlatform

getName

public String getName()

Specified by:

getName in interface IDatabasePlatform

Overrides:

getName in class MsSql2000DatabasePlatform

Returns:

a constant that represents this database type from DatabaseNamesConstants

See Also:

• DatabaseNamesConstants

getDefaultSchema

public String getDefaultSchema()

Specified by:

getDefaultSchema in interface IDatabasePlatform

Overrides:

getDefaultSchema in class MsSql2000DatabasePlatform

getTransactions

public List<Transaction> getTransactions()

Specified by:

getTransactions in interface IDatabasePlatform

Overrides:

getTransactions in class AbstractDatabasePlatform

supportsLimitOffset

public boolean supportsLimitOffset()

Specified by:

supportsLimitOffset in interface IDatabasePlatform

Overrides:

supportsLimitOffset in class AbstractDatabasePlatform

massageForLimitOffset

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

Specified by:

massageForLimitOffset in interface IDatabasePlatform

Overrides:

massageForLimitOffset in class AbstractDatabasePlatform

supportsSliceTables

public boolean supportsSliceTables()

Specified by:

supportsSliceTables in interface IDatabasePlatform

Overrides:

supportsSliceTables in class AbstractDatabasePlatform

getSliceTableSql

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

Specified by:

getSliceTableSql in interface IDatabasePlatform

Overrides:

getSliceTableSql in class AbstractDatabasePlatform

getCharSetName

public String getCharSetName()

Specified by:

getCharSetName in interface IDatabasePlatform

Overrides:

getCharSetName in class AbstractDatabasePlatform