org.teiid.translator.jdbc.sqlserver

Class SQLServerExecutionFactory

java.lang.Object

org.teiid.translator.ExecutionFactory<DataSource,Connection>

org.teiid.translator.jdbc.JDBCExecutionFactory

org.teiid.translator.jdbc.sybase.BaseSybaseExecutionFactory

org.teiid.translator.jdbc.sybase.SybaseExecutionFactory

org.teiid.translator.jdbc.sqlserver.SQLServerExecutionFactory

@Translator(name="sqlserver",
            description="A translator for Microsoft SQL Server Database")
public class SQLServerExecutionFactory
extends SybaseExecutionFactory

Updated to assume the use of the DataDirect, 2005 driver, or later.

Nested Class Summary

Nested classes/interfaces inherited from class org.teiid.translator.ExecutionFactory

ExecutionFactory.Format, ExecutionFactory.NullOrder, ExecutionFactory.SupportedJoinCriteria

Field Summary

Fields

Modifier and Type	Field and Description
static String	V_2005
static String	V_2008

Fields inherited from class org.teiid.translator.jdbc.sybase.SybaseExecutionFactory

FIFTEEN_0_2, FIFTEEN_5, formatMap, jtdsDriver, TWELVE_5

Fields inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

DEFAULT_MAX_DEPENDENT_PREDICATES, DEFAULT_MAX_IN_CRITERIA, DEFAULT_TIME_ZONE

Fields inherited from class org.teiid.translator.ExecutionFactory

DEFAULT_MAX_FROM_GROUPS, DEFAULT_MAX_IN_CRITERIA_SIZE

Constructor Summary

Constructors

Constructor and Description
SQLServerExecutionFactory()

Method Summary

Methods

Modifier and Type	Method and Description
boolean	booleanNullable()
protected List<Object>	convertDateToString(Function function)
protected List<?>	convertTimestampToString(Function function)
int	getMaxFromGroups() The number of groups supported in the from clause.
List<String>	getSupportedFunctions() Get list of all supported function names.
boolean	hasTimeType() Return false to indicate that time support should be emulated with timestamps.
boolean	nullPlusNonNullIsNull()
protected void	populateDateFormats()
protected boolean	setFetchSizeOnCallableStatements()
boolean	supportsAggregatesEnhancedNumeric() Support indicates connector can accept STDDEV_POP, STDDEV_VAR, VAR_POP, VAR_SAMP
boolean	supportsCommonTableExpressions()
protected boolean	supportsCrossJoin()
boolean	supportsElementaryOlapOperations()
boolean	supportsExcept() Support indicates that the connector supports the EXCEPT of two queries.
boolean	supportsFormatLiteral(String literal, ExecutionFactory.Format format)
boolean	supportsFunctionsInGroupBy() Support indicates that the connector supports functions in GROUP BY, such as: SELECT dayofmonth(theDate), COUNT(*) FROM table GROUP BY dayofmonth(theDate)
boolean	supportsInlineViews() Support indicates connector can accept inline views (subqueries in the FROM clause).
boolean	supportsIntersect() Support indicates that the connector supports the INTERSECT of two queries.
boolean	supportsOnlyFormatLiterals() See also ExecutionFactory.supportsFormatLiteral(String, Format)
boolean	supportsRowLimit() Gets whether the connector can limit the number of rows returned by a query.
boolean	supportsWindowDistinctAggregates()
boolean	supportsWindowOrderByWithAggregates()
List<?>	translate(LanguageObject obj, ExecutionContext context) Return a List of translated parts (LanguageObjects and Objects), or null if to rely on the default translation.
String	translateLiteralDate(Date dateValue) Subclasses should override this method to provide a different sql translation of the literal date value.

Methods inherited from class org.teiid.translator.jdbc.sybase.SybaseExecutionFactory

isJtdsDriver, setFetchSize, setJtdsDriver, start, translateLiteralTimestamp

Methods inherited from class org.teiid.translator.jdbc.sybase.BaseSybaseExecutionFactory

bindValue, getTimestampNanoPrecision, retrieveValue, retrieveValue, translateCommand, translateLimit, useAsInGroupAlias, useSelectLimit

Methods inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

