Package org.jumpmind.db.platform.mssql

Class MsSql2000DatabasePlatform

java.lang.Object

org.jumpmind.db.platform.AbstractDatabasePlatform

org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

org.jumpmind.db.platform.mssql.MsSql2000DatabasePlatform

All Implemented Interfaces:

IDatabasePlatform

Direct Known Subclasses:

MsSql2005DatabasePlatform

public class MsSql2000DatabasePlatform
extends AbstractJdbcDatabasePlatform

Field Summary

Fields

Modifier and Type	Field	Description
static final String	JDBC_DRIVER
static final String	JDBC_SUBPROTOCOL

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

dataSource, sqlTemplate, sqlTemplateDirty

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

clearCacheModelTimeoutInMs, databaseVersion, 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
MsSql2000DatabasePlatform(DataSource dataSource, SqlTemplateSettings settings)

Method Summary

Modifier and Type	Method	Description
boolean	allowsUniqueIndexDuplicatesWithNulls()
boolean	canColumnBeUsedInWhereClause(Column column)
protected IDdlBuilder	createDdlBuilder()
protected MsSqlDdlReader	createDdlReader()
protected MsSqlJdbcSqlTemplate	createSqlTemplate()
PermissionResult	getCreateSymFunctionPermission()
PermissionResult	getCreateSymTriggerPermission()
String	getDefaultCatalog()
String	getDefaultSchema()
int	getEngineEdition()
PermissionResult	getLogMinePermission()
String	getName()
boolean	isClob(Column column)
boolean	isText(Column column)	Helps detect SQL Server-specific NTEXT, TEXT column types.
boolean	isVarcharMax(Column column)	Helps detect SQL Server-specific NVARCHAR(MAX), VARCHAR(MAX) column types.
String	massageForObjectAlreadyExists(String sql)
String	massageForObjectDoesNotExist(String sql)
protected Object	parseFloat(String value)

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, getCharSetName, getClearCacheModelTimeoutInMs, getCreateSymRoutinePermission, getCreateSymTablePermission, getCsvStringValue, getDatabaseInfo, getDatabaseVersion, getDateTimeStringValue, getDdlBuilder, getDdlReader, getDeleteSql, getDropSymTablePermission, getDropSymTriggerPermission, getEstimatedRowCount, getExecuteSymPermission, getLobColumns, getObjectValue, getObjectValues, getObjectValues, getObjectValues, getObjectValues, getPermissionTableDefinition, getSliceTableSql, getSqlScriptReplacementTokens, getStringValues, getTableFromCache, getTableFromCache, getTimestampStringValue, getTimestampTzStringValue, getTimeZone, getTransactions, getTruncateSql, hasMatchingPlatform, isBlob, isLob, isMetadataIgnoreCase, isStoresLowerCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, isUseMultiThreadSyncTriggers, logFailedResults, makeAllColumnsPrimaryKeys, makePlatformSpecific, massageForLimitOffset, parseBigDecimal, parseBigInteger, parseBoolean, parseDate, parseInteger, parseQualifiedTableName, parseTimestamp, prefixColumnNames, prefixDatabase, prefixForeignKeys, prefixIndexes, readDatabase, readDatabaseFromXml, readDatabaseFromXml, readFromDatabase, readTableFromDatabase, readTableFromDatabase, readTableFromDatabaseAllowException, resetCachedTableModel, scrubSql, setClearCacheModelTimeoutInMs, setDatabaseVersion, setMetadataIgnoreCase, supportsLimitOffset, supportsMultiThreadedTransactions, supportsParametersInSelect, supportsSliceTables, supportsTransactions

Methods inherited from class java.lang.Object

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

Field Details

JDBC_DRIVER

public static final String JDBC_DRIVER

See Also:

• Constant Field Values

JDBC_SUBPROTOCOL

public static final String JDBC_SUBPROTOCOL

See Also:

• Constant Field Values

Constructor Details

MsSql2000DatabasePlatform

public MsSql2000DatabasePlatform(DataSource dataSource,
 SqlTemplateSettings settings)

Method Details

createDdlBuilder

protected IDdlBuilder createDdlBuilder()

Specified by:

createDdlBuilder in class AbstractJdbcDatabasePlatform

createDdlReader

protected MsSqlDdlReader createDdlReader()

Specified by:

createDdlReader in class AbstractJdbcDatabasePlatform

createSqlTemplate

protected MsSqlJdbcSqlTemplate createSqlTemplate()

Overrides:

createSqlTemplate in class AbstractJdbcDatabasePlatform

getName

public String getName()

Returns:

a constant that represents this database type from DatabaseNamesConstants

See Also:

• DatabaseNamesConstants

getDefaultCatalog

public String getDefaultCatalog()

getDefaultSchema

public String getDefaultSchema()

allowsUniqueIndexDuplicatesWithNulls

public boolean allowsUniqueIndexDuplicatesWithNulls()

Specified by:

allowsUniqueIndexDuplicatesWithNulls in interface IDatabasePlatform

Overrides:

allowsUniqueIndexDuplicatesWithNulls in class AbstractDatabasePlatform

isClob

public boolean isClob(Column column)

Specified by:

isClob in interface IDatabasePlatform

Overrides:

isClob in class AbstractDatabasePlatform

isVarcharMax

public boolean isVarcharMax(Column column)

Helps detect SQL Server-specific NVARCHAR(MAX), VARCHAR(MAX) column types. They should be treated as a regular string type, not as "large objects".

isText

public boolean isText(Column column)

Helps detect SQL Server-specific NTEXT, TEXT column types. They should be treated as "large objects".

canColumnBeUsedInWhereClause

public boolean canColumnBeUsedInWhereClause(Column column)

Specified by:

canColumnBeUsedInWhereClause in interface IDatabasePlatform

Overrides:

canColumnBeUsedInWhereClause in class AbstractDatabasePlatform

parseFloat

protected Object parseFloat(String value)

Overrides:

parseFloat in class AbstractDatabasePlatform

getCreateSymTriggerPermission

public PermissionResult getCreateSymTriggerPermission()

Overrides:

getCreateSymTriggerPermission in class AbstractDatabasePlatform

getCreateSymFunctionPermission

public PermissionResult getCreateSymFunctionPermission()

Overrides:

getCreateSymFunctionPermission in class AbstractDatabasePlatform

getLogMinePermission

public PermissionResult getLogMinePermission()

Specified by:

getLogMinePermission in interface IDatabasePlatform

Overrides:

getLogMinePermission in class AbstractDatabasePlatform

massageForObjectAlreadyExists

public String massageForObjectAlreadyExists(String sql)

Specified by:

massageForObjectAlreadyExists in interface IDatabasePlatform

Overrides:

massageForObjectAlreadyExists in class AbstractDatabasePlatform

massageForObjectDoesNotExist

public String massageForObjectDoesNotExist(String sql)

Specified by:

massageForObjectDoesNotExist in interface IDatabasePlatform

Overrides:

massageForObjectDoesNotExist in class AbstractDatabasePlatform

getEngineEdition

public int getEngineEdition()