SQLServerExecutionFactory (Teiid 12.1.0 API)

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.sybase.SybaseExecutionFactory
  SybaseExecutionFactory.SybaseFormatFunctionModifier
- 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, ExecutionFactory.TransactionSupport

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
convertModifier, 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, DEFAULT_MAX_PROJECTED_COLUMNS

Constructor Summary

Constructors
Constructor and Description

SQLServerExecutionFactory()

Constructors
Constructor and Description
`SQLServerExecutionFactory()`

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`boolean`	`booleanNullable()`
`protected List<Object>`	`convertDateToString(Function function)`
`protected List<?>`	`convertTimestampToString(Function function)`
`protected JDBCMetadataProcessor`	`createMetadataProcessor()` Deprecated.
`String`	`getHibernateDialectClassName()`
`MetadataProcessor<Connection>`	`getMetadataProcessor()` Get a MetadataProcessor for the translator to read the metadata.
`List<String>`	`getSupportedFunctions()` Get list of all supported function names.
`boolean`	`hasTimeType()` Return false to indicate that time support should be emulated with timestamps.
`void`	`initCapabilities(Connection connection)` Will be called by `ExecutionFactory.start()` with a null connection if a source connection is not `ExecutionFactory.isSourceRequiredForCapabilities()`
`boolean`	`nullPlusNonNullIsNull()`
`protected void`	`populateDateFormats()`
`void`	`setDatabaseVersion(String version)` Overridden to allow for year based versions
`protected boolean`	`setFetchSize()`
`void`	`start()` Initialize the connector with supplied configuration
`boolean`	`supportsAggregatesEnhancedNumeric()` Support indicates connector can accept STDDEV_POP, STDDEV_VAR, VAR_POP, VAR_SAMP
`boolean`	`supportsCommonTableExpressions()`
`boolean`	`supportsConvert(int fromType, int toType)` Used for fine grained control of convert/cast pushdown.
`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`	`supportsLiteralOnlyWithGrouping()`
`boolean`	`supportsOnlyFormatLiterals()` See also `ExecutionFactory.supportsFormatLiteral(String, Format)`
`boolean`	`supportsRecursiveCommonTableExpressions()`
`boolean`	`supportsRowLimit()` Gets whether the connector can limit the number of rows returned by a query.
`boolean`	`supportsRowOffset()` Gets whether the connector supports a SQL clause (similar to the LIMIT with an offset) that can return result sets that start in the middle of the resulting rows returned by a query
`boolean`	`supportsSelectWithoutFrom()`
`boolean`	`supportsSubqueryCommonTableExpressions()`
`boolean`	`supportsWindowDistinctAggregates()`
`boolean`	`supportsWindowFrameClause()`
`boolean`	`supportsWindowFunctionCumeDist()`
`boolean`	`supportsWindowFunctionNthValue()`
`boolean`	`supportsWindowFunctionNtile()`
`boolean`	`supportsWindowFunctionPercentRank()`
`boolean`	`supportsWindowOrderByWithAggregates()`
`List<?>`	`translate(LanguageObject obj, ExecutionContext context)` Return a List of translated parts (`LanguageObject`s and Objects), or null if to rely on the default translation.
`List<?>`	`translateCommand(Command command, ExecutionContext context)` SetQueries don't have a concept of TOP, an inline view is needed.
`List<?>`	`translateLimit(Limit limit, ExecutionContext context)` Return a List of translated parts (`LanguageObject`s 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.
`String`	`translateLiteralTime(Time timeValue)` The SQL Server driver maps the time escape to a timestamp/datetime, so use a cast of the string literal instead.
`String`	`translateLiteralTimestamp(Timestamp timestampValue)` Subclasses should override this method to provide a different sql translation of the literal timestamp value.
`protected boolean`	`usesDatabaseVersion()`
`boolean`	`useSelectLimit()` Returns whether the limit clause is applied to the select clause.
`boolean`	`useStreamsForLobs()` If streams should be used for Blob/Clob sets on `PreparedStatement`s
`boolean`	`useWithRollup()`

Methods inherited from class org.teiid.translator.jdbc.sybase.SybaseExecutionFactory
getMaxFromGroups, isJtdsDriver, setFetchSize, setJtdsDriver, translateLiteralBinaryType, useUnicodePrefix

Methods inherited from class org.teiid.translator.jdbc.sybase.BaseSybaseExecutionFactory
bindValue, getTemporaryTableName, getTimestampNanoPrecision, retrieveValue, retrieveValue, supportsAggregatesCountBig, supportsBooleanExpressions, useAsInGroupAlias

Methods inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory
addSourceComment, afterInitialConnectionObtained, closeConnection, convertObject, createDirectExecution, createProcedureExecution, createResultSetExecution, createTempTable, createUpdateExecution, executeStoredProcedure, formatDateValue, formatDateValue, getCommentFormat, getConnection, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getCreateTempTableSQL, getDatabaseCalendar, getDatabaseTimeZone, getDatabaseVersion, getDefaultNullOrder, getDefaultSupportedFunctions, getDialect, getFunctionModifiers, getLateralKeyword, getLikeRegexString, getMaxPreparedInsertBatchSize, getMetadata, getRemovePushdownCharacters, getSetOperationString, getSourceComment, getSQLConversionVisitor, getStructRetrieval, getVersion, intializeConnectionAfterCancel, isEnableDependentJoins, isExtendedAscii, isNonAscii, isNonAscii, isNonAsciiFunction, isSourceRequired, isSourceRequiredForCapabilities, isTrimStrings, loadedTemporaryTable, obtainedConnection, parseName, registerFunctionModifier, registerSpecificTypeOfOutParameter, replaceElementName, retrieveGeographyValue, retrieveGeographyValue, retrieveGeometryValue, retrieveGeometryValue, setCommentFormat, setDatabaseTimeZone, setDatabaseVersion, setEnableDependentJoins, setMaxPreparedInsertBatchSize, setRemovePushdownCharacters, setStructRetrieval, setTrimStrings, setUseBindingsForDependentJoin, 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, translateGeographyLiteral, translateGeographyParameter, translateGeographySelect, translateGeometryLiteral, translateGeometryParameter, translateGeometrySelect, translateLiteralBoolean, useBindingsForDependentJoin, useBindVariables, useColumnNamesForGeneratedKeys, useCommentsInSourceQuery, useParensForJoins, useParensForSetQueries, usePreparedStatements, useScientificNotation

Methods inherited from class org.teiid.translator.ExecutionFactory
addPushDownFunction, areLobsUsableAfterClose, createExecution, getCacheDirective, getCollationLocale, getConnection, getDirectQueryProcedureName, getExcludedCommonTableExpressionName, getInstance, getLanguageFactory, getMaxDependentInPredicates, getMaxInCriteriaSize, getMaxProjectedColumns, getNativeQueryProcedureName, getPushDownFunctions, getRequiredLikeEscape, getSupportedJoinCriteria, getTransactionSupport, getTypeFacility, isCopyLobs, isForkable, isImmutable, isSourceRequiredForMetadata, isThreadBound, requiresCriteria, returnsSingleUpdateCount, setCollationLocale, setCopyLobs, setDirectQueryProcedureName, setExcludedCommonTableExpressionName, setImmutable, setMaxDependentInPredicates, setMaxInCriteriaSize, setNativeQueryProcedureName, setRequiresCriteria, setSourceRequired, setSourceRequiredForMetadata, setSupportedJoinCriteria, setSupportsDirectQueryProcedure, setSupportsFullOuterJoins, setSupportsInnerJoins, setSupportsNativeQueries, setSupportsOrderBy, setSupportsOuterJoins, setSupportsSelectDistinct, setThreadBound, setTransactionSupport, supportsAdvancedOlapOperations, supportsArrayAgg, supportsArrayType, supportsCompareCriteriaOrderedExclusive, supportsCorrelatedSubqueryLimit, supportsDirectQueryProcedure, supportsFullOuterJoins, supportsGeographyType, supportsGroupByMultipleDistinctAggregates, supportsInnerJoins, supportsIsDistinctCriteria, supportsLateralJoin, supportsLateralJoinCondition, supportsLikeRegex, supportsListAgg, supportsMultipleOpenExecutions, supportsNativeQueries, supportsOnlyCorrelatedSubqueries, supportsOnlyLateralJoinProcedure, supportsOnlyLiteralComparison, supportsOnlySingleTableGroupBy, supportsOnlyTimestampAddLiteral, supportsOrderBy, supportsOrderByNullOrdering, supportsOrderByWithExtendedGrouping, supportsOuterJoins, supportsPartialFiltering, supportsProcedureTable, supportsScalarSubqueryProjection, supportsSelectDistinct, supportsSelectExpressionArrayType, supportsSetQueryLimitOffset, supportsSimilarTo, supportsStringAgg, supportsSubqueryInOn, supportsUpsert, 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
  - start
```
public void start()
           throws TranslatorException
```
    Description copied from class: ExecutionFactory
    
    Initialize the connector with supplied configuration
    
    Overrides:
    
    start in class SybaseExecutionFactory
    
    Throws:
    
    TranslatorException
  - initCapabilities
```
public void initCapabilities(Connection connection)
                      throws TranslatorException
```
    Description copied from class: ExecutionFactory
    
    Will be called by ExecutionFactory.start() with a null connection if a source connection is not ExecutionFactory.isSourceRequiredForCapabilities()
    
    Overrides:
    
    initCapabilities in class SybaseExecutionFactory
    
    Throws:
    
    TranslatorException
  - 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
  - supportsRowOffset
```
public boolean supportsRowOffset()
```
    Description copied from class: ExecutionFactory
    
    Gets whether the connector supports a SQL clause (similar to the LIMIT with an offset) that can return result sets that start in the middle of the resulting rows returned by a query
    
    Overrides:
    
    supportsRowOffset in class ExecutionFactory<DataSource,Connection>
  - 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>
  - 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)