addSourceComment, afterInitialConnectionObtained, closeConnection, createMetadataProcessor, createProcedureExecution, createResultSetExecution, createUpdateExecution, executeStoredProcedure, formatDateValue, getConnection, getDatabaseCalendar, getDatabaseTimeZone, getDatabaseVersion, getDefaultNullOrder, getDefaultSupportedFunctions, getFunctionModifiers, getLikeRegexString, getMaxPreparedInsertBatchSize, getMetadata, getSetOperationString, getSourceComment, getSQLConversionVisitor, isSourceRequired, isTrimStrings, obtainedConnection, parseName, registerFunctionModifier, registerSpecificTypeOfOutParameter, replaceElementName, setDatabaseTimeZone, setDatabaseVersion, setMaxPreparedInsertBatchSize, setTrimStrings, setUseBindVariables, setUseCommentsInSourceQuery, supportsAggregatesAvg, supportsAggregatesCount, supportsAggregatesCountStar, supportsAggregatesDistinct, supportsAggregatesMax, supportsAggregatesMin, supportsAggregatesSum, supportsAliasedTable, supportsBatchedUpdates, supportsBulkUpdate, supportsCompareCriteriaEquals, supportsCompareCriteriaOrdered, supportsCorrelatedSubqueries, supportsExistsCriteria, supportsGroupBy, supportsHaving, supportsInCriteria, supportsInCriteriaSubquery, supportsInsertWithQueryExpression, supportsIsNullCriteria, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsNotCriteria, supportsOrCriteria, supportsOrderByUnrelated, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsScalarSubqueries, supportsSearchedCaseExpressions, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions, translateLiteralBoolean, translateLiteralTime, useBindVariables, useCommentsInSourceQuery, useParensForJoins, useParensForSetQueries, usePreparedStatements

Methods inherited from class org.teiid.translator.ExecutionFactory

addPushDownFunction, areLobsUsableAfterClose, createExecution, getConnection, getInstance, getLanguageFactory, getMaxDependentInPredicates, getMaxInCriteriaSize, getPushDownFunctions, getSupportedJoinCriteria, getTypeFacility, isCopyLobs, isImmutable, requiresCriteria, setCopyLobs, setImmutable, setMaxDependentInPredicates, setMaxInCriteriaSize, setRequiresCriteria, setSourceRequired, setSupportedJoinCriteria, setSupportsFullOuterJoins, setSupportsInnerJoins, setSupportsOrderBy, setSupportsOuterJoins, setSupportsSelectDistinct, supportsAdvancedOlapOperations, supportsArrayAgg, supportsConvert, supportsDependentJoins, supportsFullOuterJoins, supportsInnerJoins, supportsLikeRegex, supportsOnlyLiteralComparison, supportsOnlySingleTableGroupBy, supportsOrderBy, supportsOrderByNullOrdering, supportsOuterJoins, supportsRowOffset, supportsSelectDistinct, supportsSimilarTo, useAnsiJoin

Methods inherited from class java.lang.Object

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

Field Detail

V_2005

public static final String V_2005

See Also:

Constant Field Values

V_2008

public static final String V_2008

See Also:

Constant Field Values

Constructor Detail

SQLServerExecutionFactory

public SQLServerExecutionFactory()

Method Detail

populateDateFormats

protected void populateDateFormats()

Overrides:

populateDateFormats in class SybaseExecutionFactory

convertDateToString

protected List<Object> convertDateToString(Function function)

Overrides:

convertDateToString in class SybaseExecutionFactory

convertTimestampToString

protected List<?> convertTimestampToString(Function function)

Overrides:

convertTimestampToString in class SybaseExecutionFactory

translate

public List<?> translate(LanguageObject obj,
                ExecutionContext context)

Description copied from class: JDBCExecutionFactory

Return a List of translated parts (LanguageObjects and Objects), or null if to rely on the default translation. Override with care.

Overrides:

translate in class BaseSybaseExecutionFactory

Returns:

list of translated parts

getSupportedFunctions

public List<String> getSupportedFunctions()

Description copied from class: ExecutionFactory

Get list of all supported function names. Arithmetic functions have names like "+".

Overrides:

getSupportedFunctions in class SybaseExecutionFactory

See Also:

for a listing of system pushdown functions. Note that not all system functions are listed as some functions will use a common name such as CONCAT vs. the || operator, and other functions will be rewritten and not pushed down, such as SPACE.

supportsInlineViews

public boolean supportsInlineViews()

Description copied from class: ExecutionFactory

Support indicates connector can accept inline views (subqueries in the FROM clause).

Overrides:

supportsInlineViews in class SybaseExecutionFactory

supportsFunctionsInGroupBy

public boolean supportsFunctionsInGroupBy()

Description copied from class: ExecutionFactory

