org.javalite.activejdbc.dialects

Class MSSQLDialect

java.lang.Object

org.javalite.activejdbc.dialects.DefaultDialect

org.javalite.activejdbc.dialects.MSSQLDialect

All Implemented Interfaces:

Dialect

public class MSSQLDialect
extends DefaultDialect

Field Summary

Fields

Modifier and Type	Field and Description
protected Pattern	selectPattern

Fields inherited from class org.javalite.activejdbc.dialects.DefaultDialect

GROUP_BY_PATTERN, ORDER_BY_PATTERN

Constructor Summary

Constructors

Constructor and Description
MSSQLDialect()

Method Summary

Modifier and Type	Method and Description
protected void	appendDate(StringBuilder query, Date value)
protected void	appendTime(StringBuilder query, Time value)
protected void	appendTimestamp(StringBuilder query, Timestamp value)
String	formSelect(String tableName, String subQuery, List<String> orderBys, long limit, long offset) Generates adds limit, offset and order bys to a sub-query
Object	overrideDriverTypeConversion(MetaModel mm, String attributeName, Object value) TDS converts a number of important data types to String.

Methods inherited from class org.javalite.activejdbc.dialects.DefaultDialect

appendEmptyRow, appendOrderBy, appendQuestions, appendSelect, appendSubQuery, appendValue, deleteManyToManyAssociation, insert, insertManyToManyAssociation, insertParametrized, selectCount, selectCount, selectExists, selectManyToManyAssociation, selectStar, selectStar, selectStarParametrized, update

Methods inherited from class java.lang.Object

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

Field Detail

selectPattern

protected final Pattern selectPattern

Constructor Detail

MSSQLDialect

public MSSQLDialect()

Method Detail

formSelect

public String formSelect(String tableName,
                         String subQuery,
                         List<String> orderBys,
                         long limit,
                         long offset)

Generates adds limit, offset and order bys to a sub-query

Specified by:

formSelect in interface Dialect

Overrides:

formSelect in class DefaultDialect

Parameters:

tableName - name of table. If table name is null, then the subQuery parameter is considered to be a full query, and all that needs to be done is to add limit, offset and order bys

subQuery - sub-query or a full query

orderBys -

limit -

offset -

Returns:

query with

overrideDriverTypeConversion

public Object overrideDriverTypeConversion(MetaModel mm,
                                           String attributeName,
                                           Object value)

TDS converts a number of important data types to String. This isn't what we want, nor helpful. Here, we change them back.

Specified by:

overrideDriverTypeConversion in interface Dialect

Overrides:

overrideDriverTypeConversion in class DefaultDialect

appendDate

protected void appendDate(StringBuilder query,
                          Date value)

Overrides:

appendDate in class DefaultDialect

appendTime

protected void appendTime(StringBuilder query,
                          Time value)

Overrides:

appendTime in class DefaultDialect

appendTimestamp

protected void appendTimestamp(StringBuilder query,
                               Timestamp value)

Overrides:

appendTimestamp in class DefaultDialect