Top Description Constructors Methods
org.hibernate.dialect

public Class DB2400Dialect

extends DB2Dialect
Class Inheritance
Known Direct Subclasses
org.hibernate.dialect.DB2400V7R3Dialect
Imports
org.hibernate.dialect.identity.DB2390IdentityColumnSupport, .IdentityColumnSupport, org.hibernate.dialect.pagination.AbstractLimitHandler, .LimitHandler, .LimitHelper, org.hibernate.engine.spi.RowSelection
An SQL dialect for DB2/400. This class provides support for DB2 Universal Database for iSeries, also known as DB2/400.
Author
Peter DeGregorio (pdegregorio)

Constructor Summary

AccessConstructor and Description
public
DB2400Dialect()

Method Summary

Modifier and TypeMethod and Description
public String
getForUpdateString()

Overrides org.hibernate.dialect.DB2Dialect.getForUpdateString.

Get the string to append to SELECT statements to acquire locks for this dialect.
public IdentityColumnSupport
getIdentityColumnSupport()

Overrides org.hibernate.dialect.DB2Dialect.getIdentityColumnSupport.

Get the appropriate IdentityColumnSupport
public String
getLimitString(String
The query to which to apply the limit.
sql, int
The offset of the limit
offset, int
The limit of the limit ;)
limit)

Overrides org.hibernate.dialect.DB2Dialect.getLimitString.

Given a limit and an offset, apply the limit clause to the query.
public String
getQuerySequencesString()

Overrides org.hibernate.dialect.DB2Dialect.getQuerySequencesString.

Get the select command used retrieve the names of all sequences.
public boolean
supportsLimitOffset()

Overrides org.hibernate.dialect.Dialect.supportsLimitOffset.

Does this dialect's LIMIT support (if any) additionally support specifying an offset?
public boolean
supportsSequences()

Overrides org.hibernate.dialect.DB2Dialect.supportsSequences.

Does this dialect support sequences?
Inherited from org.hibernate.dialect.DB2Dialect:
buildSQLExceptionConversionDelegateconvertToFirstRowValuedoesReadCommittedCauseWritersToBlockReadersdropConstraintsgetAddColumnStringgetCreateSequenceStringgetCrossJoinSeparatorgetCurrentTimestampSelectStringgetDefaultMultiTableBulkIdStrategygetDropSchemaCommandgetDropSequenceStringgetInExpressionCountLimitgetLimitHandlergetLowercaseFunctiongetNotExpressiongetResultSetgetSelectClauseNullStringgetSelectSequenceNextValStringgetSequenceInformationExtractorgetSequenceNextValStringgetSqlTypeDescriptorOverridegetUniqueDelegateisCurrentTimestampSelectStringCallableregisterResultSetOutParameterrenderOrderByElementrequiresCastingOfParametersInSelectClausesupportsCommentOnsupportsCurrentTimestampSelectionsupportsEmptyInListsupportsExistsInSelectsupportsLimitsupportsLobValueChangePropogationsupportsLockTimeoutssupportsOuterJoinForUpdatesupportsParametersInInsertSelectsupportsPartitionBysupportsPooledSequencessupportsResultSetPositionQueryMethodsOnForwardOnlyCursorsupportsTupleDistinctCountssupportsUnionAllsupportsVariableLimituseMaxForLimit

Constructor Detail

DB2400Dialectback to summary
public DB2400Dialect()

Method Detail

getForUpdateStringback to summary
public String getForUpdateString()

Overrides org.hibernate.dialect.DB2Dialect.getForUpdateString.

Doc from org.hibernate.dialect.Dialect.getForUpdateString.

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

Returns:String

The appropriate FOR UPDATE clause string.

Annotations
@Override
getIdentityColumnSupportback to summary
public IdentityColumnSupport getIdentityColumnSupport()

Overrides org.hibernate.dialect.DB2Dialect.getIdentityColumnSupport.

Doc from org.hibernate.dialect.Dialect.getIdentityColumnSupport.

Get the appropriate IdentityColumnSupport

Returns:IdentityColumnSupport

the IdentityColumnSupport

Annotations
@Override
getLimitStringback to summary
public String getLimitString(String sql, int offset, int limit)

Overrides org.hibernate.dialect.DB2Dialect.getLimitString.

Doc from org.hibernate.dialect.Dialect.getLimitString.

Given a limit and an offset, apply the limit clause to the query.

Parameters
sql:String

The query to which to apply the limit.

offset:int

The offset of the limit

limit:int

The limit of the limit ;)

Returns:String

The modified query statement with the limit applied.

Annotations
@Override
getQuerySequencesStringback to summary
public String getQuerySequencesString()

Overrides org.hibernate.dialect.DB2Dialect.getQuerySequencesString.

Doc from org.hibernate.dialect.Dialect.getQuerySequencesString.

Get the select command used retrieve the names of all sequences.

Returns:String

The select command; or null if sequences are not supported.

Annotations
@Override
supportsLimitOffsetback to summary
public boolean supportsLimitOffset()

Overrides org.hibernate.dialect.Dialect.supportsLimitOffset.

Doc from org.hibernate.dialect.Dialect.supportsLimitOffset.

Does this dialect's LIMIT support (if any) additionally support specifying an offset?

Returns:boolean

True if the dialect supports an offset within the limit support.

Annotations
@Override
@SuppressWarnings:deprecation
supportsSequencesback to summary
public boolean supportsSequences()

Overrides org.hibernate.dialect.DB2Dialect.supportsSequences.

Doc from org.hibernate.dialect.Dialect.supportsSequences.

Does this dialect support sequences?

Returns:boolean

True if sequences supported; false otherwise.

Annotations
@Override