```
    Overridden 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
  - translateLiteralTime
```
public String translateLiteralTime(Time timeValue)
```
    The SQL Server driver maps the time escape to a timestamp/datetime, so use a cast of the string literal instead.
    
    Overrides:
    
    translateLiteralTime in class JDBCExecutionFactory
    
    Parameters:
    
    timeValue - Time value, never null
    
    Returns:
    
    Translated string
  - supportsCommonTableExpressions
```
public boolean supportsCommonTableExpressions()
```
    Overrides:
    
    supportsCommonTableExpressions in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if the WITH clause is supported
  - supportsSubqueryCommonTableExpressions
```
public boolean supportsSubqueryCommonTableExpressions()
```
    Overrides:
    
    supportsSubqueryCommonTableExpressions in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if the WITH clause can appear in subqueries
  - supportsRecursiveCommonTableExpressions
```
public boolean supportsRecursiveCommonTableExpressions()
```
    Overrides:
    
    supportsRecursiveCommonTableExpressions in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if a recursive WITH clause item 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 SybaseExecutionFactory
    
    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 SybaseExecutionFactory
    
    Returns:
    
    true if only literal formats are supports.
  - setFetchSize
```
protected boolean setFetchSize()
```
    Overrides:
    
    setFetchSize in class SybaseExecutionFactory
  - createMetadataProcessor
```
@Deprecated
protected JDBCMetadataProcessor createMetadataProcessor()
```
    Deprecated.
    
    Overrides:
    
    createMetadataProcessor in class JDBCExecutionFactory
    
    See Also:
    
    getMetadataProcessor
  - getMetadataProcessor
```
public MetadataProcessor<Connection> getMetadataProcessor()
```
    Description copied from class: ExecutionFactory
    
    Get a MetadataProcessor for the translator to read the metadata. Typically this will return a new instance.
    
    Overrides:
    
    getMetadataProcessor in class JDBCExecutionFactory
    
    Returns:
  - 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
  - supportsConvert
```
public boolean supportsConvert(int fromType,
                               int toType)
