org.teiid.translator.jdbc.sybase

Class SybaseExecutionFactory

java.lang.Object

org.teiid.translator.ExecutionFactory<DataSource,Connection>

org.teiid.translator.jdbc.JDBCExecutionFactory

org.teiid.translator.jdbc.sybase.BaseSybaseExecutionFactory

org.teiid.translator.jdbc.sybase.SybaseExecutionFactory

Direct Known Subclasses:

SQLServerExecutionFactory

@Translator(name="sybase",
            description="A translator for Sybase Database")
public class SybaseExecutionFactory
extends BaseSybaseExecutionFactory

Nested Class Summary

Nested classes/interfaces inherited from class org.teiid.translator.ExecutionFactory

ExecutionFactory.Format, ExecutionFactory.NullOrder, ExecutionFactory.SupportedJoinCriteria

Field Summary

Fields

Modifier and Type	Field and Description
static String	FIFTEEN_0_2
static String	FIFTEEN_5
protected Map<String,Integer>	formatMap
protected boolean	jtdsDriver
static String	TWELVE_5

Fields inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

DEFAULT_MAX_DEPENDENT_PREDICATES, DEFAULT_MAX_IN_CRITERIA, DEFAULT_TIME_ZONE

Fields inherited from class org.teiid.translator.ExecutionFactory

DEFAULT_MAX_FROM_GROUPS, DEFAULT_MAX_IN_CRITERIA_SIZE

Constructor Summary

Constructors

Constructor and Description
SybaseExecutionFactory()

Method Summary

Methods

Modifier and Type	Method and Description
boolean	booleanNullable()
protected List<Object>	convertDateToString(Function function)
protected List<?>	convertTimestampToString(Function function)
int	getMaxFromGroups() The number of groups supported in the from clause.
List<String>	getSupportedFunctions() Get list of all supported function names.
boolean	isJtdsDriver()
boolean	nullPlusNonNullIsNull()
protected void	populateDateFormats()
void	setFetchSize(Command command, ExecutionContext context, Statement statement, int fetchSize) Set the fetch size on the given statement.
protected boolean	setFetchSizeOnCallableStatements()
void	setJtdsDriver(boolean jtdsDriver)
void	start() Initialize the connector with supplied configuration
boolean	supportsAggregatesEnhancedNumeric() Support indicates connector can accept STDDEV_POP, STDDEV_VAR, VAR_POP, VAR_SAMP
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	supportsInlineViews() Support indicates connector can accept inline views (subqueries in the FROM clause).
boolean	supportsRowLimit() Gets whether the connector can limit the number of rows returned by a query.
String	translateLiteralDate(Date dateValue) Subclasses should override this method to provide a different sql translation of the literal date value.
String	translateLiteralTimestamp(Timestamp timestampValue) Subclasses should override this method to provide a different sql translation of the literal timestamp value.

Methods inherited from class org.teiid.translator.jdbc.sybase.BaseSybaseExecutionFactory

bindValue, getTimestampNanoPrecision, hasTimeType, retrieveValue, retrieveValue, supportsCrossJoin, translate, translateCommand, translateLimit, useAsInGroupAlias, useSelectLimit

Methods inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

addSourceComment, afterInitialConnectionObtained, closeConnection, createMetadataProcessor, createProcedureExecution, createResultSetExecution, createUpdateExecution, executeStoredProcedure, formatDateValue, getConnection, getDatabaseCalendar, getDatabaseTimeZone, getDatabaseVersion, getDefaultNullOrder, getDefaultSupportedFunctions, getFunctionModifiers, getLikeRegexString, getMaxPreparedInsertBatchSize, getMetadata, getSetOperationString, getSourceComment, getSQLConversionVisitor, isSourceRequired, isTrimStrings, obtainedConnection, parseName, registerFunctionModifier, registerSpecificTypeOfOutParameter, replaceElementName, setDatabaseTimeZone, setDatabaseVersion, setMaxPreparedInsertBatchSize, setTrimStrings, setUseBindVariables, setUseCommentsInSourceQuery, supportsAggregatesAvg, supportsAggregatesCount, supportsAggregatesCountStar, supportsAggregatesDistinct, supportsAggregatesMax, supportsAggregatesMin, supportsAggregatesSum, supportsAliasedTable, supportsBatchedUpdates, supportsBulkUpdate, supportsCompareCriteriaEquals, supportsCompareCriteriaOrdered, supportsCorrelatedSubqueries, supportsExistsCriteria, supportsGroupBy, supportsHaving, supportsInCriteria, supportsInCriteriaSubquery, supportsInsertWithQueryExpression, supportsIsNullCriteria, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsNotCriteria, supportsOrCriteria, supportsOrderByUnrelated, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsScalarSubqueries, supportsSearchedCaseExpressions, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions, translateLiteralBoolean, translateLiteralTime, useBindVariables, useCommentsInSourceQuery, useParensForJoins, useParensForSetQueries, usePreparedStatements

