Package mondrian.spi.impl

Class MicrosoftSqlServerDialect

java.lang.Object

mondrian.spi.impl.JdbcDialectImpl

mondrian.spi.impl.MicrosoftSqlServerDialect

All Implemented Interfaces:

Dialect

public class MicrosoftSqlServerDialect
extends JdbcDialectImpl

Implementation of Dialect for the Microsoft SQL Server database.

Since:

Nov 23, 2008

Author:

jhyde

Nested Class Summary

Nested classes/interfaces inherited from interface mondrian.spi.Dialect

Dialect.DatabaseProduct, Dialect.Datatype

Field Summary

Fields

Modifier and Type	Field	Description
static final JdbcDialectFactory	FACTORY

Fields inherited from class mondrian.spi.impl.JdbcDialectImpl

databaseProduct, permitsSelectNotInGroupBy, productVersion

Constructor Summary

Constructors

Constructor	Description
MicrosoftSqlServerDialect(Connection connection)	Creates a MicrosoftSqlServerDialect.

Method Summary

Modifier and Type	Method	Description
String	generateInline(List<String> columnNames, List<String> columnTypes, List<String[]> valueList)	Generates a SQL statement to represent an inline dataset.
void	quoteBooleanLiteral(StringBuilder buf, String value)	Appends to a buffer a boolean literal.
protected void	quoteDateLiteral(StringBuilder buf, String value, Date date)	Helper method for JdbcDialectImpl.quoteDateLiteral(StringBuilder, String).
protected void	quoteTimestampLiteral(StringBuilder buf, String value, Timestamp timestamp)
boolean	requiresAliasForFromQuery()	Returns whether this Dialect requires subqueries in the FROM clause to have an alias.
boolean	requiresUnionOrderByOrdinal()	Returns true if this dialect allows only integers in the ORDER BY clause of a UNION (or other set operation) query.

Methods inherited from class mondrian.spi.impl.JdbcDialectImpl

allowsAs, allowsCompoundCountDistinct, allowsCountDistinct, allowsCountDistinctWithOtherAggs, allowsDdl, allowsDialectSharing, allowsFromQuery, allowsJoinOn, allowsMultipleCountDistinct, allowsMultipleDistinctSqlMeasures, allowsOrderByAlias, allowsRegularExpressionInWhereClause, allowsSelectNotInGroupBy, appendHintsAfterFromClause, caseWhenElse, computeStatisticsProviders, deduceIdentifierQuoteString, deduceMaxColumnNameLength, deduceProductName, deduceProductVersion, deduceReadOnly, deduceSupportedResultSetStyles, deduceSupportsSelectNotInGroupBy, extractEmbeddedFlags, generateCountExpression, generateInlineForAnsi, generateInlineGeneric, generateOrderByNulls, generateOrderByNullsAnsi, generateOrderItem, generateRegularExpression, getDatabaseProduct, getMaxColumnNameLength, getProduct, getQuoteIdentifierString, getStatisticsProviders, getType, isDatabase, needsExponent, quote, quoteDateLiteral, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteNumericLiteral, quoteStringLiteral, quoteTimeLiteral, quoteTimestampLiteral, requiresGroupByAlias, requiresHavingAlias, requiresOrderByAlias, requiresUnionOrderByExprToBeInSelectClause, supportsGroupByExpressions, supportsGroupingSets, supportsMultiValueInExpr, supportsResultSetConcurrency, supportsUnlimitedValueList, toString, toUpper

Methods inherited from class java.lang.Object

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

Field Details

FACTORY

public static final JdbcDialectFactory FACTORY

Constructor Details

MicrosoftSqlServerDialect

public MicrosoftSqlServerDialect(Connection connection)
                          throws SQLException

Creates a MicrosoftSqlServerDialect.

Parameters:

connection - Connection

Throws:

SQLException

Method Details

generateInline

public String generateInline(List<String> columnNames,
 List<String> columnTypes,
 List<String[]> valueList)

Description copied from interface: Dialect

Generates a SQL statement to represent an inline dataset.

For example, for Oracle, generates

 SELECT 1 AS FOO, 'a' AS BAR FROM dual
 UNION ALL
 SELECT 2 AS FOO, 'b' AS BAR FROM dual
 

For ANSI SQL, generates:

 VALUES (1, 'a'), (2, 'b')
 

Specified by:

generateInline in interface Dialect

Overrides:

generateInline in class JdbcDialectImpl

Parameters:

columnNames - List of column names

columnTypes - List of column types ("String" or "Numeric")

valueList - List of rows values

Returns:

SQL string

requiresAliasForFromQuery

public boolean requiresAliasForFromQuery()

Description copied from interface: Dialect

Returns whether this Dialect requires subqueries in the FROM clause to have an alias.

Specified by:

requiresAliasForFromQuery in interface Dialect

Overrides:

requiresAliasForFromQuery in class JdbcDialectImpl

Returns:

whether dialewct requires subqueries to have an alias

See Also:

• Dialect.allowsFromQuery()

requiresUnionOrderByOrdinal

public boolean requiresUnionOrderByOrdinal()

Description copied from interface: Dialect

Returns true if this dialect allows only integers in the ORDER BY clause of a UNION (or other set operation) query.

For example, SELECT x, y + z FROM t
UNION ALL
SELECT x, y + z FROM t
ORDER BY 1, 2 is allowed but SELECT x, y, z FROM t
UNION ALL
SELECT x, y, z FROM t
ORDER BY x is not.

Teradata is an example of a dialect with this restriction.

Specified by:

requiresUnionOrderByOrdinal in interface Dialect

Overrides:

requiresUnionOrderByOrdinal in class JdbcDialectImpl

Returns:

whether this dialect allows only integers in the ORDER BY clause of a UNION (or other set operation) query

quoteBooleanLiteral

public void quoteBooleanLiteral(StringBuilder buf,
 String value)

Description copied from interface: Dialect

Appends to a buffer a boolean literal.

In the default dialect, boolean literals are printed as is.

Specified by:

quoteBooleanLiteral in interface Dialect

Overrides:

quoteBooleanLiteral in class JdbcDialectImpl

Parameters:

buf - Buffer to append to

value - Literal

quoteDateLiteral

protected void quoteDateLiteral(StringBuilder buf,
 String value,
 Date date)

Description copied from class: JdbcDialectImpl

Helper method for JdbcDialectImpl.quoteDateLiteral(StringBuilder, String).

Overrides:

quoteDateLiteral in class JdbcDialectImpl

Parameters:

buf - Buffer to append to

value - Value as string

date - Value as date

quoteTimestampLiteral

protected void quoteTimestampLiteral(StringBuilder buf,
 String value,
 Timestamp timestamp)

Overrides:

quoteTimestampLiteral in class JdbcDialectImpl