```
    Description copied from class: ExecutionFactory
    
    Used for fine grained control of convert/cast pushdown. The ExecutionFactory.getSupportedFunctions() should contain SourceSystemFunctions.CONVERT. This method can then return false to indicate a lack of specific support. The engine will does not care about an unnecessary conversion where fromType == toType. By default lob conversion is disabled.
    
    Overrides:
    
    supportsConvert in class ExecutionFactory<DataSource,Connection>
    
    Parameters:
    
    fromType - @see RUNTIME_CODES
    
    toType - @see RUNTIME_CODES
    
    Returns:
    
    true if the given conversion is supported.
  - supportsLiteralOnlyWithGrouping
```
public boolean supportsLiteralOnlyWithGrouping()
```
    Overrides:
    
    supportsLiteralOnlyWithGrouping in class SybaseExecutionFactory
  - translateCommand
```
public List<?> translateCommand(Command command,
                                ExecutionContext context)
```
    Description copied from class: BaseSybaseExecutionFactory
    
    SetQueries don't have a concept of TOP, an inline view is needed.
    
    Overrides:
    
    translateCommand in class SybaseExecutionFactory
    
    Returns:
    
    a list of translated parts
  - translateLimit
```
public List<?> translateLimit(Limit limit,
                              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.
    
    Overrides:
    
    translateLimit in class BaseSybaseExecutionFactory
    
    Returns:
    
    a list of translated parts
  - useSelectLimit
```
public boolean useSelectLimit()
```
    Description copied from class: JDBCExecutionFactory
    
    Returns whether the limit clause is applied to the select clause.
    
    Overrides:
    
    useSelectLimit in class BaseSybaseExecutionFactory
    
    Returns:
    
    true if the limit clause is part of the select
  - translateLiteralTimestamp
```
public String translateLiteralTimestamp(Timestamp timestampValue)
```
    Description copied from class: JDBCExecutionFactory
    
    Subclasses should override this method to provide a different sql translation of the literal timestamp value. By default, a timestamp literal is represented as: {ts '2002-12-31 23:59:59'}. See JDBCExecutionFactory.getTimestampNanoPrecision() to control the literal precision.
    
    Overrides:
    
    translateLiteralTimestamp in class SybaseExecutionFactory
    
    Parameters:
    
    timestampValue - Timestamp value, never null
    
    Returns:
    
    Translated string
  - supportsWindowFunctionNtile
```
public boolean supportsWindowFunctionNtile()
```
    Overrides:
    
    supportsWindowFunctionNtile in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if ntile is supported. defaults to ExecutionFactory.supportsElementaryOlapOperations()
  - supportsWindowFunctionPercentRank
```
public boolean supportsWindowFunctionPercentRank()
```
    Overrides:
    
    supportsWindowFunctionPercentRank in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if percent_rank is supported. defaults to ExecutionFactory.supportsElementaryOlapOperations()
  - supportsWindowFunctionCumeDist
```
public boolean supportsWindowFunctionCumeDist()
```
    Overrides:
    
    supportsWindowFunctionCumeDist in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if cume_dist is supported. defaults to ExecutionFactory.supportsElementaryOlapOperations()
  - supportsWindowFunctionNthValue
```
public boolean supportsWindowFunctionNthValue()
```
    Overrides:
    
    supportsWindowFunctionNthValue in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if nth_value is supported. defaults to ExecutionFactory.supportsElementaryOlapOperations()
  - supportsWindowFrameClause
```
public boolean supportsWindowFrameClause()
```
    Overrides:
    
    supportsWindowFrameClause in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if the window frame clause is supported

Class SQLServerExecutionFactory

Nested Class Summary

Nested classes/interfaces inherited from class org.teiid.translator.jdbc.sybase.SybaseExecutionFactory

Nested classes/interfaces inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

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

Field Summary

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

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

Fields inherited from class org.teiid.translator.ExecutionFactory

Constructor Summary

Method Summary

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

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

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

Methods inherited from class org.teiid.translator.ExecutionFactory

Methods inherited from class java.lang.Object

Field Detail

V_2000

V_2005

V_2008

V_2012

SEVEN_0

NINE_0

TEN_0

ELEVEN_0

Constructor Detail

SQLServerExecutionFactory

Method Detail

start

initCapabilities

populateDateFormats

convertDateToString

convertTimestampToString

translate

getSupportedFunctions

supportsInlineViews

supportsFunctionsInGroupBy

supportsRowLimit

supportsRowOffset

supportsIntersect

supportsExcept

supportsAggregatesEnhancedNumeric

nullPlusNonNullIsNull

booleanNullable

setDatabaseVersion

translateLiteralDate

hasTimeType

translateLiteralTime

supportsCommonTableExpressions

supportsSubqueryCommonTableExpressions

supportsRecursiveCommonTableExpressions

supportsCrossJoin

supportsElementaryOlapOperations

supportsWindowDistinctAggregates

supportsWindowOrderByWithAggregates

supportsFormatLiteral

supportsOnlyFormatLiterals

setFetchSize

createMetadataProcessor

getMetadataProcessor

usesDatabaseVersion

useStreamsForLobs

supportsSelectWithoutFrom

getHibernateDialectClassName

supportsGroupByRollup

useWithRollup

supportsConvert

supportsLiteralOnlyWithGrouping

translateCommand

translateLimit

useSelectLimit

translateLiteralTimestamp

supportsWindowFunctionNtile

supportsWindowFunctionPercentRank

supportsWindowFunctionCumeDist

supportsWindowFunctionNthValue

supportsWindowFrameClause