org.teiid.connector.jdbc
Class JDBCCapabilities

java.lang.Object
  extended by org.teiid.connector.basic.BasicConnectorCapabilities
      extended by org.teiid.connector.jdbc.JDBCCapabilities
All Implemented Interfaces:
ConnectorCapabilities
Direct Known Subclasses:
AccessCapabilities, DB2Capabilities, DerbyCapabilities, InformixCapabilities, MMCapabilities, MySQLCapabilities, OracleCapabilities, PostgreSQLCapabilities, SimpleCapabilities, SqlServerCapabilities, SybaseCapabilities, TeradataCapabilities

public class JDBCCapabilities
extends BasicConnectorCapabilities


Nested Class Summary
 
Nested classes/interfaces inherited from interface org.teiid.connector.api.ConnectorCapabilities
ConnectorCapabilities.SupportedJoinCriteria
 
Constructor Summary
JDBCCapabilities()
           
 
Method Summary
 int getMaxInCriteriaSize()
          Get the integer value representing the number of values allowed in an IN criteria in the WHERE clause of a query
 java.util.List<java.lang.String> getSupportedFunctions()
          Return null to indicate no functions are supported.
 ConnectorCapabilities.SupportedJoinCriteria getSupportedJoinCriteria()
          Get the supported join criteria.
 boolean supportsAggregatesAvg()
          Support indicates connector can accept the AVG aggregate function
 boolean supportsAggregatesCount()
          Support indicates connector can accept the COUNT aggregate function
 boolean supportsAggregatesCountStar()
          Support indicates connector can accept the COUNT(*) aggregate function
 boolean supportsAggregatesDistinct()
          Support indicates connector can accept DISTINCT within aggregate functions
 boolean supportsAggregatesMax()
          Support indicates connector can accept the MAX aggregate function
 boolean supportsAggregatesMin()
          Support indicates connector can accept the MIN aggregate function
 boolean supportsAggregatesSum()
          Support indicates connector can accept the SUM aggregate function
 boolean supportsAliasedGroup()
          Support indicates connector can accept groups with aliases
 boolean supportsBatchedUpdates()
          Whether the source supports IBatchedUpdates
 boolean supportsBetweenCriteria()
          Support indicates connector accepts criteria of form (element BETWEEN constant AND constant)
NOT CURRENTLY USED - between is rewritten as compound compare criteria
 boolean supportsBulkUpdate()
          Whether the source supports updates with multiple value sets
 boolean supportsCaseExpressions()
          Support indicates connector can accept queries with non-searched CASE WHEN ...
 boolean supportsCompareCriteriaEquals()
          Support indicates connector accepts criteria of form (element = constant)
 boolean supportsCompareCriteriaOrdered()
          Support indicates connector accepts criteria of form (element <=|>= constant)
The query engine will may pushdown queries containing < or > if NOT is also supported.
 boolean supportsCorrelatedSubqueries()
          Support indicates connector can accept correlated subqueries wherever subqueries are accepted
 boolean supportsExistsCriteria()
          Support indicates connector accepts the EXISTS criteria
 boolean supportsFullOuterJoins()
          Support indicates connector can accept full outer joins
 boolean supportsGroupBy()
          Whether the source supports an explicit GROUP BY clause
 boolean supportsHaving()
          Whether the source supports the HAVING clause
 boolean supportsInCriteria()
          Support indicates connector accepts criteria of form (element IN set)
 boolean supportsInCriteriaSubquery()
          Support indicates connector accepts IN criteria with a subquery on the right side
 boolean supportsInlineViews()
          Support indicates connector can accept inline views (subqueries in the FROM clause).
 boolean supportsInnerJoins()
          Support indicates connector can accept inner or cross joins
 boolean supportsInsertWithQueryExpression()
          Support indicates that the connector can accept INSERTs with values specified by an ISetQuery.
 boolean supportsIsNullCriteria()
          Support indicates connector accepts criteria of form (element IS NULL)
 boolean supportsLikeCriteria()
          Support indicates connector accepts criteria of form (element LIKE constant)
 boolean supportsLikeCriteriaEscapeCharacter()
          Support indicates connector accepts criteria of form (element LIKE constant ESCAPE char)
 boolean supportsNotCriteria()
          Support indicates connector accepts logical criteria NOT
 boolean supportsOrCriteria()
          Support indicates connector accepts logical criteria connected by OR
 boolean supportsOrderBy()
          Support indicates connector accepts ORDER BY clause, including multiple elements and ascending and descending sorts.
 boolean supportsOrderByUnrelated()
          Support indicates connector accepts ORDER BY clause with columns not from the select
 boolean supportsOuterJoins()
          Support indicates connector can accept left outer joins
 boolean supportsQuantifiedCompareCriteriaAll()
          Support indicates connector accepts the quantified comparison criteria that use ALL
 boolean supportsQuantifiedCompareCriteriaSome()
          Support indicates connector accepts the quantified comparison criteria that use SOME
 boolean supportsScalarSubqueries()
          Support indicates connector can accept scalar subqueries in the SELECT, WHERE, and HAVING clauses
 boolean supportsSearchedCaseExpressions()
          Support indicates connector can accept queries with searched CASE WHEN ...
 boolean supportsSelectDistinct()
          Support indicates connector can accept queries with SELECT DISTINCT
 boolean supportsSelectExpression()
          Support indicates connector can accept expressions other than element symbols in the SELECT clause.
 boolean supportsSelfJoins()
          Support indicates connector can accept self-joins where a group is joined to itself with aliases.
 boolean supportsSetQueryOrderBy()
          Support indicates that the connector supports an ORDER BY on a SetQuery.
 boolean supportsUnions()
          Support indicates that the connector supports the UNION of two queries.
 
