OracleExecutionFactory (Teiid 10.0.0.Final API)

java.lang.Object
- org.teiid.translator.ExecutionFactory<DataSource,Connection>
- - org.teiid.translator.jdbc.JDBCExecutionFactory
  - - org.teiid.translator.jdbc.oracle.OracleExecutionFactory

@Translator(name="oracle",
            description="A translator for Oracle 9i Database or later")
public class OracleExecutionFactory
extends JDBCExecutionFactory

Nested Class Summary
- 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 String`	`DUAL`
`static Version`	`ELEVEN_2`
`static Version`	`ELEVEN_2_0_4`
`static String`	`FILTER`
`static String`	`HINT_PREFIX`
`static String`	`HINT_SUFFIX`
`static String`	`NEAREST_NEIGHBOR`
`static String`	`NEAREST_NEIGHBOR_DISTANCE`
`static Version`	`NINE_0`
`static Version`	`NINE_2`
`static String`	`ORACLE`
`static String`	`ORACLE_SDO`
`static String`	`RELATE`
`static String`	`ROWNUM`
`static String`	`SEQUENCE`
`static Version`	`TWELVE`
`static String`	`WITHIN_DISTANCE`

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

Constructor Summary

Constructors
Constructor and Description

OracleExecutionFactory()

Constructors
Constructor and Description
`OracleExecutionFactory()`

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`void`	`bindValue(PreparedStatement stmt, Object param, Class<?> paramType, int i)` Sets prepared statement parameter i with param.
`protected JDBCMetadataProcessor`	`createMetadataProcessor()` Deprecated.
`String`	`createTempTable(String string, List<ColumnReference> cols, ExecutionContext context, Connection connection)` Create a temp table with the given name prefix and columns
`ResultSet`	`executeStoredProcedure(CallableStatement statement, List<Argument> preparedValues, Class<?> returnType)` This is a generic implementation.
`String`	`getCreateTemporaryTablePostfix(boolean inTransaction)`
`String`	`getCreateTemporaryTableString(boolean inTransaction)`
`ExecutionFactory.NullOrder`	`getDefaultNullOrder()` Returns the default null ordering
`String`	`getHibernateDialectClassName()`
`MetadataProcessor<Connection>`	`getMetadataProcessor()` Get a MetadataProcessor for the translator to read the metadata.
`String`	`getSetOperationString(SetQuery.Operation operation)` Returns the name for a given `SetQuery.Operation`
`String`	`getSourceComment(ExecutionContext context, Command command)` Returns the source comment for the given command
`SQLConversionVisitor`	`getSQLConversionVisitor()` Create the `SQLConversionVisitor` that will perform translation.
`List<String>`	`getSupportedFunctions()` Get list of all supported function names.
`String`	`getTemporaryTableName(String prefix)` uses a random table name strategy with a retry in the `createTempTable(String, List, ExecutionContext, Connection)` method
`void`	`handleInsertSequences(Insert insert)`
`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()`
`void`	`intializeConnectionAfterCancel(Connection c)` Implemented if the `Connection` needs initialized after a statement cancel
`boolean`	`isOracleSuppliedDriver()`
`protected void`	`registerSpecificTypeOfOutParameter(CallableStatement statement, Class<?> runtimeType, int index)` For registering specific output parameter types we need to translate these into the appropriate java.sql.Types output parameters We will need to match these up with the appropriate standard sql types
`String`	`replaceElementName(String group, String element)` Don't fully qualify elements if table = DUAL or element = ROWNUM or special stuff is packed into name in source value.
`Object`	`retrieveGeometryValue(ResultSet results, int paramIndex)`
`void`	`setOracleSuppliedDriver(boolean oracleNative)`
`void`	`start()` Initialize the connector with supplied configuration
`boolean`	`supportsAggregatesEnhancedNumeric()` Support indicates connector can accept STDDEV_POP, STDDEV_VAR, VAR_POP, VAR_SAMP
`boolean`	`supportsArrayType()` The engine uses array types for dependent joins and for array expression.
`protected boolean`	`supportsBooleanExpressions()` if boolean expressions are directly supported.
`boolean`	`supportsCommonTableExpressions()`
`boolean`	`supportsConvert(int fromType, int toType)` Used for fine grained control of convert/cast pushdown.
`boolean`	`supportsCorrelatedSubqueryLimit()`
`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)`
`protected boolean`	`supportsGeneratedKeys(ExecutionContext context, Command command)`
`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`	`supportsLikeRegex()`
`boolean`	`supportsOnlyFormatLiterals()` See also `ExecutionFactory.supportsFormatLiteral(String, Format)`
`boolean`	`supportsOrderByNullOrdering()` Returns whether the database supports explicit null ordering.
`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`	`supportsSelectExpressionArrayType()`
`boolean`	`supportsSelectWithoutFrom()`
`boolean`	`supportsSubqueryInOn()` Refines subquery support.
`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)` Return a List of translated parts (`LanguageObject`s and Objects), or null if to rely on the default translation.
`Expression`	`translateGeometrySelect(Expression expr)` Translate GEOMETRY column reference into an expression that will return SRID & WKB.
`String`	`translateLiteralBinaryType(BinaryType obj)` Subclasses should override this method to provide a different sql translation of the literal varbinary value.
`String`	`translateLiteralTimestamp(Timestamp timestampValue)` Subclasses should override this method to provide a different sql translation of the literal timestamp value.
`boolean`	`useAsInGroupAlias()` Indicates whether group alias should be of the form "...FROM groupA AS X" or "...FROM groupA X".
`boolean`	`useColumnNamesForGeneratedKeys()`
`protected boolean`	`usesDatabaseVersion()`
`boolean`	`useStreamsForLobs()` If streams should be used for Blob/Clob sets on `PreparedStatement`s

Methods inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory
addSourceComment, afterInitialConnectionObtained, closeConnection, convertObject, createDirectExecution, createProcedureExecution, createResultSetExecution, createUpdateExecution, formatDateValue, formatDateValue, getCommentFormat, getConnection, getCreateTempTableSQL, getDatabaseCalendar, getDatabaseTimeZone, getDatabaseVersion, getDefaultSupportedFunctions, getDialect, getFunctionModifiers, getLateralKeyword, getLikeRegexString, getMaxPreparedInsertBatchSize, getMetadata, getStructRetrieval, getTimestampNanoPrecision, getVersion, isEnableDependentJoins, isSourceRequired, isSourceRequiredForCapabilities, isTrimStrings, loadedTemporaryTable, obtainedConnection, parseName, registerFunctionModifier, retrieveGeometryValue, retrieveValue, retrieveValue, setCommentFormat, setDatabaseTimeZone, setDatabaseVersion, setDatabaseVersion, setEnableDependentJoins, setFetchSize, setMaxPreparedInsertBatchSize, setStructRetrieval, setTrimStrings, setUseBindingsForDependentJoin, setUseBindVariables, setUseCommentsInSourceQuery, supportsAggregatesAvg, supportsAggregatesCount, supportsAggregatesCountStar, supportsAggregatesDistinct, supportsAggregatesMax, supportsAggregatesMin, supportsAggregatesSum, supportsAliasedTable, supportsBatchedUpdates, supportsBulkUpdate, supportsCompareCriteriaEquals, supportsCompareCriteriaOrdered, supportsCorrelatedSubqueries, supportsDependentJoins, supportsExistsCriteria, supportsFullDependentJoins, supportsGeneratedKeys, supportsGroupBy, supportsHaving, supportsInCriteria, supportsInCriteriaSubquery, supportsInsertWithQueryExpression, supportsIsNullCriteria, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsNotCriteria, supportsOrCriteria, supportsOrderByUnrelated, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsScalarSubqueries, supportsSearchedCaseExpressions, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions, tempTableRequiresTransaction, translateGeometryLiteral, translateLimit, translateLiteralBoolean, translateLiteralDate, translateLiteralTime, useBindingsForDependentJoin, useBindVariables, useCommentsInSourceQuery, useParensForJoins, useParensForSetQueries, usePreparedStatements, useScientificNotation, useSelectLimit, useUnicodePrefix, useWithRollup

Methods inherited from class org.teiid.translator.ExecutionFactory
addPushDownFunction, areLobsUsableAfterClose, createExecution, getCacheDirective, getCollationLocale, getConnection, getDirectQueryProcedureName, getExcludedCommonTableExpressionName, getInstance, getLanguageFactory, getMaxDependentInPredicates, getMaxFromGroups, getMaxInCriteriaSize, 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, supportsCompareCriteriaOrderedExclusive, supportsDirectQueryProcedure, supportsFullOuterJoins, supportsGroupByMultipleDistinctAggregates, supportsInnerJoins, supportsIsDistinctCriteria, supportsLateralJoin, supportsLateralJoinCondition, supportsNativeQueries, supportsOnlyCorrelatedSubqueries, supportsOnlyLiteralComparison, supportsOnlySingleTableGroupBy, supportsOrderBy, supportsOrderByWithExtendedGrouping, supportsOuterJoins, supportsPartialFiltering, supportsProcedureTable, supportsScalarSubqueryProjection, supportsSelectDistinct, supportsSetQueryLimitOffset, supportsSimilarTo, supportsStringAgg, supportsSubqueryCommonTableExpressions, supportsUpsert, supportsWindowDistinctAggregates, supportsWindowOrderByWithAggregates, useAnsiJoin

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - NINE_0
```
public static final Version NINE_0
```
  - NINE_2
```
public static final Version NINE_2
```
  - ELEVEN_2_0_4
```
public static final Version ELEVEN_2_0_4
```
  - ELEVEN_2
```
public static final Version ELEVEN_2
```
  - TWELVE
```
public static final Version TWELVE
```
  - HINT_PREFIX
```
public static final String HINT_PREFIX
```
    See Also:
    
    Constant Field Values
  - HINT_SUFFIX
```
public static final String HINT_SUFFIX
```
    See Also:
    
    Constant Field Values
  - DUAL
```
public static final String DUAL
```
    See Also:
    
    Constant Field Values
  - ROWNUM
```
public static final String ROWNUM
```
    See Also:
    
    Constant Field Values
  - SEQUENCE
```
public static final String SEQUENCE
```
    See Also:
    
    Constant Field Values
  - RELATE
```
public static final String RELATE
```
    See Also:
    
    Constant Field Values
  - NEAREST_NEIGHBOR
```
public static final String NEAREST_NEIGHBOR
```
    See Also:
    
    Constant Field Values
  - FILTER
```
public static final String FILTER
```
    See Also:
    
    Constant Field Values
  - WITHIN_DISTANCE
```
public static final String WITHIN_DISTANCE
```
    See Also:
    
    Constant Field Values
  - NEAREST_NEIGHBOR_DISTANCE
```
public static final String NEAREST_NEIGHBOR_DISTANCE
```
    See Also:
    
    Constant Field Values
  - ORACLE_SDO
```
public static final String ORACLE_SDO
```
    See Also:
    
    Constant Field Values
  - ORACLE
```
public static final String ORACLE
```
    See Also:
    
    Constant Field Values
- Constructor Detail
  - OracleExecutionFactory
```
public OracleExecutionFactory()
```
- Method Detail
  - start
```
public void start()
           throws TranslatorException
