org.teiid.connector.jdbc.oracle
Class OracleSQLTranslator

java.lang.Object
  org.teiid.connector.jdbc.translator.Translator
      org.teiid.connector.jdbc.oracle.OracleSQLTranslator

public class OracleSQLTranslator
extends Translator

Nested Class Summary

Nested classes/interfaces inherited from class org.teiid.connector.jdbc.translator.Translator

Translator.NullOrder

Field Summary

static java.lang.String	DUAL
static java.lang.String	FILTER
static java.lang.String	HINT_PREFIX
static java.lang.String	NEAREST_NEIGHBOR
static java.lang.String	NEAREST_NEIGHBOR_DISTANCE
static java.lang.String	RELATE
static java.lang.String	ROWNUM
static java.lang.String	SEQUENCE
static java.lang.String	WITHIN_DISTANCE

Fields inherited from class org.teiid.connector.jdbc.translator.Translator

DEFAULT_TIME_ZONE

Constructor Summary

OracleSQLTranslator()

Method Summary

void	afterInitialConnectionCreation(java.sql.Connection connection) Called exactly once for this source.
void	bindValue(java.sql.PreparedStatement stmt, java.lang.Object param, java.lang.Class<?> paramType, int i) Sets prepared statement parameter i with param.
java.lang.Class<? extends ConnectorCapabilities>	getDefaultCapabilities() Get the default capabilities class.
java.lang.String	getDefaultConnectionTestQuery()
Translator.NullOrder	getDefaultNullOrder() get the default null ordering
java.lang.String	getSetOperationString(ISetQuery.Operation operation) Returns the name for a given ISetQuery.Operation
java.lang.String	getSourceComment(ExecutionContext context, ICommand command) Returns the source comment for
void	handleInsertSequences(IInsert insert)
boolean	hasTimeType() Return false to indicate that time support should be emulated with timestamps.
void	initialize(ConnectorEnvironment env) Initialize the SQLTranslator.
java.lang.String	replaceElementName(java.lang.String group, java.lang.String element) Don't fully qualify elements if table = DUAL or element = ROWNUM or special stuff is packed into name in source value.
boolean	supportsExplicitNullOrdering()
java.util.List<?>	translateCommand(ICommand command, ExecutionContext context) Return a List of translated parts (ILanguageObjects and Objects), or null if to rely on the default translation.
boolean	useAsInGroupAlias() Indicates whether group alias should be of the form "...FROM groupA AS X" or "...FROM groupA X".

Methods inherited from class org.teiid.connector.jdbc.translator.Translator

addSourceComment, afterConnectionCreation, executeStoredProcedure, formatDateValue, getConnectionTestQuery, getConnectorCapabilities, getDatabaseCalendar, getEnvironment, getFunctionModifiers, getIsValidTimeout, getLanguageFactory, getSQLConversionVisitor, getTimestampNanoPrecision, getTypeFacility, registerFunctionModifier, registerSpecificTypeOfOutParameter, retrieveValue, retrieveValue, translate, translateLimit, translateLiteralBoolean, translateLiteralDate, translateLiteralTime, translateLiteralTimestamp, useParensForJoins, useParensForSetQueries, usePreparedStatements

Methods inherited from class java.lang.Object

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

Field Detail

RELATE

public static final java.lang.String RELATE

See Also:

Constant Field Values

NEAREST_NEIGHBOR

public static final java.lang.String NEAREST_NEIGHBOR

See Also:

Constant Field Values

FILTER

public static final java.lang.String FILTER

See Also:

Constant Field Values

WITHIN_DISTANCE

public static final java.lang.String WITHIN_DISTANCE

See Also:

Constant Field Values

NEAREST_NEIGHBOR_DISTANCE

public static final java.lang.String NEAREST_NEIGHBOR_DISTANCE

See Also:

Constant Field Values

HINT_PREFIX

public static final java.lang.String HINT_PREFIX

See Also:

Constant Field Values

DUAL

public static final java.lang.String DUAL

See Also:

Constant Field Values

ROWNUM

public static final java.lang.String ROWNUM

See Also:

Constant Field Values

SEQUENCE

public static final java.lang.String SEQUENCE

See Also:

Constant Field Values

Constructor Detail

OracleSQLTranslator

public OracleSQLTranslator()

Method Detail

initialize

public void initialize(ConnectorEnvironment env)
                throws ConnectorException

Description copied from class: Translator

Initialize the SQLTranslator.

Overrides:

initialize in class Translator

Throws:

ConnectorException

handleInsertSequences

public void handleInsertSequences(IInsert insert)
                           throws ConnectorException

Throws:

ConnectorException

translateCommand

public java.util.List<?> translateCommand(ICommand command,
                                          ExecutionContext context)

Description copied from class: Translator

Return a List of translated parts (ILanguageObjects and Objects), or null if to rely on the default translation.

Overrides:

translateCommand in class Translator

Returns:

useAsInGroupAlias

public boolean useAsInGroupAlias()

Description copied from class: Translator

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 Translator

Returns:

boolean

getSetOperationString

public java.lang.String getSetOperationString(ISetQuery.Operation operation)

Description copied from class: Translator

Returns the name for a given ISetQuery.Operation

Overrides:

getSetOperationString in class Translator

Returns:

getSourceComment

public java.lang.String getSourceComment(ExecutionContext context,
                                         ICommand command)

Description copied from class: Translator

Returns the source comment for

Overrides:

getSourceComment in class Translator

Returns:

replaceElementName

public java.lang.String replaceElementName(java.lang.String group,
                                           java.lang.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 Translator

Returns:

Since:

5.0

See Also:

org.teiid.connector.visitor.util.SQLStringVisitor#skipGroupInElement(java.lang.String, java.lang.String)

hasTimeType

public boolean hasTimeType()

Description copied from class: Translator

Return false to indicate that time support should be emulated with timestamps.

Overrides:

hasTimeType in class Translator

Returns:

getDefaultConnectionTestQuery

public java.lang.String getDefaultConnectionTestQuery()

Overrides:

getDefaultConnectionTestQuery in class Translator

bindValue

public void bindValue(java.sql.PreparedStatement stmt,
                      java.lang.Object param,
                      java.lang.Class<?> paramType,
                      int i)
               throws java.sql.SQLException

Description copied from class: Translator

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 Translator

Throws:

java.sql.SQLException

afterInitialConnectionCreation

public void afterInitialConnectionCreation(java.sql.Connection connection)

Description copied from class: Translator

Called exactly once for this source.

Overrides:

afterInitialConnectionCreation in class Translator

getDefaultNullOrder

public Translator.NullOrder getDefaultNullOrder()

Description copied from class: Translator

get the default null ordering

Overrides:

getDefaultNullOrder in class Translator

Returns:

getDefaultCapabilities

public java.lang.Class<? extends ConnectorCapabilities> getDefaultCapabilities()

Description copied from class: Translator

Get the default capabilities class. Will be used by Translator.getConnectorCapabilities() to return a capabilities instance.

Overrides:

getDefaultCapabilities in class Translator

Returns:

supportsExplicitNullOrdering

public boolean supportsExplicitNullOrdering()

Overrides:

supportsExplicitNullOrdering in class Translator