Methods inherited from class org.teiid.translator.ExecutionFactory

addPushDownFunction, areLobsUsableAfterClose, createExecution, getConnection, getInstance, getLanguageFactory, getMaxDependentInPredicates, getMaxInCriteriaSize, getPushDownFunctions, getSupportedJoinCriteria, getTypeFacility, isCopyLobs, isImmutable, requiresCriteria, setCopyLobs, setImmutable, setMaxDependentInPredicates, setMaxInCriteriaSize, setRequiresCriteria, setSourceRequired, setSupportedJoinCriteria, setSupportsFullOuterJoins, setSupportsInnerJoins, setSupportsOrderBy, setSupportsOuterJoins, setSupportsSelectDistinct, supportsAdvancedOlapOperations, supportsArrayAgg, supportsCommonTableExpressions, supportsConvert, supportsDependentJoins, supportsElementaryOlapOperations, supportsExcept, supportsFormatLiteral, supportsFullOuterJoins, supportsInnerJoins, supportsIntersect, supportsLikeRegex, supportsOnlyFormatLiterals, supportsOnlyLiteralComparison, supportsOnlySingleTableGroupBy, supportsOrderBy, supportsOrderByNullOrdering, supportsOuterJoins, supportsRowOffset, supportsSelectDistinct, supportsSimilarTo, supportsWindowDistinctAggregates, supportsWindowOrderByWithAggregates, useAnsiJoin

Methods inherited from class java.lang.Object

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

Field Detail

TWELVE_5

public static final String TWELVE_5

See Also:

Constant Field Values

FIFTEEN_0_2

public static final String FIFTEEN_0_2

See Also:

Constant Field Values

FIFTEEN_5

public static final String FIFTEEN_5

See Also:

Constant Field Values

formatMap

protected Map<String,Integer> formatMap

jtdsDriver

protected boolean jtdsDriver

Constructor Detail

SybaseExecutionFactory

public SybaseExecutionFactory()

Method Detail

populateDateFormats

protected void populateDateFormats()

start

public void start()
           throws TranslatorException

Description copied from class: ExecutionFactory

Initialize the connector with supplied configuration

Overrides:

start in class JDBCExecutionFactory

Throws:

TranslatorException

convertDateToString

protected List<Object> convertDateToString(Function function)

convertTimestampToString

protected List<?> convertTimestampToString(Function function)

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.

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 functions in GROUP BY, such as: SELECT dayofmonth(theDate), COUNT(*) FROM table GROUP BY dayofmonth(theDate)

Overrides:

supportsFunctionsInGroupBy in class ExecutionFactory<DataSource,Connection>

getMaxFromGroups

public int getMaxFromGroups()

Description copied from class: ExecutionFactory

The number of groups supported in the from clause. Added for a Sybase limitation.

Overrides:

getMaxFromGroups in class ExecutionFactory<DataSource,Connection>

Returns:

the number of groups supported in the from clause, or -1 if there is no limit

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>

nullPlusNonNullIsNull

public boolean nullPlusNonNullIsNull()

Overrides:

nullPlusNonNullIsNull in class BaseSybaseExecutionFactory

booleanNullable

public boolean booleanNullable()

Overrides:

booleanNullable in class BaseSybaseExecutionFactory

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

translateLiteralDate

public String translateLiteralDate(Date dateValue)

Description copied from class: JDBCExecutionFactory

Subclasses should override this method to provide a different sql translation of the literal date value. By default, a date literal is represented as: {d '2002-12-31'}

Overrides:

translateLiteralDate in class JDBCExecutionFactory

Parameters:

dateValue - Date value, never null

Returns:

Translated string

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>

isJtdsDriver

@TranslatorProperty(display="JTDS Driver",
                    description="True if the driver is the JTDS driver",
                    advanced=true)
public boolean isJtdsDriver()

setJtdsDriver

public void setJtdsDriver(boolean jtdsDriver)

setFetchSizeOnCallableStatements

protected boolean setFetchSizeOnCallableStatements()

setFetchSize

public void setFetchSize(Command command,
                ExecutionContext context,
                Statement statement,
                int fetchSize)
                  throws SQLException

Description copied from class: JDBCExecutionFactory

Set the fetch size on the given statement.

Overrides:

setFetchSize in class JDBCExecutionFactory

Throws:

SQLException