Support indicates that the connector supports functions in GROUP BY, such as: SELECT dayofmonth(theDate), COUNT(*) FROM table GROUP BY dayofmonth(theDate)

Overrides:

supportsFunctionsInGroupBy in class SybaseExecutionFactory

supportsRowLimit

public boolean supportsRowLimit()

Description copied from class: ExecutionFactory

Gets whether the connector can limit the number of rows returned by a query.

Overrides:

supportsRowLimit in class SybaseExecutionFactory

supportsIntersect

public boolean supportsIntersect()

Description copied from class: ExecutionFactory

Support indicates that the connector supports the INTERSECT of two queries.

Overrides:

supportsIntersect in class ExecutionFactory<DataSource,Connection>

supportsExcept

public boolean supportsExcept()

Description copied from class: ExecutionFactory

Support indicates that the connector supports the EXCEPT of two queries.

Overrides:

supportsExcept in class ExecutionFactory<DataSource,Connection>

getMaxFromGroups

public int getMaxFromGroups()

Description copied from class: ExecutionFactory

The number of groups supported in the from clause. Added for a Sybase limitation.

Overrides:

getMaxFromGroups in class SybaseExecutionFactory

Returns:

the number of groups supported in the from clause, or -1 if there is no limit

supportsAggregatesEnhancedNumeric

public boolean supportsAggregatesEnhancedNumeric()

Description copied from class: ExecutionFactory

Support indicates connector can accept STDDEV_POP, STDDEV_VAR, VAR_POP, VAR_SAMP

Overrides:

supportsAggregatesEnhancedNumeric in class SybaseExecutionFactory

nullPlusNonNullIsNull

public boolean nullPlusNonNullIsNull()

Overrides:

nullPlusNonNullIsNull in class SybaseExecutionFactory

booleanNullable

public boolean booleanNullable()

Overrides:

booleanNullable in class SybaseExecutionFactory

translateLiteralDate

public String translateLiteralDate(Date dateValue)

Description copied from class: JDBCExecutionFactory

Subclasses should override this method to provide a different sql translation of the literal date value. By default, a date literal is represented as: {d '2002-12-31'}

Overrides:

translateLiteralDate in class SybaseExecutionFactory

Parameters:

dateValue - Date value, never null

Returns:

Translated string

hasTimeType

public boolean hasTimeType()

Description copied from class: JDBCExecutionFactory

Return false to indicate that time support should be emulated with timestamps.

Overrides:

hasTimeType in class BaseSybaseExecutionFactory

Returns:

true if database has a time type

supportsCommonTableExpressions

public boolean supportsCommonTableExpressions()

Overrides:

supportsCommonTableExpressions in class ExecutionFactory<DataSource,Connection>

Returns:

true if the WITH clause is supported

supportsCrossJoin

protected boolean supportsCrossJoin()

Overrides:

supportsCrossJoin in class BaseSybaseExecutionFactory

supportsElementaryOlapOperations

public boolean supportsElementaryOlapOperations()

Overrides:

supportsElementaryOlapOperations in class ExecutionFactory<DataSource,Connection>

Returns:

true if Elementary OLAP operations are supported including window functions and inline window specifications that include simple expressions in partitioning and ordering

supportsWindowDistinctAggregates

public boolean supportsWindowDistinctAggregates()

Overrides:

supportsWindowDistinctAggregates in class ExecutionFactory<DataSource,Connection>

Returns:

true if distinct aggregates can be windowed function.

supportsWindowOrderByWithAggregates

public boolean supportsWindowOrderByWithAggregates()

Overrides:

supportsWindowOrderByWithAggregates in class ExecutionFactory<DataSource,Connection>

Returns:

true if all aggregates can have window function order by clauses.

supportsFormatLiteral

public boolean supportsFormatLiteral(String literal,
                            ExecutionFactory.Format format)

Overrides:

supportsFormatLiteral in class ExecutionFactory<DataSource,Connection>

Returns:

true if the given Java format string is supported

supportsOnlyFormatLiterals

public boolean supportsOnlyFormatLiterals()

Description copied from class: ExecutionFactory

See also ExecutionFactory.supportsFormatLiteral(String, Format)

Overrides:

supportsOnlyFormatLiterals in class ExecutionFactory<DataSource,Connection>

Returns:

true if only literal formats are supports.

setFetchSizeOnCallableStatements

protected boolean setFetchSizeOnCallableStatements()

Overrides:

setFetchSizeOnCallableStatements in class SybaseExecutionFactory