org.teiid.connector.jdbc.sqlserver
Class SqlServerCapabilities

java.lang.Object
  org.teiid.connector.basic.BasicConnectorCapabilities
      org.teiid.connector.jdbc.JDBCCapabilities
          org.teiid.connector.jdbc.sqlserver.SqlServerCapabilities

All Implemented Interfaces:

ConnectorCapabilities

public class SqlServerCapabilities
extends JDBCCapabilities

Nested Class Summary

Nested classes/interfaces inherited from interface org.teiid.connector.api.ConnectorCapabilities

ConnectorCapabilities.SupportedJoinCriteria

Constructor Summary

SqlServerCapabilities()

Method Summary

java.util.List<java.lang.String>	getSupportedFunctions() Return null to indicate no functions are supported.
boolean	supportsExcept() Support indicates that the connector supports the EXCEPT of two queries.
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	supportsRowLimit() Gets whether the connector can limit the number of rows returned by a query.

Methods inherited from class org.teiid.connector.jdbc.JDBCCapabilities

getMaxInCriteriaSize, getSupportedJoinCriteria, supportsAggregatesAvg, supportsAggregatesCount, supportsAggregatesCountStar, supportsAggregatesDistinct, supportsAggregatesMax, supportsAggregatesMin, supportsAggregatesSum, supportsAliasedGroup, supportsBatchedUpdates, supportsBetweenCriteria, supportsBulkUpdate, supportsCaseExpressions, supportsCompareCriteriaEquals, supportsCompareCriteriaOrdered, supportsCorrelatedSubqueries, supportsExistsCriteria, supportsFullOuterJoins, supportsGroupBy, supportsHaving, supportsInCriteria, supportsInCriteriaSubquery, supportsInnerJoins, supportsInsertWithQueryExpression, supportsIsNullCriteria, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsNotCriteria, supportsOrCriteria, supportsOrderBy, supportsOrderByUnrelated, supportsOuterJoins, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsScalarSubqueries, supportsSearchedCaseExpressions, supportsSelectDistinct, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions

Methods inherited from class org.teiid.connector.basic.BasicConnectorCapabilities

getMaxFromGroups, requiresCriteria, supportsRowOffset, useAnsiJoin

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlServerCapabilities

public SqlServerCapabilities()

Method Detail

getSupportedFunctions

public java.util.List<java.lang.String> getSupportedFunctions()

Description copied from class: BasicConnectorCapabilities

Return null to indicate no functions are supported.

Specified by:

getSupportedFunctions in interface ConnectorCapabilities

Overrides:

getSupportedFunctions in class JDBCCapabilities

Returns:

null

See Also:

com.metamatrix.data.ConnectorCapabilities#getSupportedFunctions()

supportsInlineViews

public boolean supportsInlineViews()

Description copied from interface: ConnectorCapabilities

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

Specified by:

supportsInlineViews in interface ConnectorCapabilities

Overrides:

supportsInlineViews in class JDBCCapabilities

See Also:

ConnectorCapabilities.supportsInlineViews()

supportsFunctionsInGroupBy

public boolean supportsFunctionsInGroupBy()

Description copied from interface: ConnectorCapabilities

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

NOT CURRENTLY USED - group by expressions create an inline view for pushdown

Specified by:

supportsFunctionsInGroupBy in interface ConnectorCapabilities

Overrides:

supportsFunctionsInGroupBy in class BasicConnectorCapabilities

Since:

5.0

See Also:

ConnectorCapabilities.supportsFunctionsInGroupBy()

supportsRowLimit

public boolean supportsRowLimit()

Description copied from interface: ConnectorCapabilities

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

Specified by:

supportsRowLimit in interface ConnectorCapabilities

Overrides:

supportsRowLimit in class BasicConnectorCapabilities

supportsIntersect

public boolean supportsIntersect()

Description copied from interface: ConnectorCapabilities

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

Specified by:

supportsIntersect in interface ConnectorCapabilities

Overrides:

supportsIntersect in class BasicConnectorCapabilities

See Also:

ConnectorCapabilities.supportsIntersect()

supportsExcept

public boolean supportsExcept()

Description copied from interface: ConnectorCapabilities

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

Specified by:

supportsExcept in interface ConnectorCapabilities

Overrides:

supportsExcept in class BasicConnectorCapabilities

See Also:

ConnectorCapabilities.supportsExcept()