```
    Description copied from class: ExecutionFactory
    
    Initialize the connector with supplied configuration
    
    Overrides:
    
    start in class JDBCExecutionFactory
    
    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 JDBCExecutionFactory
    
    Throws:
    
    TranslatorException
  - handleInsertSequences
```
public void handleInsertSequences(Insert insert)
                           throws TranslatorException
```
    Throws:
    
    TranslatorException
  - translateCommand
```
public List<?> translateCommand(Command command,
                                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:
    
    translateCommand in class JDBCExecutionFactory
    
    Returns:
    
    a list of translated parts
  - useAsInGroupAlias
```
public boolean useAsInGroupAlias()
```
    Description copied from class: JDBCExecutionFactory
    
    Indicates whether group alias should be of the form "...FROM groupA AS X" or "...FROM groupA X". Certain data sources (such as Oracle) may not support the first form.
    
    Overrides:
    
    useAsInGroupAlias in class JDBCExecutionFactory
    
    Returns:
    
    boolean
  - getSetOperationString
```
public String getSetOperationString(SetQuery.Operation operation)
```
    Description copied from class: JDBCExecutionFactory
    
    Returns the name for a given SetQuery.Operation
    
    Overrides:
    
    getSetOperationString in class JDBCExecutionFactory
    
    Returns:
    
    the name for the set operation
  - getSourceComment
```
public String getSourceComment(ExecutionContext context,
                               Command command)
```
    Description copied from class: JDBCExecutionFactory
    
    Returns the source comment for the given command
    
    Overrides:
    
    getSourceComment in class JDBCExecutionFactory
    
    Returns:
    
    the comment
  - replaceElementName
```
public String replaceElementName(String group,
                                 String element)
```
    Don't fully qualify elements if table = DUAL or element = ROWNUM or special stuff is packed into name in source value.
    
    Overrides:
    
    replaceElementName in class JDBCExecutionFactory
    
    Returns:
    
    thre replacement name
    
    Since:
    
    5.0
    
    See Also:
    
    org.teiid.language.visitor.SQLStringVisitor#skipGroupInElement(java.lang.String, java.lang.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 JDBCExecutionFactory
    
    Returns:
    
    true if database has a time type
  - bindValue
```
public void bindValue(PreparedStatement stmt,
                      Object param,
                      Class<?> paramType,
                      int i)
               throws SQLException
```
    Description copied from class: JDBCExecutionFactory
    
    Sets prepared statement parameter i with param. Performs special handling to translate dates using the database time zone and to translate biginteger, float, and char to JDBC safe objects.
    
    Overrides:
    
    bindValue in class JDBCExecutionFactory
    
    Throws:
    
    SQLException
  - 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:
  - getDefaultNullOrder
```
public ExecutionFactory.NullOrder getDefaultNullOrder()
```
    Description copied from class: ExecutionFactory
    
    Returns the default null ordering
    
    Overrides:
    
    getDefaultNullOrder in class JDBCExecutionFactory
    
    Returns:
    
    the ExecutionFactory.NullOrder
  - supportsOrderByNullOrdering
```
public boolean supportsOrderByNullOrdering()
```
    Description copied from class: ExecutionFactory
    
    Returns whether the database supports explicit null ordering.
    
    Overrides:
    
    supportsOrderByNullOrdering in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if nulls first/last can be specified
  - getSQLConversionVisitor
```
public SQLConversionVisitor getSQLConversionVisitor()
```
    Description copied from class: JDBCExecutionFactory
    
    Create the SQLConversionVisitor that will perform translation. Typical custom JDBC connectors will not need to create custom conversion visitors, rather implementors should override existing JDBCExecutionFactory methods.
    
    Overrides:
    
    getSQLConversionVisitor in class JDBCExecutionFactory
    
    Returns:
    
    the SQLConversionVisitor
  - 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 JDBCExecutionFactory
    
    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.
  - 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 JDBCExecutionFactory
    
    Parameters:
    
    timestampValue - Timestamp value, never null
    
    Returns:
    
    Translated string
  - 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 JDBCExecutionFactory
  - 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 ExecutionFactory<DataSource,Connection>
  - 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 ExecutionFactory<DataSource,Connection>
  - 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>
  - 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>
  - 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>
  - 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 ExecutionFactory<DataSource,Connection>
  - 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
  - supportsLikeRegex
```
public boolean supportsLikeRegex()
```
    Overrides:
    
    supportsLikeRegex in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if the LIKE_REGEX predicate is supported
  - setOracleSuppliedDriver
```
public void setOracleSuppliedDriver(boolean oracleNative)
```
  - isOracleSuppliedDriver
```
@TranslatorProperty(display="Oracle Supplied Driver",
                    description="True if the driver is an Oracle supplied driver",
                    advanced=true)
public boolean isOracleSuppliedDriver()
```
  - registerSpecificTypeOfOutParameter
```
protected void registerSpecificTypeOfOutParameter(CallableStatement statement,
                                                  Class<?> runtimeType,
                                                  int index)
                                           throws SQLException
```
    Description copied from class: JDBCExecutionFactory
    
    For registering specific output parameter types we need to translate these into the appropriate java.sql.Types output parameters We will need to match these up with the appropriate standard sql types
    
    Overrides:
    
    registerSpecificTypeOfOutParameter in class JDBCExecutionFactory
    
    Throws:
    
    SQLException
  - executeStoredProcedure
```
public ResultSet executeStoredProcedure(CallableStatement statement,
                                        List<Argument> preparedValues,
                                        Class<?> returnType)
                                 throws SQLException
```
    Description copied from class: JDBCExecutionFactory
    
    This is a generic implementation. Because different databases handle stored procedures differently, subclasses should override this method if necessary.
    
    Overrides:
    
    executeStoredProcedure in class JDBCExecutionFactory
    
    Throws:
    
    SQLException
  - supportsOnlyFormatLiterals
```
public boolean supportsOnlyFormatLiterals()
```
    Description copied from class: ExecutionFactory
    
    See also ExecutionFactory.supportsFormatLiteral(String, Format)
    
    Overrides:
    
    supportsOnlyFormatLiterals in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if only literal formats are supports.
  - supportsFormatLiteral
```
public boolean supportsFormatLiteral(String literal,
                                     ExecutionFactory.Format format)
```
    Overrides:
    
    supportsFormatLiteral in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if the given Java format string is supported
  - supportsArrayType
```
public boolean supportsArrayType()
```
    Description copied from class: ExecutionFactory
    
    The engine uses array types for dependent joins and for array expression.
    
    Overrides:
    
    supportsArrayType in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if an array type is supported.
  - 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:
  - supportsCommonTableExpressions
```
public boolean supportsCommonTableExpressions()
```
    Overrides:
    
    supportsCommonTableExpressions in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if the WITH clause is supported
  - supportsRecursiveCommonTableExpressions
```
public boolean supportsRecursiveCommonTableExpressions()
```
    Overrides:
    
    supportsRecursiveCommonTableExpressions in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if a recursive WITH clause item is supported
  - supportsGeneratedKeys
```
protected boolean supportsGeneratedKeys(ExecutionContext context,
                                        Command command)
```
    Overrides:
    
    supportsGeneratedKeys in class JDBCExecutionFactory
    
    Returns:
    
    true if generated keys can be returned
  - usesDatabaseVersion
```
protected boolean usesDatabaseVersion()
```
    Overrides:
    
    usesDatabaseVersion in class JDBCExecutionFactory
  - supportsSelectWithoutFrom
```
public boolean supportsSelectWithoutFrom()
```
    Overrides:
    
    supportsSelectWithoutFrom in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if the translator support SELECT without a FROM clause
  - createTempTable
```
public String createTempTable(String string,
                              List<ColumnReference> cols,
                              ExecutionContext context,
                              Connection connection)
                       throws SQLException
```
    Description copied from class: JDBCExecutionFactory
    
    Create a temp table with the given name prefix and columns
    
    Overrides:
    
    createTempTable in class JDBCExecutionFactory
    
    Returns:
    
    the name of the table created
    
    Throws:
    
    SQLException
  - getTemporaryTableName
```
public String getTemporaryTableName(String prefix)
```
    uses a random table name strategy with a retry in the createTempTable(String, List, ExecutionContext, Connection) method
    
    Overrides:
    
    getTemporaryTableName in class JDBCExecutionFactory
    
    Returns:
    
    a valid temporary table name
  - getCreateTemporaryTablePostfix
```
public String getCreateTemporaryTablePostfix(boolean inTransaction)
```
    Overrides:
    
    getCreateTemporaryTablePostfix in class JDBCExecutionFactory
    
    Returns:
    
    the post script for the temp table create
  - getCreateTemporaryTableString
```
public String getCreateTemporaryTableString(boolean inTransaction)
```
    Overrides:
    
    getCreateTemporaryTableString in class JDBCExecutionFactory
    
    Returns:
    
    the temp table creation ddl
  - getHibernateDialectClassName
```
public String getHibernateDialectClassName()
```
    Overrides:
    
    getHibernateDialectClassName in class JDBCExecutionFactory
  - supportsGroupByRollup
```
public boolean supportsGroupByRollup()
```
    Overrides:
    
    supportsGroupByRollup in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if the translator support GROUP BY ROLLUP
  - translateGeometrySelect
```
public Expression translateGeometrySelect(Expression expr)
```
    Description copied from class: JDBCExecutionFactory
    
    Translate GEOMETRY column reference into an expression that will return SRID & WKB.
    
    Overrides:
    
    translateGeometrySelect in class JDBCExecutionFactory
    
    Returns:
  - retrieveGeometryValue
```
public Object retrieveGeometryValue(ResultSet results,
                                    int paramIndex)
                             throws SQLException
```
    Overrides:
    
    retrieveGeometryValue in class JDBCExecutionFactory
    
    Throws:
    
    SQLException
  - intializeConnectionAfterCancel
```
public void intializeConnectionAfterCancel(Connection c)
                                    throws SQLException
```
    Description copied from class: JDBCExecutionFactory
    
    Implemented if the Connection needs initialized after a statement cancel
    
    Overrides:
    
    intializeConnectionAfterCancel in class JDBCExecutionFactory
    
    Throws:
    
    SQLException
  - supportsCorrelatedSubqueryLimit
```
public boolean supportsCorrelatedSubqueryLimit()
```
    Overrides:
    
    supportsCorrelatedSubqueryLimit in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if a correlated subquery can support a limit clause
  - useColumnNamesForGeneratedKeys
```
public boolean useColumnNamesForGeneratedKeys()
```
    Overrides:
    
    useColumnNamesForGeneratedKeys in class JDBCExecutionFactory
    
    Returns:
    
    true if column names are required to retrieve generated keys
  - translateLiteralBinaryType
```
public String translateLiteralBinaryType(BinaryType obj)
```
    Description copied from class: JDBCExecutionFactory
    
    Subclasses should override this method to provide a different sql translation of the literal varbinary value. By default, a varbinary literal is represented as: X'hex value'
    
    Overrides:
    
    translateLiteralBinaryType in class JDBCExecutionFactory
    
    Parameters:
    
    obj - value, never null
    
    Returns:
    
    Translated string
  - supportsSubqueryInOn
```
public boolean supportsSubqueryInOn()
```
    Description copied from class: ExecutionFactory
    
    Refines subquery support.
    
    Overrides:
    
    supportsSubqueryInOn in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if subqueries are supported in the on clause.
  - 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.
  - supportsBooleanExpressions
```
protected boolean supportsBooleanExpressions()
```
    Description copied from class: JDBCExecutionFactory
    
    if boolean expressions are directly supported. will generally be false if there is no boolean datatype
    
    Overrides:
    
    supportsBooleanExpressions in class JDBCExecutionFactory
    
    Returns:
  - supportsSelectExpressionArrayType
```
public boolean supportsSelectExpressionArrayType()
```
    Overrides:
    
    supportsSelectExpressionArrayType in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    
    true if array type expressions can be projected
  - 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 JDBCExecutionFactory
    
    Returns:
    
    list of translated parts

Class OracleExecutionFactory

Nested Class Summary

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.JDBCExecutionFactory

Fields inherited from class org.teiid.translator.ExecutionFactory

Constructor Summary

Method Summary

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

NINE_0

NINE_2

ELEVEN_2_0_4

ELEVEN_2

TWELVE

HINT_PREFIX

HINT_SUFFIX

DUAL

ROWNUM

SEQUENCE

RELATE

NEAREST_NEIGHBOR

FILTER

WITHIN_DISTANCE

NEAREST_NEIGHBOR_DISTANCE

ORACLE_SDO

ORACLE

Constructor Detail

OracleExecutionFactory

Method Detail

start

initCapabilities

handleInsertSequences

translateCommand

useAsInGroupAlias

getSetOperationString

getSourceComment

replaceElementName

hasTimeType

bindValue

useStreamsForLobs

getDefaultNullOrder

supportsOrderByNullOrdering

getSQLConversionVisitor

getSupportedFunctions

translateLiteralTimestamp

supportsInlineViews

supportsFunctionsInGroupBy

supportsRowLimit

supportsRowOffset

supportsExcept

supportsIntersect

supportsAggregatesEnhancedNumeric

supportsElementaryOlapOperations

supportsLikeRegex

setOracleSuppliedDriver

isOracleSuppliedDriver

registerSpecificTypeOfOutParameter

executeStoredProcedure

supportsOnlyFormatLiterals

supportsFormatLiteral

supportsArrayType

createMetadataProcessor

getMetadataProcessor

supportsCommonTableExpressions

supportsRecursiveCommonTableExpressions

supportsGeneratedKeys

usesDatabaseVersion

supportsSelectWithoutFrom

createTempTable

getTemporaryTableName

getCreateTemporaryTablePostfix

getCreateTemporaryTableString

getHibernateDialectClassName

supportsGroupByRollup

translateGeometrySelect

retrieveGeometryValue