|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface ConnectorCapabilities
Allows a connector to specify the capabilities that a connector supports.
Nested Class Summary | |
---|---|
static class |
ConnectorCapabilities.SupportedJoinCriteria
|
Method Summary | |
---|---|
int |
getMaxFromGroups()
The number of groups supported in the from clause. |
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()
Get list of all supported function names. |
ConnectorCapabilities.SupportedJoinCriteria |
getSupportedJoinCriteria()
Get the supported join criteria. |
boolean |
requiresCriteria()
Whether the source supports queries without 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 |
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 |
supportsExcept()
Support indicates that the connector supports the EXCEPT of two queries. |
boolean |
supportsExistsCriteria()
Support indicates connector accepts the EXISTS criteria |
boolean |
supportsFullOuterJoins()
Support indicates connector can accept full outer joins |
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 |
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 |
supportsIntersect()
Support indicates that the connector supports the INTERSECT of two queries. |
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 |
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 |
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 |
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. |
boolean |
useAnsiJoin()
Whether the source prefers to use ANSI style joins. |
Method Detail |
---|
boolean supportsSelectDistinct()
boolean supportsSelectExpression()
boolean supportsAliasedGroup()
ConnectorCapabilities.SupportedJoinCriteria getSupportedJoinCriteria()
ConnectorCapabilities.SupportedJoinCriteria.ANY
boolean supportsInnerJoins()
boolean supportsSelfJoins()
supportsAliasedGroup()
.
boolean supportsOuterJoins()
boolean supportsFullOuterJoins()
boolean supportsInlineViews()
boolean supportsBetweenCriteria()
boolean supportsCompareCriteriaEquals()
boolean supportsCompareCriteriaOrdered()
boolean supportsLikeCriteria()
boolean supportsLikeCriteriaEscapeCharacter()
boolean supportsInCriteria()
boolean supportsInCriteriaSubquery()
boolean supportsIsNullCriteria()
boolean supportsOrCriteria()
boolean supportsNotCriteria()
boolean supportsExistsCriteria()
boolean supportsQuantifiedCompareCriteriaSome()
boolean supportsQuantifiedCompareCriteriaAll()
boolean supportsOrderBy()
boolean supportsGroupBy()
boolean supportsHaving()
boolean supportsAggregatesSum()
boolean supportsAggregatesAvg()
boolean supportsAggregatesMin()
boolean supportsAggregatesMax()
boolean supportsAggregatesCount()
boolean supportsAggregatesCountStar()
boolean supportsAggregatesDistinct()
boolean supportsScalarSubqueries()
boolean supportsCorrelatedSubqueries()
boolean supportsCaseExpressions()
boolean supportsSearchedCaseExpressions()
boolean supportsUnions()
boolean supportsSetQueryOrderBy()
boolean supportsIntersect()
boolean supportsExcept()
java.util.List<java.lang.String> getSupportedFunctions()
int getMaxInCriteriaSize()
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 supportsRowLimit()
boolean supportsRowOffset()
int getMaxFromGroups()
boolean useAnsiJoin()
boolean requiresCriteria()
boolean supportsBatchedUpdates()
IBatchedUpdates
boolean supportsBulkUpdate()
boolean supportsInsertWithQueryExpression()
ISetQuery
.
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |