@Translator(name="sybase", description="A translator for Sybase Database") public class SybaseExecutionFactory extends BaseSybaseExecutionFactory
Modifier and Type | Class and Description |
---|---|
static class |
SybaseExecutionFactory.SybaseFormatFunctionModifier |
JDBCExecutionFactory.StructRetrieval
ExecutionFactory.Format, ExecutionFactory.NullOrder, ExecutionFactory.SupportedJoinCriteria, ExecutionFactory.TransactionSupport
Modifier and Type | Field and Description |
---|---|
protected ConvertModifier |
convertModifier |
static Version |
FIFTEEN_0_2 |
static Version |
FIFTEEN_5 |
protected Map<String,Object> |
formatMap |
protected boolean |
jtdsDriver |
static Version |
TWELVE_5 |
static Version |
TWELVE_5_3 |
DEFAULT_MAX_DEPENDENT_PREDICATES, DEFAULT_MAX_IN_CRITERIA, DEFAULT_TIME_ZONE, dialect
DEFAULT_MAX_FROM_GROUPS, DEFAULT_MAX_IN_CRITERIA_SIZE
Constructor and Description |
---|
SybaseExecutionFactory() |
Modifier and Type | Method and Description |
---|---|
boolean |
booleanNullable() |
protected List<Object> |
convertDateToString(Function function) |
protected List<?> |
convertTimestampToString(Function function) |
String |
getHibernateDialectClassName() |
int |
getMaxFromGroups()
The number of groups supported in the from clause.
|
List<String> |
getSupportedFunctions()
Get list of all supported function names.
|
void |
initCapabilities(Connection connection)
Will be called by
ExecutionFactory.start() with a null connection if a source connection is not ExecutionFactory.isSourceRequiredForCapabilities() |
boolean |
isJtdsDriver() |
boolean |
nullPlusNonNullIsNull() |
protected void |
populateDateFormats() |
protected boolean |
setFetchSize() |
void |
setFetchSize(Command command,
ExecutionContext context,
Statement statement,
int fetchSize)
Set the fetch size on the given statement.
|
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 |
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) |
boolean |
supportsGroupByRollup() |
boolean |
supportsInlineViews()
Support indicates connector can accept inline views (subqueries
in the FROM clause).
|
boolean |
supportsLiteralOnlyWithGrouping() |
boolean |
supportsOnlyFormatLiterals()
|
boolean |
supportsRowLimit()
Gets whether the connector can limit the number of rows returned by a query.
|
boolean |
supportsSelectWithoutFrom() |
List<?> |
translateCommand(Command command,
ExecutionContext context)
SetQueries don't have a concept of TOP, an inline view is needed.
|
String |
translateLiteralBinaryType(org.teiid.core.types.BinaryType obj)
Subclasses should override this method to provide a different sql translation
of the literal varbinary value.
|
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.
|
protected boolean |
usesDatabaseVersion() |
boolean |
useUnicodePrefix() |
bindValue, getTemporaryTableName, getTimestampNanoPrecision, hasTimeType, retrieveValue, retrieveValue, supportsBooleanExpressions, supportsCrossJoin, translate, translateLimit, useAsInGroupAlias, useSelectLimit
addSourceComment, afterInitialConnectionObtained, closeConnection, convertObject, createDirectExecution, createMetadataProcessor, createProcedureExecution, createResultSetExecution, createTempTable, createUpdateExecution, executeStoredProcedure, formatDateValue, formatDateValue, getCommentFormat, getConnection, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getCreateTempTableSQL, getDatabaseCalendar, getDatabaseTimeZone, getDatabaseVersion, getDefaultNullOrder, getDefaultSupportedFunctions, getDialect, getFunctionModifiers, getLateralKeyword, getLikeRegexString, getMaxPreparedInsertBatchSize, getMetadata, getMetadataProcessor, getSetOperationString, getSourceComment, getSQLConversionVisitor, getStructRetrieval, getVersion, intializeConnectionAfterCancel, isEnableDependentJoins, isSourceRequired, isSourceRequiredForCapabilities, isTrimStrings, loadedTemporaryTable, obtainedConnection, parseName, registerFunctionModifier, registerSpecificTypeOfOutParameter, replaceElementName, retrieveGeometryValue, retrieveGeometryValue, setCommentFormat, setDatabaseTimeZone, setDatabaseVersion, setDatabaseVersion, setEnableDependentJoins, setMaxPreparedInsertBatchSize, setStructRetrieval, setTrimStrings, setUseBindingsForDependentJoin, setUseBindVariables, setUseCommentsInSourceQuery, supportsAggregatesAvg, supportsAggregatesCount, supportsAggregatesCountStar, supportsAggregatesDistinct, supportsAggregatesMax, supportsAggregatesMin, supportsAggregatesSum, supportsAliasedTable, supportsBatchedUpdates, supportsBulkUpdate, supportsCompareCriteriaEquals, supportsCompareCriteriaOrdered, supportsCorrelatedSubqueries, supportsDependentJoins, supportsExistsCriteria, supportsFullDependentJoins, supportsGeneratedKeys, supportsGeneratedKeys, supportsGroupBy, supportsHaving, supportsInCriteria, supportsInCriteriaSubquery, supportsInsertWithQueryExpression, supportsIsNullCriteria, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsNotCriteria, supportsOrCriteria, supportsOrderByUnrelated, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsScalarSubqueries, supportsSearchedCaseExpressions, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions, tempTableRequiresTransaction, translateGeometryLiteral, translateGeometrySelect, translateLiteralBoolean, translateLiteralTime, useBindingsForDependentJoin, useBindVariables, useColumnNamesForGeneratedKeys, useCommentsInSourceQuery, useParensForJoins, useParensForSetQueries, usePreparedStatements, useScientificNotation, useStreamsForLobs, useWithRollup
addPushDownFunction, areLobsUsableAfterClose, createExecution, getCacheDirective, getCollationLocale, getConnection, getDirectQueryProcedureName, getExcludedCommonTableExpressionName, getInstance, getLanguageFactory, getMaxDependentInPredicates, 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, supportsArrayType, supportsCommonTableExpressions, supportsCompareCriteriaOrderedExclusive, supportsConvert, supportsCorrelatedSubqueryLimit, supportsDirectQueryProcedure, supportsElementaryOlapOperations, supportsExcept, supportsFullOuterJoins, supportsGroupByMultipleDistinctAggregates, supportsInnerJoins, supportsIntersect, supportsLateralJoin, supportsLateralJoinCondition, supportsLikeRegex, supportsNativeQueries, supportsOnlyCorrelatedSubqueries, supportsOnlyLiteralComparison, supportsOnlySingleTableGroupBy, supportsOrderBy, supportsOrderByNullOrdering, supportsOrderByWithExtendedGrouping, supportsOuterJoins, supportsPartialFiltering, supportsProcedureTable, supportsRecursiveCommonTableExpressions, supportsRowOffset, supportsScalarSubqueryProjection, supportsSelectDistinct, supportsSelectExpressionArrayType, supportsSimilarTo, supportsStringAgg, supportsSubqueryCommonTableExpressions, supportsSubqueryInOn, supportsUpsert, supportsWindowDistinctAggregates, supportsWindowOrderByWithAggregates, useAnsiJoin
public static final Version TWELVE_5_3
public static final Version TWELVE_5
public static final Version FIFTEEN_0_2
public static final Version FIFTEEN_5
protected boolean jtdsDriver
protected ConvertModifier convertModifier
protected void populateDateFormats()
public void start() throws TranslatorException
ExecutionFactory
start
in class JDBCExecutionFactory
TranslatorException
public List<String> getSupportedFunctions()
ExecutionFactory
getSupportedFunctions
in class JDBCExecutionFactory
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.
public boolean supportsInlineViews()
ExecutionFactory
supportsInlineViews
in class JDBCExecutionFactory
public boolean supportsFunctionsInGroupBy()
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)
supportsFunctionsInGroupBy
in class ExecutionFactory<DataSource,Connection>
public int getMaxFromGroups()
ExecutionFactory
getMaxFromGroups
in class ExecutionFactory<DataSource,Connection>
public boolean supportsAggregatesEnhancedNumeric()
ExecutionFactory
supportsAggregatesEnhancedNumeric
in class ExecutionFactory<DataSource,Connection>
public boolean nullPlusNonNullIsNull()
nullPlusNonNullIsNull
in class BaseSybaseExecutionFactory
public boolean booleanNullable()
booleanNullable
in class BaseSybaseExecutionFactory
public String translateLiteralTimestamp(Timestamp timestampValue)
JDBCExecutionFactory
{ts '2002-12-31 23:59:59'}
.
See JDBCExecutionFactory.getTimestampNanoPrecision()
to control the literal
precision.translateLiteralTimestamp
in class JDBCExecutionFactory
timestampValue
- Timestamp value, never nullpublic String translateLiteralDate(Date dateValue)
JDBCExecutionFactory
{d '2002-12-31'}
translateLiteralDate
in class JDBCExecutionFactory
dateValue
- Date value, never nullpublic boolean supportsRowLimit()
ExecutionFactory
supportsRowLimit
in class ExecutionFactory<DataSource,Connection>
@TranslatorProperty(display="JTDS Driver", description="True if the driver is the JTDS driver", advanced=true) public boolean isJtdsDriver()
public void setJtdsDriver(boolean jtdsDriver)
protected boolean setFetchSize()
public void setFetchSize(Command command, ExecutionContext context, Statement statement, int fetchSize) throws SQLException
JDBCExecutionFactory
setFetchSize
in class JDBCExecutionFactory
SQLException
public void initCapabilities(Connection connection) throws TranslatorException
ExecutionFactory
ExecutionFactory.start()
with a null connection if a source connection is not ExecutionFactory.isSourceRequiredForCapabilities()
initCapabilities
in class JDBCExecutionFactory
TranslatorException
protected boolean usesDatabaseVersion()
usesDatabaseVersion
in class JDBCExecutionFactory
public boolean supportsSelectWithoutFrom()
supportsSelectWithoutFrom
in class ExecutionFactory<DataSource,Connection>
public String getHibernateDialectClassName()
getHibernateDialectClassName
in class JDBCExecutionFactory
public boolean supportsGroupByRollup()
supportsGroupByRollup
in class ExecutionFactory<DataSource,Connection>
public boolean useUnicodePrefix()
useUnicodePrefix
in class JDBCExecutionFactory
public boolean supportsOnlyFormatLiterals()
ExecutionFactory
supportsOnlyFormatLiterals
in class ExecutionFactory<DataSource,Connection>
public boolean supportsFormatLiteral(String literal, ExecutionFactory.Format format)
supportsFormatLiteral
in class ExecutionFactory<DataSource,Connection>
public List<?> translateCommand(Command command, ExecutionContext context)
BaseSybaseExecutionFactory
translateCommand
in class BaseSybaseExecutionFactory
public boolean supportsLiteralOnlyWithGrouping()
public String translateLiteralBinaryType(org.teiid.core.types.BinaryType obj)
JDBCExecutionFactory
X'hex value'
translateLiteralBinaryType
in class JDBCExecutionFactory
obj
- value, never nullCopyright © 2017 JBoss by Red Hat. All rights reserved.