public class IngresDialect extends Dialect
CLOSED_QUOTE, DEFAULT_BATCH_SIZE, LEGACY_LOB_MERGE_STRATEGY, NEW_LOCATOR_LOB_MERGE_STRATEGY, NO_BATCH, QUOTE, STREAM_XFER_LOB_MERGE_STRATEGY
Constructor and Description |
---|
IngresDialect() |
Modifier and Type | Method and Description |
---|---|
boolean |
dropConstraints()
Do we need to drop constraints before dropping tables in this dialect?
|
String |
generateTemporaryTableName(String baseTableName)
Generate a temporary table name given the base table.
|
String |
getAddColumnString()
The syntax used to add a column to a table (optional).
|
String |
getCreateSequenceString(String sequenceName)
The syntax used to create a sequence, if sequences are supported.
|
String |
getCreateTemporaryTablePostfix()
Get any fragments needing to be postfixed to the command for
temporary table creation.
|
String |
getCreateTemporaryTableString()
Command used to create a temporary table.
|
String |
getCurrentTimestampSQLFunctionName()
Expression for current_timestamp
|
String |
getDropSequenceString(String sequenceName)
The syntax used to drop a sequence, if sequences are supported.
|
String |
getLimitString(String querySelect,
int offset,
int limit)
Add a LIMIT clause to the given SQL SELECT
|
String |
getLowercaseFunction()
The name of the SQL function that transforms a string to
lowercase
|
String |
getNullColumnString()
The keyword used to specify a nullable column.
|
String |
getQuerySequencesString()
A query used to find all sequences
|
String |
getSelectGUIDString()
Expression for created UUID string
|
String |
getSelectSequenceNextValString(String sequenceName)
Generate the select expression fragment that will retrieve the next
value of a sequence as part of another (typically DML) statement.
|
String |
getSequenceNextValString(String sequenceName)
The syntax that fetches the next value of a sequence, if sequences are supported.
|
boolean |
supportsEmptyInList()
Does this dialect support empty IN lists?
For example, is [where XYZ in ()] a supported construct?
|
boolean |
supportsExpectedLobUsagePattern()
Expected LOB usage pattern is such that I can perform an insert
via prepared statement with a parameter binding for a LOB value
without crazy casting to JDBC driver implementation-specific classes...
|
boolean |
supportsForUpdateOf()
Does this dialect support FOR UPDATE OF, allowing
particular rows to be locked?
|
boolean |
supportsLimit()
Does this Dialect have some kind of LIMIT syntax?
|
boolean |
supportsLimitOffset()
Does this dialect support an offset?
|
boolean |
supportsNotNullUnique()
Ingres explicitly needs "unique not null", because "with null" is default
|
boolean |
supportsSequences()
Does this dialect support sequences?
|
boolean |
supportsSubselectAsInPredicateLHS()
Are subselects supported as the left-hand-side (LHS) of
IN-predicates.
|
boolean |
supportsTemporaryTables()
Does this dialect support temporary tables?
|
boolean |
supportsTupleDistinctCounts()
Ingres does not support the syntax `count(distinct a,b)`?
|
boolean |
supportsVariableLimit()
Does this dialect support bind variables (i.e., prepared statement
parameters) for its limit/offset?
|
boolean |
useMaxForLimit()
Does the LIMIT clause take a "maximum" row number instead
of a total number of returned rows?
|
appendIdentitySelectToInsert, appendLockHint, applyLocksToSql, areStringComparisonsCaseInsensitive, bindLimitParametersFirst, bindLimitParametersInReverseOrder, buildSQLExceptionConversionDelegate, buildSQLExceptionConverter, closeQuote, convertToFirstRowValue, createCaseFragment, createOuterJoinFragment, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, dropTemporaryTableAfterUse, forceLimitUsage, forUpdateOfColumns, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAddUniqueConstraintString, getCascadeConstraintsString, getCaseInsensitiveLike, getCastTypeName, getColumnAliasExtractor, getColumnComment, getCreateMultisetTableString, getCreateSequenceString, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getCrossJoinSeparator, getCurrentTimestampSelectString, getDefaultProperties, getDialect, getDialect, getDropForeignKeyString, getDropSequenceStrings, getDropTemporaryTableString, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnString, getIdentityColumnString, getIdentityInsertString, getIdentitySelectString, getIdentitySelectString, getKeywords, getLimitString, getLobMergeStrategy, getLockingStrategy, getMaxAliasLength, getNativeIdentifierGeneratorClass, getNoColumnsInsertString, getReadLockString, getResultSet, getSelectClauseNullString, getSqlTypeDescriptorOverride, getTableComment, getTableTypeString, getTypeName, getTypeName, getViolatedConstraintNameExtracter, getWriteLockString, hasAlterTable, hasDataTypeInIdentityColumn, hasSelfReferentialForeignKeyBug, isCurrentTimestampSelectStringCallable, isLockTimeoutParameterized, openQuote, performTemporaryTableDDLInIsolation, qualifyIndexName, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, registerResultSetOutParameter, remapSqlTypeDescriptor, replaceResultVariableInOrderByClauseWithPosition, requiresCastingOfParametersInSelectClause, supportsBindAsCallableArgument, supportsCascadeDelete, supportsCaseInsensitiveLike, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsCommentOn, supportsCurrentTimestampSelection, supportsExistsInSelect, supportsIdentityColumns, supportsIfExistsAfterTableName, supportsIfExistsBeforeTableName, supportsInsertSelectIdentity, supportsLobValueChangePropogation, supportsLockTimeouts, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPooledSequences, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInList, supportsSubqueryOnMutatingTable, supportsTableCheck, supportsTupleCounts, supportsUnboundedLobLocatorMaterialization, supportsUnionAll, supportsUnique, supportsUniqueConstraintInCreateAlterTable, toBooleanValueString, toString, transformSelectString, useInputStreamToInsertBlob
public String getSelectGUIDString()
getSelectGUIDString
in class Dialect
public boolean dropConstraints()
dropConstraints
in class Dialect
public boolean supportsForUpdateOf()
public String getAddColumnString()
getAddColumnString
in class Dialect
public String getNullColumnString()
getNullColumnString
in class Dialect
public boolean supportsSequences()
supportsSequences
in class Dialect
public String getSequenceNextValString(String sequenceName)
getSequenceNextValString
in class Dialect
sequenceName
- the name of the sequencepublic String getSelectSequenceNextValString(String sequenceName)
Dialect
Dialect.getSequenceNextValString(String)
in that this
should return an expression usable within another statement.getSelectSequenceNextValString
in class Dialect
sequenceName
- the name of the sequencepublic String getCreateSequenceString(String sequenceName)
getCreateSequenceString
in class Dialect
sequenceName
- the name of the sequencepublic String getDropSequenceString(String sequenceName)
getDropSequenceString
in class Dialect
sequenceName
- the name of the sequencepublic String getQuerySequencesString()
getQuerySequencesString
in class Dialect
SchemaUpdate
public String getLowercaseFunction()
getLowercaseFunction
in class Dialect
public boolean supportsLimit()
supportsLimit
in class Dialect
public boolean supportsLimitOffset()
supportsLimitOffset
in class Dialect
public String getLimitString(String querySelect, int offset, int limit)
getLimitString
in class Dialect
querySelect
- The query to which to apply the limit.offset
- The offset of the limitlimit
- The limit of the limit ;)public boolean supportsVariableLimit()
Dialect
supportsVariableLimit
in class Dialect
public boolean useMaxForLimit()
useMaxForLimit
in class Dialect
public boolean supportsNotNullUnique()
supportsNotNullUnique
in class Dialect
public boolean supportsTemporaryTables()
supportsTemporaryTables
in class Dialect
public String getCreateTemporaryTableString()
Dialect
getCreateTemporaryTableString
in class Dialect
public String getCreateTemporaryTablePostfix()
Dialect
getCreateTemporaryTablePostfix
in class Dialect
public String generateTemporaryTableName(String baseTableName)
Dialect
generateTemporaryTableName
in class Dialect
baseTableName
- The table name from which to base the temp table name.public String getCurrentTimestampSQLFunctionName()
getCurrentTimestampSQLFunctionName
in class Dialect
public boolean supportsSubselectAsInPredicateLHS()
Dialect
supportsSubselectAsInPredicateLHS
in class Dialect
public boolean supportsEmptyInList()
Dialect
supportsEmptyInList
in class Dialect
public boolean supportsExpectedLobUsagePattern()
Dialect
supportsExpectedLobUsagePattern
in class Dialect
public boolean supportsTupleDistinctCounts()
supportsTupleDistinctCounts
in class Dialect
Copyright © 2012 JBoss by Red Hat. All Rights Reserved.