org.teiid.connector.jdbc
Class SimpleCapabilities

java.lang.Object
  extended by org.teiid.connector.basic.BasicConnectorCapabilities
      extended by org.teiid.connector.jdbc.JDBCCapabilities
          extended by org.teiid.connector.jdbc.SimpleCapabilities
All Implemented Interfaces:
ConnectorCapabilities

public class SimpleCapabilities
extends JDBCCapabilities
implements ConnectorCapabilities

This is a "simple" capabilities class that allows criteria but no complicated joins, subqueries, etc to be passed to the connector. This capabilities class may come in handy for testing and for sources that support JDBC but don't support extended JDBC capabilities.


Field Summary
 
Fields inherited from class org.teiid.connector.jdbc.JDBCCapabilities
DEFAULT_JDBC_MAX_IN_CRITERIA_SIZE
 
Fields inherited from class org.teiid.connector.basic.BasicConnectorCapabilities
maxInCriteriaSize
 
Constructor Summary
SimpleCapabilities()
           
 
Method Summary
 java.util.List getSupportedFunctions()
          Return null to indicate no functions are supported.
 boolean supportsAggregates()
          Support indicates connector accepts GROUP BY and HAVING clauses as well as aggregate functions in the SELECT clause.
 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 supportsAndCriteria()
          Support indicates connector accepts logical criteria connected by AND
 boolean supportsBetweenCriteria()
          Support indicates connector accepts criteria of form (element BETWEEN constant AND constant)
 boolean supportsCaseExpressions()
          Support indicates connector can accept queries with non-searched CASE WHEN ...
 boolean supportsCompareCriteria()
          Support indicates connector accepts criteria of form (element operator constant)
 boolean supportsCompareCriteriaEquals()
          Support indicates connector accepts criteria of form (element = constant)
 boolean supportsCompareCriteriaGreaterThan()
          Support indicates connector accepts criteria of form (element > constant)
 boolean supportsCompareCriteriaGreaterThanOrEqual()
          Support indicates connector accepts criteria of form (element >= constant)
 boolean supportsCompareCriteriaLessThan()
          Support indicates connector accepts criteria of form (element < constant)
 boolean supportsCompareCriteriaLessThanOrEqual()
          Support indicates connector accepts criteria of form (element <= constant)
 boolean supportsCompareCriteriaNotEquals()
          Support indicates connector accepts criteria of form (element <> constant)
 boolean supportsCorrelatedSubqueries()
          Support indicates connector can accept correalted subqueries wherever subqueries are accepted
 boolean supportsCriteria()
          Support indicates connector can accept a WHERE criteria on queries
 boolean supportsExistsCriteria()
          Support indicates connector accepts the EXISTS criteria
 boolean supportsFullOuterJoins()
          Support indicates connector can accept full outer joins
 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 supportsIsNullCriteria()
          Support indicates connector accepts criteria of form (element IS NULL)
 boolean supportsJoins()
          Support indicates connector can accept joins
 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) - CURRENTLY NOT USED
 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 supportsOrderByInInlineViews()
           
 boolean supportsOuterJoins()
          Support indicates connector can accept right or left outer joins
 boolean supportsQuantifiedCompareCriteria()
          Support indicates connector accepts quantified subquery comparison criteria
 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 supportsScalarFunctions()
          Support indicates that the connector supports scalar functions.
 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 supportsSelectLiterals()
          Support indicates connector can accept literals in the SELECT clause
 boolean supportsSelfJoins()
          Support indicates connector can accept self-joins where a group is joined to itself with aliases.
 boolean supportsUnionOrderBy()
           
 boolean supportsUnions()
          Support indicates that the connector supports the UNION of two queries.
 
Methods inherited from class org.teiid.connector.jdbc.JDBCCapabilities
getMaxInCriteriaSize, setMaxInCriteriaSize, supportsBatchedUpdates, supportsBulkInsert, supportsSetQueryOrderBy
 
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
 
Methods inherited from interface org.teiid.connector.api.ConnectorCapabilities
getMaxFromGroups, getMaxInCriteriaSize, requiresCriteria, supportsBatchedUpdates, supportsBulkInsert, supportsExcept, supportsFunctionsInGroupBy, supportsIntersect, supportsRowLimit, supportsRowOffset, supportsSetQueryOrderBy, useAnsiJoin
 

Constructor Detail

SimpleCapabilities

public SimpleCapabilities()
Method Detail

supportsAndCriteria

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

Specified by:
supportsAndCriteria in interface ConnectorCapabilities
Overrides:
supportsAndCriteria in class JDBCCapabilities

supportsCompareCriteria

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

Specified by:
supportsCompareCriteria in interface ConnectorCapabilities
Overrides:
supportsCompareCriteria in class JDBCCapabilities

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 JDBCCapabilities

