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.jdbc.JDBCExecutionFactory

JDBCExecutionFactory.StructRetrieval

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 Version	ELEVEN_0
static Version	NINE_0
static Version	SEVEN_0
static Version	TEN_0
static String	V_2000
static String	V_2005
static String	V_2008
static String	V_2012

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

FIFTEEN_0_2, FIFTEEN_5, formatMap, jtdsDriver, TWELVE_5, TWELVE_5_3

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

DEFAULT_MAX_DEPENDENT_PREDICATES, DEFAULT_MAX_IN_CRITERIA, DEFAULT_TIME_ZONE, dialect

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)
protected JDBCMetdataProcessor	createMetadataProcessor()
String	getHibernateDialectClassName()
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()
void	setDatabaseVersion(String version) Overriden to allow for year based versions
protected boolean	setFetchSize()
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 non-column expressions in GROUP BY, such as: SELECT dayofmonth(theDate), COUNT(*) FROM table GROUP BY dayofmonth(theDate)
boolean	supportsGroupByRollup()
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	supportsSelectWithoutFrom()
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.
protected boolean	usesDatabaseVersion()
boolean	useStreamsForLobs() If streams should be used for Blob/Clob sets on PreparedStatements
boolean	useWithRollup()

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

initCapabilities, isJtdsDriver, setFetchSize, setJtdsDriver, start, translateLiteralTimestamp

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

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

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

addSourceComment, afterInitialConnectionObtained, closeConnection, convertObject, createDirectExecution, createProcedureExecution, createResultSetExecution, createTempTable, createUpdateExecution, executeStoredProcedure, formatDateValue, getConnection, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getCreateTempTableSQL, getDatabaseCalendar, getDatabaseTimeZone, getDatabaseVersion, getDefaultNullOrder, getDefaultSupportedFunctions, getDialect, getFunctionModifiers, getLikeRegexString, getMaxPreparedInsertBatchSize, getMetadata, getSetOperationString, getSourceComment, getSQLConversionVisitor, getStructRetrieval, getVersion, isEnableDependentJoins, isSourceRequired, isSourceRequiredForCapabilities, isTrimStrings, loadedTemporaryTable, obtainedConnection, parseName, registerFunctionModifier, registerSpecificTypeOfOutParameter, replaceElementName, setDatabaseTimeZone, setDatabaseVersion, setEnableDependentJoins, setMaxPreparedInsertBatchSize, setStructRetrieval, setTrimStrings, setUseBindVariables, setUseCommentsInSourceQuery, supportsAggregatesAvg, supportsAggregatesCount, supportsAggregatesCountStar, supportsAggregatesDistinct, supportsAggregatesMax, supportsAggregatesMin, supportsAggregatesSum, supportsAliasedTable, supportsBatchedUpdates, supportsBulkUpdate, supportsCompareCriteriaEquals, supportsCompareCriteriaOrdered, supportsCorrelatedSubqueries, supportsDependentJoins, supportsExistsCriteria, supportsFullDependentJoins, supportsGeneratedKeys, supportsGeneratedKeys, supportsGroupBy, supportsHaving, supportsInCriteria, supportsInCriteriaSubquery, supportsInsertWithQueryExpression, supportsIsNullCriteria, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsNotCriteria, supportsOrCriteria, supportsOrderByUnrelated, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsScalarSubqueries, supportsSearchedCaseExpressions, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions, tempTableRequiresTransaction, translateLiteralBoolean, translateLiteralTime, useBindVariables, useCommentsInSourceQuery, useParensForJoins, useParensForSetQueries, usePreparedStatements

Methods inherited from class org.teiid.translator.ExecutionFactory

addPushDownFunction, areLobsUsableAfterClose, createExecution, getCacheDirective, getConnection, getDirectQueryProcedureName, getInstance, getLanguageFactory, getMaxDependentInPredicates, getMaxInCriteriaSize, getNativeQueryProcedureName, getPushDownFunctions, getSupportedJoinCriteria, getTypeFacility, isCopyLobs, isForkable, isImmutable, isSourceRequiredForMetadata, isThreadBound, requiresCriteria, setCopyLobs, setDirectQueryProcedureName, setImmutable, setMaxDependentInPredicates, setMaxInCriteriaSize, setNativeQueryProcedureName, setRequiresCriteria, setSourceRequired, setSourceRequiredForMetadata, setSupportedJoinCriteria, setSupportsDirectQueryProcedure, setSupportsFullOuterJoins, setSupportsInnerJoins, setSupportsNativeQueries, setSupportsOrderBy, setSupportsOuterJoins, setSupportsSelectDistinct, setThreadBound, supportsAdvancedOlapOperations, supportsArrayAgg, supportsArrayType, supportsConvert, supportsDirectQueryProcedure, supportsFullOuterJoins, supportsInnerJoins, supportsLikeRegex, supportsNativeQueries, supportsOnlyCorrelatedSubqueries, supportsOnlyLiteralComparison, supportsOnlySingleTableGroupBy, supportsOrderBy, supportsOrderByNullOrdering, supportsOrderByWithExtendedGrouping, supportsOuterJoins, supportsRowOffset, supportsSelectDistinct, supportsSimilarTo, supportsStringAgg, supportsSubqueryInOn, useAnsiJoin

Methods inherited from class java.lang.Object

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

Field Detail

V_2000

public static final String V_2000

See Also:

Constant Field Values

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

V_2012

public static final String V_2012

See Also:

Constant Field Values

SEVEN_0

public static final Version SEVEN_0

NINE_0

public static final Version NINE_0

TEN_0

public static final Version TEN_0

ELEVEN_0

public static final Version ELEVEN_0

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.
Note: User defined functions should be specified fully qualified.

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 non-column expressions 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

setDatabaseVersion

public void setDatabaseVersion(String version)

Overriden to allow for year based versions

Overrides:

setDatabaseVersion in class JDBCExecutionFactory

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.

setFetchSize

protected boolean setFetchSize()

Overrides:

setFetchSize in class SybaseExecutionFactory

createMetadataProcessor

protected JDBCMetdataProcessor createMetadataProcessor()

Overrides:

createMetadataProcessor in class JDBCExecutionFactory

usesDatabaseVersion

protected boolean usesDatabaseVersion()

Overrides:

usesDatabaseVersion in class SybaseExecutionFactory

useStreamsForLobs

public boolean useStreamsForLobs()

Description copied from class: JDBCExecutionFactory

If streams should be used for Blob/Clob sets on PreparedStatements

Overrides:

useStreamsForLobs in class JDBCExecutionFactory

Returns:

supportsSelectWithoutFrom

public boolean supportsSelectWithoutFrom()

Overrides:

supportsSelectWithoutFrom in class SybaseExecutionFactory

Returns:

true if the translator support SELECT without a FROM clause

getHibernateDialectClassName

public String getHibernateDialectClassName()

Overrides:

getHibernateDialectClassName in class SybaseExecutionFactory

supportsGroupByRollup

public boolean supportsGroupByRollup()

Overrides:

supportsGroupByRollup in class SybaseExecutionFactory

Returns:

true if the translator support GROUP BY ROLLUP

useWithRollup

public boolean useWithRollup()

Overrides:

useWithRollup in class JDBCExecutionFactory

Returns:

true if the rollup syntax is WITH ROLLUP