com.j256.ormlite.jdbc.db

Class SqlServerDatabaseType

java.lang.Object

com.j256.ormlite.db.BaseDatabaseType

com.j256.ormlite.jdbc.db.SqlServerDatabaseType

All Implemented Interfaces:

com.j256.ormlite.db.DatabaseType

Direct Known Subclasses:

SqlServerJtdsDatabaseType

public class SqlServerDatabaseType
extends com.j256.ormlite.db.BaseDatabaseType

Microsoft SQL server database type information used to create the tables, etc..

WARNING: I have not tested this unfortunately because of a lack of permanent access to a MSSQL instance.

Author:

graywatson

Field Summary

Fields inherited from class com.j256.ormlite.db.BaseDatabaseType

DEFAULT_SEQUENCE_SUFFIX, driver, logger

Constructor Summary

Constructors

Constructor and Description
SqlServerDatabaseType()

Method Summary

Modifier and Type	Method and Description
protected void	appendBooleanType(StringBuilder sb, com.j256.ormlite.field.FieldType fieldType, int fieldWidth)
protected void	appendByteArrayType(StringBuilder sb, com.j256.ormlite.field.FieldType fieldType, int fieldWidth)
protected void	appendByteType(StringBuilder sb, com.j256.ormlite.field.FieldType fieldType, int fieldWidth)
protected void	appendDateType(StringBuilder sb, com.j256.ormlite.field.FieldType fieldType, int fieldWidth)
void	appendDeleteLimitValue(StringBuilder sb, long limit)
void	appendEscapedEntityName(StringBuilder sb, String name)
void	appendInsertNoColumns(StringBuilder sb)
void	appendLimitValue(StringBuilder sb, long limit, Long offset)
protected void	appendSerializableType(StringBuilder sb, com.j256.ormlite.field.FieldType fieldType, int fieldWidth)
void	appendUpdateLimitValue(StringBuilder sb, long limit)
protected void	appendUuidNativeType(StringBuilder sb, com.j256.ormlite.field.FieldType fieldType, int fieldWidth)
protected void	configureGeneratedId(String tableName, StringBuilder sb, com.j256.ormlite.field.FieldType fieldType, List<String> statementsBefore, List<String> statementsAfter, List<String> additionalArgs, List<String> queriesAfter)
String	getDatabaseName()
protected String[]	getDriverClassNames()
com.j256.ormlite.field.FieldConverter	getFieldConverter(com.j256.ormlite.field.DataPersister dataType, com.j256.ormlite.field.FieldType fieldType)
boolean	isAllowGeneratedIdInsertSupported()
boolean	isCreateTableReturnsNegative()
boolean	isDatabaseUrlThisType(String url, String dbTypePart)
boolean	isLimitAfterDeleteSupported()
boolean	isLimitAfterSelect()
boolean	isLimitAfterUpdateSupported()
boolean	isOffsetSqlSupported()
boolean	isTruncateSupported()

Methods inherited from class com.j256.ormlite.db.BaseDatabaseType

addPrimaryKeySql, addUniqueComboSql, appendBigDecimalNumericType, appendCharType, appendColumnArg, appendCreateSchemaSuffix, appendCreateTableSuffix, appendDoubleType, appendEscapedWord, appendFloatType, appendIntegerType, appendLongStringType, appendLongType, appendOffsetValue, appendSelectNextValFromSequence, appendShortType, appendStringType, configureGeneratedIdSequence, configureId, downCaseString, dropColumnArg, extractDatabaseTableConfig, generatedIdSqlAtEnd, generateIdSequenceName, getCommentLinePrefix, getDataPersister, getPingStatement, isBatchUseTransaction, isCreateIfNotExistsSupported, isCreateIndexIfNotExistsSupported, isCreateSchemaIfNotExistsSupported, isCreateSchemaReturnsNegative, isCreateSchemaReturnsZero, isCreateTableReturnsZero, isEntityNamesMustBeUpCase, isIdSequenceNeeded, isLimitDeleteAtEndSupported, isLimitSqlSupported, isLimitUpdateAtEndSupported, isNestedSavePointsSupported, isOffsetLimitArgument, isSelectSequenceBeforeInsert, isSequenceNamesMustBeLowerCase, isVarcharFieldWidthSupported, loadDriver, setDriver, upCaseEntityName, upCaseString

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlServerDatabaseType

public SqlServerDatabaseType()

Method Detail

isDatabaseUrlThisType

public boolean isDatabaseUrlThisType(String url,
                                     String dbTypePart)

getDriverClassNames

protected String[] getDriverClassNames()

Overrides:

getDriverClassNames in class com.j256.ormlite.db.BaseDatabaseType

getDatabaseName

public String getDatabaseName()

getFieldConverter

public com.j256.ormlite.field.FieldConverter getFieldConverter(com.j256.ormlite.field.DataPersister dataType,
                                                               com.j256.ormlite.field.FieldType fieldType)

Specified by:

getFieldConverter in interface com.j256.ormlite.db.DatabaseType

Overrides:

getFieldConverter in class com.j256.ormlite.db.BaseDatabaseType

appendUuidNativeType

protected void appendUuidNativeType(StringBuilder sb,
                                    com.j256.ormlite.field.FieldType fieldType,
                                    int fieldWidth)