Methods inherited from class org.teiid.connector.basic.BasicConnectorCapabilities
getMaxFromGroups, requiresCriteria, supportsExcept, supportsFunctionsInGroupBy, supportsIntersect, supportsRowLimit, supportsRowOffset, useAnsiJoin
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

JDBCCapabilities

public JDBCCapabilities()
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 BasicConnectorCapabilities
Returns:
null
See Also:
ConnectorCapabilities.getSupportedFunctions()

getMaxInCriteriaSize

public int getMaxInCriteriaSize()
Description copied from interface: ConnectorCapabilities
Get the integer value representing the number of values allowed in an IN criteria in the WHERE clause of a query

Specified by:
getMaxInCriteriaSize in interface ConnectorCapabilities
Overrides:
getMaxInCriteriaSize in class BasicConnectorCapabilities
Since:
4.2
See Also:
BasicConnectorCapabilities.getMaxInCriteriaSize()

supportsGroupBy

public boolean supportsGroupBy()
Description copied from interface: ConnectorCapabilities
Whether the source supports an explicit GROUP BY clause

Specified by:
supportsGroupBy in interface ConnectorCapabilities
Overrides:
supportsGroupBy in class BasicConnectorCapabilities

supportsAggregatesAvg

public boolean supportsAggregatesAvg()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept the AVG aggregate function

Specified by:
supportsAggregatesAvg in interface ConnectorCapabilities
Overrides:
supportsAggregatesAvg in class BasicConnectorCapabilities

supportsAggregatesCount

public boolean supportsAggregatesCount()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept the COUNT aggregate function

Specified by:
supportsAggregatesCount in interface ConnectorCapabilities
Overrides:
supportsAggregatesCount in class BasicConnectorCapabilities

supportsAggregatesCountStar

public boolean supportsAggregatesCountStar()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept the COUNT(*) aggregate function

Specified by:
supportsAggregatesCountStar in interface ConnectorCapabilities
Overrides:
supportsAggregatesCountStar in class BasicConnectorCapabilities

supportsAggregatesDistinct

public boolean supportsAggregatesDistinct()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept DISTINCT within aggregate functions

Specified by:
supportsAggregatesDistinct in interface ConnectorCapabilities
Overrides:
supportsAggregatesDistinct in class BasicConnectorCapabilities

supportsAggregatesMax

public boolean supportsAggregatesMax()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept the MAX aggregate function

Specified by:
supportsAggregatesMax in interface ConnectorCapabilities
Overrides:
supportsAggregatesMax in class BasicConnectorCapabilities

supportsAggregatesMin

public boolean supportsAggregatesMin()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept the MIN aggregate function

Specified by:
supportsAggregatesMin in interface ConnectorCapabilities
Overrides:
supportsAggregatesMin in class BasicConnectorCapabilities

supportsAggregatesSum

public boolean supportsAggregatesSum()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept the SUM aggregate function

Specified by:
supportsAggregatesSum in interface ConnectorCapabilities
Overrides:
supportsAggregatesSum in class BasicConnectorCapabilities

supportsAliasedGroup

public boolean supportsAliasedGroup()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept groups with aliases

Specified by:
supportsAliasedGroup in interface ConnectorCapabilities
Overrides:
supportsAliasedGroup in class BasicConnectorCapabilities

supportsBetweenCriteria

public boolean supportsBetweenCriteria()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts criteria of form (element BETWEEN constant AND constant)
NOT CURRENTLY USED - between is rewritten as compound compare criteria

Specified by:
supportsBetweenCriteria in interface ConnectorCapabilities
Overrides:
supportsBetweenCriteria in class BasicConnectorCapabilities

supportsCaseExpressions

public boolean supportsCaseExpressions()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept queries with non-searched CASE WHEN ... END
NOT CURRENTLY USED - case is pushed down as searched case

