Generate SQL to get the identifier of an inserted row. If the returned value is not null, the caller will prepare a statement from it, set SQL parameters just as it would for insertSQL, and execute it as a query which is expected to return the identifier of the inserted row. Defining database independent JPA object uid. It turns out that the following example works when using mysql 5.x, however it doesn't when using an oracle 10g database.

• Dialect Does Not Support Identity Key Generation Confluence 2017
• Dialect Does Not Support Identity Key Generation Confluence System
• Dialect Does Not Support Identity Key Generation Confluence Mean

• • Constructor Summary

    Constructors

    Constructor and Description
    IdentityColumnSupportImpl()

  • Method Summary

    All MethodsInstance MethodsConcrete Methods

    Modifier and Type	Method and Description
    String	appendIdentitySelectToInsert(String insertString) Provided we IdentityColumnSupport.supportsInsertSelectIdentity(), then attach the 'select identity' clause to the insert statement.
    GetGeneratedKeysDelegate	buildGetGeneratedKeysDelegate(PostInsertIdentityPersister persister, Dialect dialect) The Delegate for dealing with IDENTITY columns using JDBC3 getGeneratedKeys
    String	getIdentityColumnString(int type) The syntax used during DDL to define a column as being an IDENTITY of a particular type.
    String	getIdentityInsertString() The keyword used to insert a generated value into an identity column (or null).
    String	getIdentitySelectString(String table, String column, int type) Get the select command to use to retrieve the last generated IDENTITY value for a particular table
    boolean	hasDataTypeInIdentityColumn() Whether this dialect have an Identity clause added to the data type or a completely separate identity data type
    boolean	supportsIdentityColumns() Does this dialect support identity column key generation?
    boolean	supportsInsertSelectIdentity() Does the dialect support some form of inserting and selecting the generated IDENTITY value all in the same statement.

    • Methods inherited from class java.lang.Object

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

An SQL dialect targeting Sybase Adaptive Server Enterprise (ASE) 15.7 and higher.

Author:

Junyan Ren

Field Summary

Fields inherited from class org.hibernate.dialect.Dialect
CLOSED_QUOTE, DEFAULT_BATCH_SIZE, NO_BATCH, QUOTE

Constructor Summary
SybaseASE157Dialect()

Method Summary
String	appendIdentitySelectToInsert(String insertSQL) Provided we Dialect.supportsInsertSelectIdentity(), then attach the 'select identity' clause to the insert statement.
String	appendLockHint(LockMode mode, String tableName) Some dialects support an alternative means to SELECT FOR UPDATE, whereby a 'lock hint' is appends to the table name in the from clause.
String	applyLocksToSql(String sql, LockOptions aliasedLockOptions, Map keyColumnNames) Modifies the given SQL by applying the appropriate updates for the specified lock modes and key columns.
boolean	doesReadCommittedCauseWritersToBlockReaders() For the underlying database, is READ_COMMITTED isolation implemented by forcing readers to wait for write locks to be released?
boolean	doesRepeatableReadCauseReadersToBlockWriters() For the underlying database, is REPEATABLE_READ isolation implemented by forcing writers to wait for read locks to be released?
boolean	dropTemporaryTableAfterUse() Do we need to drop the temporary table after use?
boolean	forUpdateOfColumns() Is FOR UPDATE OF syntax supported?
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	getCurrentTimestampSelectString() Retrieve the command used to retrieve the current timestamp from the database.
String	getForUpdateString() Get the string to append to SELECT statements to acquire locks for this dialect.
String	getForUpdateString(String aliases) Get the FOR UPDATE OF column_list fragment appropriate for this dialect given the aliases of the columns to be write locked.
String	getIdentityColumnString() The syntax used during DDL to define a column as being an IDENTITY.
String	getIdentitySelectString() Get the select command to use to retrieve the last generated IDENTITY value.
String	getNullColumnString() The keyword used to specify a nullable column.
ResultSet	getResultSet(CallableStatement ps) Given a callable statement previously processed by Dialect.registerResultSetOutParameter(java.sql.CallableStatement, int), extract the ResultSet from the OUT parameter.
String	getSelectGUIDString() Get the command used to select a GUID from the underlying database.
boolean	isCurrentTimestampSelectStringCallable() Should the value returned by Dialect.getCurrentTimestampSelectString() be treated as callable.
boolean	qualifyIndexName() Do we need to qualify index names with the schema name?
int	registerResultSetOutParameter(CallableStatement statement, int col) Registers an OUT parameter which will be returning a ResultSet.
boolean	supportsCurrentTimestampSelection() Does this dialect support a way to retrieve the database's current timestamp value?
boolean	supportsEmptyInList() Does this dialect support empty IN lists? For example, is [where XYZ in ()] a supported construct?
boolean	supportsExistsInSelect() Does the dialect support an exists statement in the select clause?
boolean	supportsExpectedLobUsagePattern() Actually Sybase does not support LOB locators at al.
boolean	supportsIdentityColumns() Does this dialect support identity column key generation?
boolean	supportsInsertSelectIdentity() Does the dialect support some form of inserting and selecting the generated IDENTITY value all in the same statement.
boolean	supportsLobValueChangePropogation() 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	supportsTemporaryTables() Does this dialect support temporary tables?
boolean	supportsTupleDistinctCounts() Does this dialect support `count(distinct a,b)`?
boolean	supportsUnionAll() Does this dialect support UNION ALL, which is generally a faster variant of UNION?

