Top Description Constructors Methods
org.hibernate.dialect

public Class Ingres9Dialect

extends IngresDialect
Class Inheritance
Known Direct Subclasses
org.hibernate.dialect.Ingres10Dialect
Imports
java.sql.Types, org.hibernate.dialect.function.NoArgSQLFunction, .VarArgsSQLFunction, org.hibernate.type.StandardBasicTypes
A SQL dialect for Ingres 9.3 and later versions.

Changes:

Authors
Enrico Schenk, Raymond Fan

Constructor Summary

AccessConstructor and Description
public
Ingres9Dialect()

Method Summary

Modifier and TypeMethod and Description
public boolean

Returns:

true
doesReadCommittedCauseWritersToBlockReaders()

Overrides org.hibernate.dialect.Dialect.doesReadCommittedCauseWritersToBlockReaders.

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

Returns:

true
doesRepeatableReadCauseReadersToBlockWriters()

Overrides org.hibernate.dialect.Dialect.doesRepeatableReadCauseReadersToBlockWriters.

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

Returns:

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

Overrides org.hibernate.dialect.Dialect.forUpdateOfColumns.

Is FOR UPDATE OF syntax supported?
public String

Returns:

The command.
getCurrentTimestampSelectString()

Overrides org.hibernate.dialect.Dialect.getCurrentTimestampSelectString.

Retrieve the command used to retrieve the current timestammp from the database.
public String
getCurrentTimestampSQLFunctionName()

Overrides org.hibernate.dialect.IngresDialect.getCurrentTimestampSQLFunctionName.

Expression for current_timestamp
public String

Returns:

Statement to retrieve last generated sequence value
getIdentitySelectString()

Overrides org.hibernate.dialect.Dialect.getIdentitySelectString.

Get the select command used to retrieve the last generated sequence value.
public String

Returns:

the modified SQL
getLimitString(String
The query to which to apply the limit.
querySelect, int
The offset of the limit
offset, int
The limit of the limit ;)
limit)

Overrides org.hibernate.dialect.IngresDialect.getLimitString.

Add a LIMIT clause to the given SQL SELECT
public String

Returns:

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

Overrides org.hibernate.dialect.IngresDialect.getQuerySequencesString.

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

Returns:

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

Overrides org.hibernate.dialect.Dialect.isCurrentTimestampSelectStringCallable.

Should the value returned by getCurrentTimestampSelectString be treated as callable.
protected void
registerDateTimeColumnTypes()

Register column types date, time, timestamp

protected void
registerDateTimeFunctions()

Register functions current_time, current_timestamp, current_date

public boolean

Returns:

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

Overrides org.hibernate.dialect.Dialect.supportsCurrentTimestampSelection.

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

Returns:

true
supportsLimitOffset()

Overrides org.hibernate.dialect.IngresDialect.supportsLimitOffset.

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

Returns:

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

Overrides org.hibernate.dialect.Dialect.supportsOuterJoinForUpdate.

Does this dialect support FOR UPDATE in conjunction with outer joined rows?
public boolean

Returns:

True if such "pooled" sequences are supported; false otherwise.
supportsPooledSequences()

Overrides org.hibernate.dialect.Dialect.supportsPooledSequences.

Does this dialect support "pooled" sequences.
public boolean

Returns:

True if UNION ALL is supported; false otherwise.
supportsUnionAll()

Overrides org.hibernate.dialect.Dialect.supportsUnionAll.

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

Returns:

false
supportsVariableLimit()

Overrides org.hibernate.dialect.IngresDialect.supportsVariableLimit.

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

Overrides org.hibernate.dialect.IngresDialect.useMaxForLimit.

Does the LIMIT clause take a "maximum" row number instead of a total number of returned rows?
Inherited from org.hibernate.dialect.IngresDialect:
dropConstraintsgenerateTemporaryTableNamegetAddColumnStringgetCreateSequenceStringgetCreateTemporaryTablePostfixgetCreateTemporaryTableStringgetDropSequenceStringgetLowercaseFunctiongetNullColumnStringgetSelectGUIDStringgetSelectSequenceNextValStringgetSequenceNextValStringsupportsEmptyInListsupportsExpectedLobUsagePatternsupportsForUpdateOfsupportsLimitsupportsNotNullUniquesupportsSequencessupportsSubselectAsInPredicateLHSsupportsTemporaryTablessupportsTupleDistinctCounts

Constructor Detail

Ingres9Dialectback to summary
public Ingres9Dialect()

Method Detail