Specified by:
supportsCaseExpressions in interface ConnectorCapabilities
Overrides:
supportsCaseExpressions in class BasicConnectorCapabilities

supportsCompareCriteriaEquals

public boolean supportsCompareCriteriaEquals()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts criteria of form (element = constant)

Specified by:
supportsCompareCriteriaEquals in interface ConnectorCapabilities
Overrides:
supportsCompareCriteriaEquals in class BasicConnectorCapabilities

supportsCorrelatedSubqueries

public boolean supportsCorrelatedSubqueries()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept correlated subqueries wherever subqueries are accepted

Specified by:
supportsCorrelatedSubqueries in interface ConnectorCapabilities
Overrides:
supportsCorrelatedSubqueries in class BasicConnectorCapabilities

supportsExistsCriteria

public boolean supportsExistsCriteria()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts the EXISTS criteria

Specified by:
supportsExistsCriteria in interface ConnectorCapabilities
Overrides:
supportsExistsCriteria in class BasicConnectorCapabilities

supportsFullOuterJoins

public boolean supportsFullOuterJoins()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept full outer joins

Specified by:
supportsFullOuterJoins in interface ConnectorCapabilities
Overrides:
supportsFullOuterJoins in class BasicConnectorCapabilities

supportsInCriteria

public boolean supportsInCriteria()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts criteria of form (element IN set)

Specified by:
supportsInCriteria in interface ConnectorCapabilities
Overrides:
supportsInCriteria in class BasicConnectorCapabilities

supportsInCriteriaSubquery

public boolean supportsInCriteriaSubquery()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts IN criteria with a subquery on the right side

Specified by:
supportsInCriteriaSubquery in interface ConnectorCapabilities
Overrides:
supportsInCriteriaSubquery in class BasicConnectorCapabilities

supportsIsNullCriteria

public boolean supportsIsNullCriteria()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts criteria of form (element IS NULL)

Specified by:
supportsIsNullCriteria in interface ConnectorCapabilities
Overrides:
supportsIsNullCriteria in class BasicConnectorCapabilities

supportsLikeCriteria

public boolean supportsLikeCriteria()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts criteria of form (element LIKE constant)

Specified by:
supportsLikeCriteria in interface ConnectorCapabilities
Overrides:
supportsLikeCriteria in class BasicConnectorCapabilities

supportsLikeCriteriaEscapeCharacter

public boolean supportsLikeCriteriaEscapeCharacter()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts criteria of form (element LIKE constant ESCAPE char)

Specified by:
supportsLikeCriteriaEscapeCharacter in interface ConnectorCapabilities
Overrides:
supportsLikeCriteriaEscapeCharacter in class BasicConnectorCapabilities

supportsNotCriteria

public boolean supportsNotCriteria()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts logical criteria NOT

Specified by:
supportsNotCriteria in interface ConnectorCapabilities
Overrides:
supportsNotCriteria in class BasicConnectorCapabilities

supportsOrCriteria

public boolean supportsOrCriteria()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts logical criteria connected by OR

Specified by:
supportsOrCriteria in interface ConnectorCapabilities
Overrides:
supportsOrCriteria in class BasicConnectorCapabilities

supportsOrderBy

public boolean supportsOrderBy()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts ORDER BY clause, including multiple elements and ascending and descending sorts.

Specified by:
supportsOrderBy in interface ConnectorCapabilities
Overrides:
supportsOrderBy in class BasicConnectorCapabilities

supportsOrderByUnrelated

public boolean supportsOrderByUnrelated()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts ORDER BY clause with columns not from the select

Specified by:
supportsOrderByUnrelated in interface ConnectorCapabilities
Overrides:
supportsOrderByUnrelated in class BasicConnectorCapabilities
Returns:

supportsOuterJoins

public boolean supportsOuterJoins()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept left outer joins

Specified by:
supportsOuterJoins in interface ConnectorCapabilities
Overrides:
supportsOuterJoins in class BasicConnectorCapabilities

supportsQuantifiedCompareCriteriaAll

public boolean supportsQuantifiedCompareCriteriaAll()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts the quantified comparison criteria that use ALL

Specified by:
supportsQuantifiedCompareCriteriaAll in interface ConnectorCapabilities
Overrides:
supportsQuantifiedCompareCriteriaAll in class BasicConnectorCapabilities

supportsScalarSubqueries

public boolean supportsScalarSubqueries()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept scalar subqueries in the SELECT, WHERE, and HAVING clauses

Specified by:
supportsScalarSubqueries in interface ConnectorCapabilities
Overrides:
supportsScalarSubqueries in class BasicConnectorCapabilities

supportsSearchedCaseExpressions

public boolean supportsSearchedCaseExpressions()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept queries with searched CASE WHEN ... END