Methods inherited from class org.hibernate.dialect.SybaseASE15Dialect
areStringComparisonsCaseInsensitive, getCrossJoinSeparator, getCurrentTimestampSQLFunctionName, getMaxAliasLength, supportsCascadeDelete, supportsUniqueConstraintInCreateAlterTable

Methods inherited from class org.hibernate.dialect.Dialect

addTypeOverride, bindLimitParametersFirst, bindLimitParametersInReverseOrder, buildSQLExceptionConverter, closeQuote, convertToFirstRowValue, createCaseFragment, createOuterJoinFragment, dropConstraints, forceLimitUsage, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getCascadeConstraintsString, getCastTypeName, getColumnAliasExtractor, getColumnComment, getCreateMultisetTableString, getCreateSequenceString, getCreateSequenceString, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getDefaultProperties, getDialect, getDialect, getDropForeignKeyString, getDropSequenceString, getDropSequenceStrings, getDropTemporaryTableString, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnString, getIdentityInsertString, getIdentitySelectString, getKeywords, getLimitString, getLimitString, getLockingStrategy, getLowercaseFunction, getNativeIdentifierGeneratorClass, getNoColumnsInsertString, getQuerySequencesString, getReadLockString, getSelectClauseNullString, getSelectSequenceNextValString, getSequenceNextValString, getTableComment, getTableTypeString, getTypeName, getTypeName, getTypeOverrides, getViolatedConstraintNameExtracter, getWriteLockString, hasAlterTable, hasDataTypeInIdentityColumn, hasSelfReferentialForeignKeyBug, isLockTimeoutParameterized, openQuote, performTemporaryTableDDLInIsolation, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, replaceResultVariableInOrderByClauseWithPosition, requiresCastingOfParametersInSelectClause, supportsBindAsCallableArgument, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsCommentOn, supportsIfExistsAfterTableName, supportsIfExistsBeforeTableName, supportsLimit, supportsLimitOffset, supportsLockTimeouts, supportsNotNullUnique, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPooledSequences, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInList, supportsSequences, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTupleCounts, supportsUnboundedLobLocatorMaterialization, supportsUnique, supportsVariableLimit, toBooleanValueString, toString, transformSelectString, useInputStreamToInsertBlob, useMaxForLimit

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

SybaseASE157Dialect

Method Detail

supportsExpectedLobUsagePattern

Description copied from class: SybaseASE15Dialect

Actually Sybase does not support LOB locators at al.

Overrides:

supportsExpectedLobUsagePattern in class SybaseASE15Dialect

Returns:

false.

supportsLobValueChangePropogation

Description copied from class: Dialect

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..

For BLOBs, the internal value might be changed by: 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().

Overrides:

supportsLobValueChangePropogation in class Dialect

Returns:

True if the changes are propagated back to the database; false otherwise.

forUpdateOfColumns