Overrides:

appendUuidNativeType in class com.j256.ormlite.db.BaseDatabaseType

appendBooleanType

protected void appendBooleanType(StringBuilder sb,
                                 com.j256.ormlite.field.FieldType fieldType,
                                 int fieldWidth)

Overrides:

appendBooleanType in class com.j256.ormlite.db.BaseDatabaseType

appendByteType

protected void appendByteType(StringBuilder sb,
                              com.j256.ormlite.field.FieldType fieldType,
                              int fieldWidth)

Overrides:

appendByteType in class com.j256.ormlite.db.BaseDatabaseType

appendDateType

protected void appendDateType(StringBuilder sb,
                              com.j256.ormlite.field.FieldType fieldType,
                              int fieldWidth)

Overrides:

appendDateType in class com.j256.ormlite.db.BaseDatabaseType

appendByteArrayType

protected void appendByteArrayType(StringBuilder sb,
                                   com.j256.ormlite.field.FieldType fieldType,
                                   int fieldWidth)

Overrides:

appendByteArrayType in class com.j256.ormlite.db.BaseDatabaseType

appendSerializableType

protected void appendSerializableType(StringBuilder sb,
                                      com.j256.ormlite.field.FieldType fieldType,
                                      int fieldWidth)

Overrides:

appendSerializableType in class com.j256.ormlite.db.BaseDatabaseType

configureGeneratedId

protected void configureGeneratedId(String tableName,
                                    StringBuilder sb,
                                    com.j256.ormlite.field.FieldType fieldType,
                                    List<String> statementsBefore,
                                    List<String> statementsAfter,
                                    List<String> additionalArgs,
                                    List<String> queriesAfter)

Overrides:

configureGeneratedId in class com.j256.ormlite.db.BaseDatabaseType

appendEscapedEntityName

public void appendEscapedEntityName(StringBuilder sb,
                                    String name)

Specified by:

appendEscapedEntityName in interface com.j256.ormlite.db.DatabaseType

Overrides:

appendEscapedEntityName in class com.j256.ormlite.db.BaseDatabaseType

isLimitAfterSelect

public boolean isLimitAfterSelect()

Specified by:

isLimitAfterSelect in interface com.j256.ormlite.db.DatabaseType

Overrides:

isLimitAfterSelect in class com.j256.ormlite.db.BaseDatabaseType

isLimitAfterUpdateSupported

public boolean isLimitAfterUpdateSupported()

Specified by:

isLimitAfterUpdateSupported in interface com.j256.ormlite.db.DatabaseType

Overrides:

isLimitAfterUpdateSupported in class com.j256.ormlite.db.BaseDatabaseType

appendLimitValue

public void appendLimitValue(StringBuilder sb,
                             long limit,
                             Long offset)

Specified by:

appendLimitValue in interface com.j256.ormlite.db.DatabaseType

Overrides:

appendLimitValue in class com.j256.ormlite.db.BaseDatabaseType

appendUpdateLimitValue

public void appendUpdateLimitValue(StringBuilder sb,
                                   long limit)

Specified by:

appendUpdateLimitValue in interface com.j256.ormlite.db.DatabaseType

Overrides:

appendUpdateLimitValue in class com.j256.ormlite.db.BaseDatabaseType

isLimitAfterDeleteSupported

public boolean isLimitAfterDeleteSupported()

Specified by:

isLimitAfterDeleteSupported in interface com.j256.ormlite.db.DatabaseType

Overrides:

isLimitAfterDeleteSupported in class com.j256.ormlite.db.BaseDatabaseType

appendDeleteLimitValue

public void appendDeleteLimitValue(StringBuilder sb,
                                   long limit)

Specified by:

appendDeleteLimitValue in interface com.j256.ormlite.db.DatabaseType

Overrides:

appendDeleteLimitValue in class com.j256.ormlite.db.BaseDatabaseType

isOffsetSqlSupported

public boolean isOffsetSqlSupported()

Specified by:

isOffsetSqlSupported in interface com.j256.ormlite.db.DatabaseType

Overrides:

isOffsetSqlSupported in class com.j256.ormlite.db.BaseDatabaseType

isAllowGeneratedIdInsertSupported

public boolean isAllowGeneratedIdInsertSupported()

Specified by:

isAllowGeneratedIdInsertSupported in interface com.j256.ormlite.db.DatabaseType

Overrides:

isAllowGeneratedIdInsertSupported in class com.j256.ormlite.db.BaseDatabaseType

isCreateTableReturnsNegative

public boolean isCreateTableReturnsNegative()

Specified by:

isCreateTableReturnsNegative in interface com.j256.ormlite.db.DatabaseType

Overrides:

isCreateTableReturnsNegative in class com.j256.ormlite.db.BaseDatabaseType

appendInsertNoColumns

public void appendInsertNoColumns(StringBuilder sb)

Specified by:

appendInsertNoColumns in interface com.j256.ormlite.db.DatabaseType

Overrides:

appendInsertNoColumns in class com.j256.ormlite.db.BaseDatabaseType

isTruncateSupported

public boolean isTruncateSupported()

Specified by:

isTruncateSupported in interface com.j256.ormlite.db.DatabaseType

Overrides:

isTruncateSupported in class com.j256.ormlite.db.BaseDatabaseType