Specified by:
supportsSearchedCaseExpressions in interface ConnectorCapabilities
Overrides:
supportsSearchedCaseExpressions in class BasicConnectorCapabilities

supportsSelectDistinct

public boolean supportsSelectDistinct()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept queries with SELECT DISTINCT

Specified by:
supportsSelectDistinct in interface ConnectorCapabilities
Overrides:
supportsSelectDistinct in class BasicConnectorCapabilities

supportsSelfJoins

public boolean supportsSelfJoins()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept self-joins where a group is joined to itself with aliases. Connector must also support ConnectorCapabilities.supportsAliasedGroup().

Specified by:
supportsSelfJoins in interface ConnectorCapabilities
Overrides:
supportsSelfJoins in class BasicConnectorCapabilities

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 BasicConnectorCapabilities
See Also:
ConnectorCapabilities.supportsInlineViews()

supportsQuantifiedCompareCriteriaSome

public boolean supportsQuantifiedCompareCriteriaSome()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts the quantified comparison criteria that use SOME

Specified by:
supportsQuantifiedCompareCriteriaSome in interface ConnectorCapabilities
Overrides:
supportsQuantifiedCompareCriteriaSome in class BasicConnectorCapabilities
See Also:
ConnectorCapabilities.supportsQuantifiedCompareCriteriaSome()

supportsSetQueryOrderBy

public boolean supportsSetQueryOrderBy()
Description copied from interface: ConnectorCapabilities
Support indicates that the connector supports an ORDER BY on a SetQuery.

Specified by:
supportsSetQueryOrderBy in interface ConnectorCapabilities
Overrides:
supportsSetQueryOrderBy in class BasicConnectorCapabilities
See Also:
BasicConnectorCapabilities.supportsSetQueryOrderBy()

supportsUnions

public boolean supportsUnions()
Description copied from interface: ConnectorCapabilities
Support indicates that the connector supports the UNION of two queries.

Specified by:
supportsUnions in interface ConnectorCapabilities
Overrides:
supportsUnions in class BasicConnectorCapabilities
See Also:
ConnectorCapabilities.supportsUnions()

supportsBulkUpdate

public boolean supportsBulkUpdate()
Description copied from interface: ConnectorCapabilities
Whether the source supports updates with multiple value sets

Specified by:
supportsBulkUpdate in interface ConnectorCapabilities
Overrides:
supportsBulkUpdate in class BasicConnectorCapabilities

supportsBatchedUpdates

public boolean supportsBatchedUpdates()
Description copied from interface: ConnectorCapabilities
Whether the source supports IBatchedUpdates

Specified by:
supportsBatchedUpdates in interface ConnectorCapabilities
Overrides:
supportsBatchedUpdates in class BasicConnectorCapabilities

supportsCompareCriteriaOrdered

public boolean supportsCompareCriteriaOrdered()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts criteria of form (element <=|>= constant)
The query engine will may pushdown queries containing < or > if NOT is also supported.

Specified by:
supportsCompareCriteriaOrdered in interface ConnectorCapabilities
Overrides:
supportsCompareCriteriaOrdered in class BasicConnectorCapabilities

getSupportedJoinCriteria

public ConnectorCapabilities.SupportedJoinCriteria getSupportedJoinCriteria()
Description copied from interface: ConnectorCapabilities
Get the supported join criteria. A null return value will be treated as ConnectorCapabilities.SupportedJoinCriteria.ANY

Specified by:
getSupportedJoinCriteria in interface ConnectorCapabilities
Overrides:
getSupportedJoinCriteria in class BasicConnectorCapabilities

supportsHaving

public boolean supportsHaving()
Description copied from interface: ConnectorCapabilities
Whether the source supports the HAVING clause

Specified by:
supportsHaving in interface ConnectorCapabilities
Overrides:
supportsHaving in class BasicConnectorCapabilities

supportsInnerJoins

public boolean supportsInnerJoins()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept inner or cross joins

Specified by:
supportsInnerJoins in interface ConnectorCapabilities
Overrides:
supportsInnerJoins in class BasicConnectorCapabilities

supportsSelectExpression

public boolean supportsSelectExpression()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept expressions other than element symbols in the SELECT clause. Specific supports for the expression type are still checked.

Specified by:
supportsSelectExpression in interface ConnectorCapabilities
Overrides:
supportsSelectExpression in class BasicConnectorCapabilities

supportsInsertWithQueryExpression

public boolean supportsInsertWithQueryExpression()
Description copied from interface: ConnectorCapabilities
Support indicates that the connector can accept INSERTs with values specified by an ISetQuery.

Specified by:
supportsInsertWithQueryExpression in interface ConnectorCapabilities
Overrides:
supportsInsertWithQueryExpression in class BasicConnectorCapabilities


Copyright © 2009. All Rights Reserved.