@Deprecated public class DerbyDialect extends DB2Dialect
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 |
---|
DerbyDialect()
Deprecated.
|
Modifier and Type | Method and Description |
---|---|
CaseFragment |
createCaseFragment()
Deprecated.
Return the case statement modified for Cloudscape.
|
boolean |
dropConstraints()
Deprecated.
Do we need to drop constraints before dropping tables in this dialect?
|
String |
getCrossJoinSeparator()
Deprecated.
|
String |
getForUpdateString()
Deprecated.
Get the string to append to SELECT statements to acquire locks
for this dialect.
|
String |
getLimitString(String query,
int offset,
int limit)
Deprecated.
Given a limit and an offset, apply the limit clause to the query.
|
String |
getQuerySequencesString()
Deprecated.
Get the select command used retrieve the names of all sequences.
|
String |
getReadLockString(int timeout)
Deprecated.
Get the string to append to SELECT statements to acquire WRITE locks
for this dialect.
|
String |
getSequenceNextValString(String sequenceName)
Deprecated.
Generate the appropriate select statement to to retrieve the next value
of a sequence.
|
String |
getWriteLockString(int timeout)
Deprecated.
Get the string to append to SELECT statements to acquire WRITE locks
for this dialect.
|
boolean |
supportsCommentOn()
Deprecated.
|
boolean |
supportsLimit()
Deprecated.
Does this dialect support some form of limiting query results
via a SQL clause?
|
boolean |
supportsLimitOffset()
Deprecated.
Does this dialect's LIMIT support (if any) additionally
support specifying an offset?
|
boolean |
supportsLobValueChangePropogation()
Deprecated.
Does the dialect support propagating changes to LOB
values back to the database? Talking about mutating the
internal value of the locator as opposed to supplying a new
locator instance...
|
boolean |
supportsSequences()
Deprecated.
Does this dialect support sequences?
|
boolean |
supportsUnboundedLobLocatorMaterialization()
Deprecated.
Is it supported to materialize a LOB locator outside the transaction in
which it was created?
Again, part of the trickiness here is the fact that this is largely
driver dependent.
|
boolean |
supportsVariableLimit()
Deprecated.
Does this dialect support bind variables (i.e., prepared statement
parameters) for its limit/offset?
|
buildSQLExceptionConversionDelegate, convertToFirstRowValue, doesReadCommittedCauseWritersToBlockReaders, generateTemporaryTableName, getAddColumnString, getCreateSequenceString, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getCurrentTimestampSelectString, getDropSequenceString, getIdentityColumnString, getIdentityInsertString, getIdentitySelectString, getLowercaseFunction, getNotExpression, getResultSet, getSelectClauseNullString, getSqlTypeDescriptorOverride, getUniqueDelegate, isCurrentTimestampSelectStringCallable, main, registerResultSetOutParameter, requiresCastingOfParametersInSelectClause, supportsCurrentTimestampSelection, supportsEmptyInList, supportsExistsInSelect, supportsIdentityColumns, supportsLockTimeouts, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPooledSequences, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsTemporaryTables, supportsTupleDistinctCounts, supportsUnionAll, useMaxForLimit
appendIdentitySelectToInsert, appendLockHint, appendLockHint, applyLocksToSql, areStringComparisonsCaseInsensitive, bindLimitParametersFirst, bindLimitParametersInReverseOrder, buildLimitHandler, buildSQLExceptionConverter, cast, cast, cast, closeQuote, contributeTypes, createOuterJoinFragment, doesRepeatableReadCauseReadersToBlockWriters, dropTemporaryTableAfterUse, forceLimitUsage, forceLobAsLastValue, forUpdateOfColumns, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAddUniqueConstraintString, getCascadeConstraintsString, getCaseInsensitiveLike, getCastTypeName, getColumnAliasExtractor, getColumnComment, getCreateMultisetTableString, getCreateSequenceString, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getCurrentTimestampSQLFunctionName, getDefaultProperties, getDialect, getDialect, getDropForeignKeyString, getDropSequenceStrings, getDropTableString, getDropTemporaryTableString, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnString, getIdentitySelectString, getInExpressionCountLimit, getKeywords, getLimitString, getLobMergeStrategy, getLockingStrategy, getMaxAliasLength, getNativeIdentifierGeneratorClass, getNoColumnsInsertString, getNullColumnString, getSelectGUIDString, getSelectSequenceNextValString, getTableComment, getTableTypeString, getTypeName, getTypeName, getViolatedConstraintNameExtracter, hasAlterTable, hasDataTypeInIdentityColumn, hasSelfReferentialForeignKeyBug, isLockTimeoutParameterized, openQuote, performTemporaryTableDDLInIsolation, qualifyIndexName, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, remapSqlTypeDescriptor, renderOrderByElement, replaceResultVariableInOrderByClauseWithPosition, requiresParensForTupleDistinctCounts, supportsBindAsCallableArgument, supportsCascadeDelete, supportsCaseInsensitiveLike, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsExpectedLobUsagePattern, supportsIfExistsAfterTableName, supportsIfExistsBeforeTableName, supportsInsertSelectIdentity, supportsNotNullUnique, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInList, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTupleCounts, supportsTuplesInSubqueries, supportsUnique, supportsUniqueConstraintInCreateAlterTable, toBooleanValueString, toString, transformSelectString, useFollowOnLocking, useInputStreamToInsertBlob
public String getCrossJoinSeparator()
getCrossJoinSeparator
in class DB2Dialect
public CaseFragment createCaseFragment()
createCaseFragment
in class Dialect
CaseFragment
strategy.public boolean dropConstraints()
Dialect
dropConstraints
in class DB2Dialect
public boolean supportsSequences()
Dialect
supportsSequences
in class DB2Dialect
public String getSequenceNextValString(String sequenceName)
Dialect
getSequenceNextValString
in class DB2Dialect
sequenceName
- the name of the sequencepublic boolean supportsLimit()
Dialect
supportsLimit
in class DB2Dialect
public boolean supportsCommentOn()
supportsCommentOn
in class DB2Dialect
public boolean supportsLimitOffset()
Dialect
supportsLimitOffset
in class Dialect
public String getForUpdateString()
Dialect
getForUpdateString
in class DB2Dialect
public String getWriteLockString(int timeout)
Dialect
getWriteLockString
in class Dialect
timeout
- in milliseconds, -1 for indefinite wait and 0 for no wait.public String getReadLockString(int timeout)
Dialect
getReadLockString
in class Dialect
timeout
- in milliseconds, -1 for indefinite wait and 0 for no wait.public String getLimitString(String query, int offset, int limit)
Query [ORDER BY clause] [result offset clause] [fetch first clause] [FOR UPDATE clause] [WITH {RR|RS|CS|UR}]
getLimitString
in class DB2Dialect
query
- 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 DB2Dialect
public String getQuerySequencesString()
Dialect
getQuerySequencesString
in class DB2Dialect
SchemaUpdate
public boolean supportsLobValueChangePropogation()
Dialect
Blob.setBinaryStream(long)
,
Blob.setBytes(long, byte[])
,
Blob.setBytes(long, byte[], int, int)
,
or Blob.truncate(long)
.
For CLOBs, the internal value might be changed by:
Clob.setAsciiStream(long)
,
Clob.setCharacterStream(long)
,
Clob.setString(long, String)
,
Clob.setString(long, String, int, int)
,
or Clob.truncate(long)
.
NOTE : I do not know the correct answer currently for
databases which (1) are not part of the cruise control process
or (2) do not Dialect.supportsExpectedLobUsagePattern()
.supportsLobValueChangePropogation
in class DB2Dialect
public boolean supportsUnboundedLobLocatorMaterialization()
Dialect
Dialect.supportsExpectedLobUsagePattern()
also support the ability to materialize a LOB outside the owning transaction...supportsUnboundedLobLocatorMaterialization
in class Dialect
Copyright © 2018 JBoss by Red Hat. All rights reserved.