doesReadCommittedCauseWritersToBlockReadersback to summary
public boolean doesReadCommittedCauseWritersToBlockReaders()

Overrides org.hibernate.dialect.Dialect.doesReadCommittedCauseWritersToBlockReaders.

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

Returns:boolean

true

doesRepeatableReadCauseReadersToBlockWritersback to summary
public boolean doesRepeatableReadCauseReadersToBlockWriters()

Overrides org.hibernate.dialect.Dialect.doesRepeatableReadCauseReadersToBlockWriters.

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

Returns:boolean

true

forUpdateOfColumnsback to summary
public boolean forUpdateOfColumns()

Overrides org.hibernate.dialect.Dialect.forUpdateOfColumns.

Is FOR UPDATE OF syntax supported?

Returns:boolean

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

getCurrentTimestampSelectStringback to summary
public String getCurrentTimestampSelectString()

Overrides org.hibernate.dialect.Dialect.getCurrentTimestampSelectString.

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

Returns:String

The command.

getCurrentTimestampSQLFunctionNameback to summary
public String getCurrentTimestampSQLFunctionName()

Overrides org.hibernate.dialect.IngresDialect.getCurrentTimestampSQLFunctionName.

Expression for current_timestamp

Returns:String

Doc from org.hibernate.dialect.Dialect.getCurrentTimestampSQLFunctionName.

The function name.

getIdentitySelectStringback to summary
public String getIdentitySelectString()

Overrides org.hibernate.dialect.Dialect.getIdentitySelectString.

Get the select command used to retrieve the last generated sequence value.

Returns:String

Statement to retrieve last generated sequence value

getLimitStringback to summary
public String getLimitString(String querySelect, int offset, int limit)

Overrides org.hibernate.dialect.IngresDialect.getLimitString.

Add a LIMIT clause to the given SQL SELECT

Parameters
querySelect:String

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

The query to which to apply the limit.

offset:int

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

The offset of the limit

limit:int

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

The limit of the limit ;)

Returns:String

the modified SQL

getQuerySequencesStringback to summary
public String getQuerySequencesString()

Overrides org.hibernate.dialect.IngresDialect.getQuerySequencesString.

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

Returns:String

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

See Also
org.hibernate.tool.hbm2ddl.SchemaUpdate
isCurrentTimestampSelectStringCallableback to summary
public boolean isCurrentTimestampSelectStringCallable()

Overrides org.hibernate.dialect.Dialect.isCurrentTimestampSelectStringCallable.

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

Returns:boolean

True if the getCurrentTimestampSelectString return is callable; false otherwise.

registerDateTimeColumnTypesback to summary
protected void registerDateTimeColumnTypes()

Register column types date, time, timestamp

registerDateTimeFunctionsback to summary
protected void registerDateTimeFunctions()

Register functions current_time, current_timestamp, current_date

supportsCurrentTimestampSelectionback to summary
public boolean supportsCurrentTimestampSelection()

Overrides org.hibernate.dialect.Dialect.supportsCurrentTimestampSelection.

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

Returns:boolean

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

supportsLimitOffsetback to summary
public boolean supportsLimitOffset()

Overrides org.hibernate.dialect.IngresDialect.supportsLimitOffset.

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

Returns:boolean

true

supportsOuterJoinForUpdateback to summary
public boolean supportsOuterJoinForUpdate()

Overrides org.hibernate.dialect.Dialect.supportsOuterJoinForUpdate.

Does this dialect support FOR UPDATE in conjunction with outer joined rows?

Returns:boolean

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

supportsPooledSequencesback to summary
public boolean supportsPooledSequences()

Overrides org.hibernate.dialect.Dialect.supportsPooledSequences.

Does this dialect support "pooled" sequences. Not aware of a better name for this. Essentially can we specify the initial and increment values?

Returns:boolean

True if such "pooled" sequences are supported; false otherwise.

See Also
getCreateSequenceStrings(String, int, int), getCreateSequenceString(String, int, int)
supportsUnionAllback to summary
public boolean supportsUnionAll()

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

supportsVariableLimitback to summary
public boolean supportsVariableLimit()

Overrides org.hibernate.dialect.IngresDialect.supportsVariableLimit.

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

Returns:boolean

false

useMaxForLimitback to summary
public boolean useMaxForLimit()

Overrides org.hibernate.dialect.IngresDialect.useMaxForLimit.

Does the LIMIT clause take a "maximum" row number instead of a total number of returned rows?

Returns:boolean

Doc from org.hibernate.dialect.Dialect.useMaxForLimit.

True if limit is relative from offset; false otherwise.