org.fastnate.generator.dialect

Class MsSqlDialect

java.lang.Object

org.fastnate.generator.dialect.GeneratorDialect

org.fastnate.generator.dialect.MsSqlDialect

public class MsSqlDialect
extends GeneratorDialect

Handles MS SQL specific conversions.

Author:

Tobias Liefke

See Also:

MS SQL - MS Technet

Field Summary

Fields inherited from class org.fastnate.generator.dialect.GeneratorDialect

NOW

Constructor Summary

Constructors

Constructor and Description
MsSqlDialect()

Method Summary

Modifier and Type	Method and Description
protected void	addQuotedCharacter(StringBuilder result, char c) Adds a quoted character to the result string buffer.
String	buildCurrentSequenceValue(String sequence, int incrementSize, boolean firstCall) Builds the SQL expression that is used for referencing the current value of the given sequence.
String	buildNextSequenceValue(String sequence, int incrementSize) Builds the SQL expression resp. statement that is used for creating the next value of the given sequence.
protected String	convertTemporalValue(Date value) Builds the SQL expression for a date / time / timestamp.
String	convertTemporalValue(Date value, javax.persistence.TemporalType type) Converts a date to an appropriate SQL expression.
String	createBlobExpression(byte[] blob) Converts the given byte array to an SQL expression for the current database.
String	getConcatOperator() The operator used to concat two Strings.
boolean	isEmulatingSequences() Indicates that tables are used in place of sequences, if GenerationType.SEQUENCE is defined for a GeneratedValue.
boolean	isSettingIdentityAllowed() Indicates if this dialect supports writing absolute values to an GenerationType.IDENTITY column.

Methods inherited from class org.fastnate.generator.dialect.GeneratorDialect

adjustNextIdentityValue, adjustNextSequenceValue, convertBooleanValue, convertNumberValue, convertToDatabaseDate, createAddDateExpression, createHexBlobExpression, getAutoGenerationType, getEmptyValuesExpression, getLetter, getOptionalTable, isEmptyStringEqualToNull, isFastInTransaction, isIdentitySupported, isNextSequenceValueInInsertSupported, isSelectFromSameTableInInsertSupported, isSequenceInWhereSupported, isSequenceSupported, quoteString, truncateTable

Methods inherited from class java.lang.Object

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

Constructor Detail

MsSqlDialect

public MsSqlDialect()

Method Detail

addQuotedCharacter

protected void addQuotedCharacter(StringBuilder result,
                                  char c)

Description copied from class: GeneratorDialect

Adds a quoted character to the result string buffer.

Overrides:

addQuotedCharacter in class GeneratorDialect

Parameters:

result - the current result buffer

c - the character to quote

buildCurrentSequenceValue

public String buildCurrentSequenceValue(String sequence,
                                        int incrementSize,
                                        boolean firstCall)

Description copied from class: GeneratorDialect

Builds the SQL expression that is used for referencing the current value of the given sequence.

Overrides:

buildCurrentSequenceValue in class GeneratorDialect

Parameters:

sequence - the fully qualified name of the sequence

incrementSize - the expected incrementSize, as given in the schema - used by some dialects to ensure that exactly that inrement is used

firstCall - indicates that the sequence was not updated before in this session - we may need to use a different approach to get the current value

Returns:

the SQL expression to use in statement

buildNextSequenceValue

public String buildNextSequenceValue(String sequence,
                                     int incrementSize)

Description copied from class: GeneratorDialect

Builds the SQL expression resp. statement that is used for creating the next value of the given sequence. Depending on GeneratorDialect.isNextSequenceValueInInsertSupported() this will return an expression or a statement.

Overrides:

buildNextSequenceValue in class GeneratorDialect

Parameters:

sequence - the fully qualified name of the sequence

incrementSize - the expected incrementSize, as given in the schema - used by some dialects to ensure that exactly that inrement is used

Returns:

the SQL to use in resp. before the insert / update statement

convertTemporalValue

protected String convertTemporalValue(Date value)

Description copied from class: GeneratorDialect

Builds the SQL expression for a date / time / timestamp.

Overrides:

convertTemporalValue in class GeneratorDialect

Parameters:

value - the date, already converted to one from javax.sql.*

Returns:

the SQL expression representing the value.

convertTemporalValue

public String convertTemporalValue(Date value,
                                   javax.persistence.TemporalType type)

Description copied from class: GeneratorDialect

Converts a date to an appropriate SQL expression.

Overrides:

convertTemporalValue in class GeneratorDialect

Parameters:

value - the timestamp value

type - the type

Returns:

SQL expression representing the value.

createBlobExpression

public String createBlobExpression(byte[] blob)

Description copied from class: GeneratorDialect

Converts the given byte array to an SQL expression for the current database.

Overrides:

createBlobExpression in class GeneratorDialect

Parameters:

blob - the bytes to convert

Returns:

the expression for the bytes

getConcatOperator

public String getConcatOperator()

Description copied from class: GeneratorDialect

The operator used to concat two Strings.

Overrides:

getConcatOperator in class GeneratorDialect

Returns:

the operator to use for "string1 OPERATOR string2" (including any necessary whitespace) or null if this dialect does not have such an operator

isEmulatingSequences

public boolean isEmulatingSequences()

Description copied from class: GeneratorDialect

Indicates that tables are used in place of sequences, if GenerationType.SEQUENCE is defined for a GeneratedValue.

Overrides:

isEmulatingSequences in class GeneratorDialect

Returns:

true if sequences are emulated with tables, false if sequences are supported

isSettingIdentityAllowed

public boolean isSettingIdentityAllowed()

Description copied from class: GeneratorDialect

Indicates if this dialect supports writing absolute values to an GenerationType.IDENTITY column.

Overrides:

isSettingIdentityAllowed in class GeneratorDialect

Returns:

true if we can write fix values for identity columns