public Class RDMSOS2200Dialect

Overrides org.hibernate.dialect.Dialect.createCaseFragment.

Doc from org.hibernate.dialect.Dialect.createCaseFragment.

Create a org.hibernate.sql.CaseFragment strategy responsible for handling this dialect's variations in how CASE statements are handled.

Returns:CaseFragment

This dialect's org.hibernate.sql.CaseFragment strategy.

Overrides org.hibernate.dialect.Dialect.forUpdateOfColumns.

The RDMS DB supports the 'FOR UPDATE OF' clause. However, the RDMS-JDBC driver does not support this feature, so a false is return. The base dialect also returns a false, but we will leave this over-ride in to make sure it stays false.

Returns:boolean

Doc from org.hibernate.dialect.Dialect.forUpdateOfColumns.

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

Overrides org.hibernate.dialect.Dialect.getAddColumnString.

Doc from org.hibernate.dialect.Dialect.getAddColumnString.

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

Returns:String

The "add column" fragment.

Overrides org.hibernate.dialect.Dialect.getCascadeConstraintsString.

Doc from org.hibernate.dialect.Dialect.getCascadeConstraintsString.

Completely optional cascading drop clause

Returns:String

String

Overrides org.hibernate.dialect.Dialect.getCreateSequenceString.

Doc from org.hibernate.dialect.Dialect.getCreateSequenceString.

Typically dialects which support sequences can create a sequence with a single command. This is convenience form of getCreateSequenceStrings to help facilitate that.

Dialects which support sequences and can create a sequence in a single command need *only* override this method. Dialects which support sequences but require multiple commands to create a sequence should instead override getCreateSequenceStrings.

Parameters

sequenceName:String

The name of the sequence

Returns:String

The sequence creation command

Overrides org.hibernate.dialect.Dialect.getDropSequenceString.

Doc from org.hibernate.dialect.Dialect.getDropSequenceString.

Typically dialects which support sequences can drop a sequence with a single command. This is convenience form of getDropSequenceStrings to help facilitate that.

Dialects which support sequences and can drop a sequence in a single command need *only* override this method. Dialects which support sequences but require multiple commands to drop a sequence should instead override getDropSequenceStrings.

Parameters

sequenceName:String

The name of the sequence

Returns:String

The sequence drop commands

Overrides org.hibernate.dialect.Dialect.getForUpdateString.

Since the RDMS-JDBC driver does not support for updates, this string is set to an empty string. Whenever, the driver does support this feature, the returned string should be " FOR UPDATE OF". Note that RDMS does not support the string 'FOR UPDATE' string.

Returns:String

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

The appropriate FOR UPDATE clause string.

Overrides org.hibernate.dialect.Dialect.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.

Overrides org.hibernate.dialect.Dialect.getLockingStrategy.

Doc from org.hibernate.dialect.Dialect.getLockingStrategy.

Get a strategy instance which knows how to acquire a database-level lock of the specified mode for this dialect.

Parameters

lockable:Lockable

The persister for the entity to be locked.

lockMode:LockMode

The type of lock to be acquired.

Returns:LockingStrategy

The appropriate locking strategy.

Overrides org.hibernate.dialect.Dialect.getNullColumnString.

Doc from org.hibernate.dialect.Dialect.getNullColumnString.

The keyword used to specify a nullable column.

Returns:String

String

Overrides org.hibernate.dialect.Dialect.getSequenceNextValString.

Doc from org.hibernate.dialect.Dialect.getSequenceNextValString.

Generate the appropriate select statement to to retrieve the next value of a sequence.

This should be a "stand alone" select statement.

Parameters

sequenceName:String

the name of the sequence

Returns:String

String The "nextval" select string.

Overrides org.hibernate.dialect.Dialect.qualifyIndexName.

RDMS does not support qualifing index names with the schema name.

Returns:boolean

Doc from org.hibernate.dialect.Dialect.qualifyIndexName.

boolean

Overrides org.hibernate.dialect.Dialect.supportsCascadeDelete.

RDMS does not support Cascade Deletes. Need to review this in the future when support is provided.

Overrides org.hibernate.dialect.Dialect.supportsLimit.

Doc from org.hibernate.dialect.Dialect.supportsLimit.

Does this dialect support some form of limiting query results via a SQL clause?

Returns:boolean

True if this dialect supports some form of LIMIT.

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.

Overrides org.hibernate.dialect.Dialect.supportsOuterJoinForUpdate.

Currently, RDMS-JDBC does not support ForUpdate. Need to review this in the future when support is provided.

Returns:boolean

Doc from org.hibernate.dialect.Dialect.supportsOuterJoinForUpdate.

True if outer joined rows can be locked via FOR UPDATE.

Overrides org.hibernate.dialect.Dialect.supportsSequences.

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

Does this dialect support sequences?

Returns:boolean

True if sequences supported; false otherwise.

Overrides org.hibernate.dialect.Dialect.supportsUnionAll.

Doc from org.hibernate.dialect.Dialect.supportsUnionAll.

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

Returns:boolean

True if UNION ALL is supported; false otherwise.

Overrides org.hibernate.dialect.Dialect.supportsUniqueConstraintInCreateAlterTable.

RDMS does not support adding Unique constraints via create and alter table.

Returns:boolean

Doc from org.hibernate.dialect.Dialect.supportsUniqueConstraintInCreateAlterTable.

boolean

Overrides org.hibernate.dialect.Dialect.supportsVariableLimit.

Doc from org.hibernate.dialect.Dialect.supportsVariableLimit.

Does this dialect support bind variables (i.e., prepared statement parameters) for its limit/offset?

Returns:boolean

True if bind variables can be used; false otherwise.