Dialect Does Not Support Identity Key Generation Confluence 2017

Description copied from class: Dialect

Is FOR UPDATE OF syntax supported?

Overrides:

forUpdateOfColumns in class Dialect

Returns:

True if the database supports FOR UPDATE OF syntax; false otherwise.

getForUpdateString

Description copied from class: Dialect

Get the string to append to SELECT statements to acquire locks for this dialect.

Returns:

The appropriate FOR UPDATE clause string.

getForUpdateString

Description copied from class: Dialect

Get the FOR UPDATE OF column_list fragment appropriate for this dialect given the aliases of the columns to be write locked.

Overrides:

getForUpdateString in class Dialect

Parameters:

aliases - The columns to be write locked.

Returns:

The appropriate FOR UPDATE OF column_list clause string.

appendLockHint

Description copied from class: Dialect

Some dialects support an alternative means to SELECT FOR UPDATE, whereby a 'lock hint' is appends to the table name in the from clause.

contributed by Helge Schulz

Parameters:

mode - The lock mode to apply

tableName - The name of the table to which to apply the lock hint.

Returns:

The table with any required lock hints.

applyLocksToSql

Description copied from class: Dialect

Modifies the given SQL by applying the appropriate updates for the specified lock modes and key columns.

The behavior here is that of an ANSI SQL SELECT FOR UPDATE. This method is really intended to allow dialects which do not support SELECT FOR UPDATE to achieve this in their own fashion.

Parameters:

sql - the SQL string to modify

aliasedLockOptions - lock options indexed by aliased table names.

keyColumnNames - a map of key columns indexed by aliased table names.

Returns:

the modified SQL string.

getAddColumnString

Description copied from class: Dialect

The syntax used to add a column to a table (optional).

Overrides:

getAddColumnString in class Dialect

Returns:

The 'add column' fragment.

getNullColumnString

Description copied from class: Dialect

The keyword used to specify a nullable column.

Overrides:

getNullColumnString in class Dialect

Returns:

String

qualifyIndexName

Description copied from class: Dialect

Do we need to qualify index names with the schema name?

Overrides:

qualifyIndexName in class Dialect

Returns:

boolean

supportsIdentityColumns

Description copied from class: Dialect

Does this dialect support identity column key generation?

Overrides:

supportsIdentityColumns in class Dialect

Returns:

True if IDENTITY columns are supported; false otherwise.

getIdentitySelectString

Description copied from class: Dialect

Get the select command to use to retrieve the last generated IDENTITY value.

Overrides:

getIdentitySelectString in class Dialect

Returns:

The appropriate select command

getIdentityColumnString

Description copied from class: Dialect

The syntax used during DDL to define a column as being an IDENTITY.

Overrides:

getIdentityColumnString in class Dialect

Returns:

The appropriate DDL fragment.

supportsInsertSelectIdentity

Description copied from class: Dialect

Does the dialect support some form of inserting and selecting the generated IDENTITY value all in the same statement.

Overrides:

supportsInsertSelectIdentity in class Dialect

Returns:

True if the dialect supports selecting the just generated IDENTITY in the insert statement.

appendIdentitySelectToInsert

Description copied from class: Dialect

Provided we Dialect.supportsInsertSelectIdentity(), then attach the 'select identity' clause to the insert statement.

Note, if Dialect.supportsInsertSelectIdentity() false then the insert-string should be returned without modification.

Overrides:

appendIdentitySelectToInsert in class Dialect

Parameters:

insertSQL - The insert command

Returns:

The insert command with any necessary identity select clause attached.

registerResultSetOutParameter

Description copied from class: Dialect

Registers an OUT parameter which will be returning a ResultSet. How this is accomplished varies greatly from DB to DB, hence its inclusion (along with Dialect.getResultSet(java.sql.CallableStatement)) here.

Overrides:

registerResultSetOutParameter in class Dialect

Parameters:

statement - The callable statement.

col - The bind position at which to register the OUT param.

Returns:

The number of (contiguous) bind positions used.

Throws:

SQLException - Indicates problems registering the OUT param.

getResultSet

Description copied from class: Dialect