supportsCompareCriteriaGreaterThan

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

Specified by:
supportsCompareCriteriaGreaterThan in interface ConnectorCapabilities
Overrides:
supportsCompareCriteriaGreaterThan in class JDBCCapabilities

supportsCompareCriteriaGreaterThanOrEqual

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

Specified by:
supportsCompareCriteriaGreaterThanOrEqual in interface ConnectorCapabilities
Overrides:
supportsCompareCriteriaGreaterThanOrEqual in class JDBCCapabilities

supportsCompareCriteriaLessThan

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

Specified by:
supportsCompareCriteriaLessThan in interface ConnectorCapabilities
Overrides:
supportsCompareCriteriaLessThan in class JDBCCapabilities

supportsCompareCriteriaLessThanOrEqual

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

Specified by:
supportsCompareCriteriaLessThanOrEqual in interface ConnectorCapabilities
Overrides:
supportsCompareCriteriaLessThanOrEqual in class JDBCCapabilities

supportsCompareCriteriaNotEquals

public boolean supportsCompareCriteriaNotEquals()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts criteria of form (element <> constant)

Specified by:
supportsCompareCriteriaNotEquals in interface ConnectorCapabilities
Overrides:
supportsCompareCriteriaNotEquals in class JDBCCapabilities

supportsCriteria

public boolean supportsCriteria()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept a WHERE criteria on queries

Specified by:
supportsCriteria in interface ConnectorCapabilities
Overrides:
supportsCriteria in class JDBCCapabilities

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 JDBCCapabilities

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 JDBCCapabilities

supportsJoins

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

Specified by:
supportsJoins in interface ConnectorCapabilities
Overrides:
supportsJoins in class JDBCCapabilities

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 JDBCCapabilities

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 JDBCCapabilities

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 JDBCCapabilities

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 JDBCCapabilities

supportsSelectLiterals

public boolean supportsSelectLiterals()
Description copied from interface: ConnectorCapabilities
Support indicates connector can accept literals in the SELECT clause

Specified by:
supportsSelectLiterals in interface ConnectorCapabilities
Overrides:
supportsSelectLiterals in class JDBCCapabilities
Since:
4.2
See Also:
ConnectorCapabilities.supportsSelectLiterals()

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 JDBCCapabilities

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 JDBCCapabilities

supportsOuterJoins

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

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

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 JDBCCapabilities

supportsBetweenCriteria

public boolean supportsBetweenCriteria()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts criteria of form (element BETWEEN constant AND constant)

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

supportsLikeCriteriaEscapeCharacter

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

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

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 JDBCCapabilities

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 JDBCCapabilities

supportsQuantifiedCompareCriteria

public boolean supportsQuantifiedCompareCriteria()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts quantified subquery comparison criteria

Specified by:
supportsQuantifiedCompareCriteria in interface ConnectorCapabilities
Overrides:
supportsQuantifiedCompareCriteria in class JDBCCapabilities

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 JDBCCapabilities
See Also:
ConnectorCapabilities.supportsQuantifiedCompareCriteriaSome()

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 JDBCCapabilities

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 JDBCCapabilities

supportsAggregates

public boolean supportsAggregates()
Description copied from interface: ConnectorCapabilities
Support indicates connector accepts GROUP BY and HAVING clauses as well as aggregate functions in the SELECT clause.

Specified by:
supportsAggregates in interface ConnectorCapabilities
Overrides:
supportsAggregates in class JDBCCapabilities

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 JDBCCapabilities

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 JDBCCapabilities

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 JDBCCapabilities

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 JDBCCapabilities

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 JDBCCapabilities

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 JDBCCapabilities

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 JDBCCapabilities

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 JDBCCapabilities

supportsCorrelatedSubqueries

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

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

supportsCaseExpressions

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

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

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 JDBCCapabilities

supportsScalarFunctions

public boolean supportsScalarFunctions()
Description copied from interface: ConnectorCapabilities
Support indicates that the connector supports scalar functions.

Specified by:
supportsScalarFunctions in interface ConnectorCapabilities
Overrides:
supportsScalarFunctions in class JDBCCapabilities

getSupportedFunctions

public java.util.List getSupportedFunctions()
Return null to indicate no functions are supported.

Specified by:
getSupportedFunctions in interface ConnectorCapabilities
Overrides:
getSupportedFunctions in class JDBCCapabilities
Returns:
null
See Also:
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()

supportsOrderByInInlineViews

public boolean supportsOrderByInInlineViews()

supportsUnionOrderBy

public boolean supportsUnionOrderBy()
Since:
4.2
See Also:
org.teiid.connector.api.ConnectorCapabilities#supportsUnionOrderBy()

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 JDBCCapabilities
Since:
4.2
See Also:
ConnectorCapabilities.supportsUnions()


Copyright © 2009. All Rights Reserved.