Given a callable statement previously processed by Dialect.registerResultSetOutParameter(java.sql.CallableStatement, int), extract the ResultSet from the OUT parameter.

Overrides:

getResultSet in class Dialect

Parameters:

ps - The callable statement.

Returns:

The extracted result set.

Throws:

SQLException - Indicates problems extracting the result set.

supportsCurrentTimestampSelection

Description copied from class: Dialect

Does this dialect support a way to retrieve the database's current timestamp value?

Overrides:

supportsCurrentTimestampSelection in class Dialect

Returns:

True if the current timestamp can be retrieved; false otherwise.

isCurrentTimestampSelectStringCallable

Description copied from class: Dialect

Should the value returned by Dialect.getCurrentTimestampSelectString() be treated as callable. Typically this indicates that JDBC escape syntax is being used..

Overrides:

isCurrentTimestampSelectStringCallable in class Dialect

Returns:

True if the Dialect.getCurrentTimestampSelectString() return is callable; false otherwise.

getCurrentTimestampSelectString

Description copied from class: Dialect

Retrieve the command used to retrieve the current timestamp from the database.

Overrides:

getCurrentTimestampSelectString in class Dialect

Returns:

The command.

supportsTemporaryTables

Description copied from class: Dialect

Does this dialect support temporary tables?

Overrides:

supportsTemporaryTables in class Dialect

Returns:

True if temp tables are supported; false otherwise.

generateTemporaryTableName

Description copied from class: Dialect

Generate a temporary table name given the base table.

Overrides:

generateTemporaryTableName in class Dialect

Parameters:

baseTableName - The table name from which to base the temp table name.

Returns:

The generated temp table name.

dropTemporaryTableAfterUse

Description copied from class: Dialect

Do we need to drop the temporary table after use?

Overrides:

dropTemporaryTableAfterUse in class Dialect

Returns:

True if the table should be dropped.

Dialect Does Not Support Identity Key Generation Confluence System

getSelectGUIDString

Description copied from class: Dialect

Get the command used to select a GUID from the underlying database.

Dialect Does Not Support Identity Key Generation Confluence Mean

/windows-8-professional-64-bit-product-key-generator.html. Optional operation.

Overrides:

getSelectGUIDString in class Dialect

Returns:

The appropriate command.

supportsEmptyInList

Description copied from class: Dialect

Does this dialect support empty IN lists?

For example, is [where XYZ in ()] a supported construct?

Overrides:

supportsEmptyInList in class Dialect

Returns:

True if empty in lists are supported; false otherwise.

supportsUnionAll

Description copied from class: Dialect

Does this dialect support UNION ALL, which is generally a faster variant of UNION?

Overrides:

supportsUnionAll in class Dialect

Returns:

True if UNION ALL is supported; false otherwise.

supportsExistsInSelect

Description copied from class: Dialect

Does the dialect support an exists statement in the select clause?

Overrides:

supportsExistsInSelect in class Dialect

Returns:

True if exists checks are allowed in the select clause; false otherwise.

doesReadCommittedCauseWritersToBlockReaders

Description copied from class: Dialect

For the underlying database, is READ_COMMITTED isolation implemented by forcing readers to wait for write locks to be released?

Overrides:

doesReadCommittedCauseWritersToBlockReaders in class Dialect

Returns:

True if writers block readers to achieve READ_COMMITTED; false otherwise.

doesRepeatableReadCauseReadersToBlockWriters

Description copied from class: Dialect

For the underlying database, is REPEATABLE_READ isolation implemented by forcing writers to wait for read locks to be released?

Overrides:

doesRepeatableReadCauseReadersToBlockWriters in class Dialect

Returns:

True if readers block writers to achieve REPEATABLE_READ; false otherwise.

supportsTupleDistinctCounts

Description copied from class: Dialect

Does this dialect support `count(distinct a,b)`?

Overrides:

supportsTupleDistinctCounts in class Dialect

Returns:

True if the database supports counting disintct tuples; false otherwise.

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

FRAMESNO FRAMESAll Classes SUMMARY: NESTED FIELD CONSTR METHODDETAIL: FIELD CONSTR METHODCopyright © 2001-2010 Red Hat, Inc. All Rights Reserved.