org.hibernate.dialect
Class IngresDialect

java.lang.Object
  org.hibernate.dialect.Dialect
      org.hibernate.dialect.IngresDialect

public class IngresDialect

extends Dialect

An Ingres SQL dialect

Author:

Ian Booth, Bruce Lunsford

Field Summary

Fields inherited from class org.hibernate.dialect.Dialect

CLOSED_QUOTE, QUOTE

Constructor Summary

IngresDialect()

Method Summary

boolean	dropConstraints() Do we need to drop constraints before dropping tables in this dialect?
String	getAddColumnString() The syntax used to add a column to a table (optional).
String	getCreateSequenceString(String sequenceName) The syntax used to create a sequence, if sequences are supported.
String	getDropSequenceString(String sequenceName) The syntax used to drop a sequence, if sequences are supported.
String	getLimitString(String querySelect, int offset, int limit) Add a LIMIT clause to the given SQL SELECT
String	getLowercaseFunction() The name of the SQL function that transforms a string to lowercase
String	getNullColumnString() The keyword used to specify a nullable column.
String	getQuerySequencesString() A query used to find all sequences
String	getSequenceNextValString(String sequenceName) The syntax that fetches the next value of a sequence, if sequences are supported.
boolean	supportsForUpdateOf() Does this dialect support FOR UPDATE OF, allowing particular rows to be locked?
boolean	supportsLimit() Does this Dialect have some kind of LIMIT syntax?
boolean	supportsLimitOffset() Does this dialect support an offset?
boolean	supportsSequences() Does this dialect support sequences?
boolean	supportsVariableLimit()
boolean	useMaxForLimit() Does the LIMIT clause take a "maximum" row number instead of a total number of returned rows?

Methods inherited from class org.hibernate.dialect.Dialect

appendIdentitySelectToInsert, appendLockHint, bindLimitParametersFirst, bindLimitParametersInReverseOrder, buildSQLExceptionConverter, closeQuote, createCaseFragment, createOuterJoinFragment, dropTemporaryTableAfterUse, forUpdateOfColumns, generateTemporaryTableName, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getCascadeConstraintsString, getCastTypeName, getColumnComment, getCreateSequenceStrings, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getCurrentTimestampSelectString, getCurrentTimestampSQLFunctionName, getDefaultProperties, getDialect, getDialect, getDropForeignKeyString, getDropSequenceStrings, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnString, getIdentityColumnString, getIdentityInsertString, getIdentitySelectString, getIdentitySelectString, getKeywords, getLimitString, getMaxAliasLength, getNativeIdentifierGeneratorClass, getNoColumnsInsertString, getResultSet, getSelectClauseNullString, getSelectGUIDString, getSelectSequenceNextValString, getTableComment, getTableTypeString, getTypeName, getTypeName, getViolatedConstraintNameExtracter, hasAlterTable, hasDataTypeInIdentityColumn, hasSelfReferentialForeignKeyBug, isCurrentTimestampSelectStringCallable, openQuote, performTemporaryTableDDLInIsolation, qualifyIndexName, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, registerResultSetOutParameter, supportsCascadeDelete, supportsColumnCheck, supportsCommentOn, supportsCurrentTimestampSelection, supportsIdentityColumns, supportsIfExistsAfterTableName, supportsIfExistsBeforeTableName, supportsInsertSelectIdentity, supportsNotNullUnique, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsTableCheck, supportsTemporaryTables, supportsUnionAll, supportsUnique, supportsUniqueConstraintInCreateAlterTable, toBooleanValueString, toString, transformSelectString, useInputStreamToInsertBlob

Methods inherited from class java.lang.Object

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

Constructor Detail

IngresDialect

public IngresDialect()

Method Detail

dropConstraints

public boolean dropConstraints()

Do we need to drop constraints before dropping tables in this dialect?

Overrides:

dropConstraints in class Dialect

Returns:

boolean

supportsForUpdateOf

public boolean supportsForUpdateOf()

Does this dialect support FOR UPDATE OF, allowing particular rows to be locked?

getAddColumnString

public String getAddColumnString()

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

Overrides:

getAddColumnString in class Dialect

getNullColumnString

public String getNullColumnString()

The keyword used to specify a nullable column.

Overrides:

getNullColumnString in class Dialect

Returns:

String

supportsSequences

public boolean supportsSequences()

Does this dialect support sequences?

Overrides:

supportsSequences in class Dialect

Returns:

boolean

getSequenceNextValString

public String getSequenceNextValString(String sequenceName)

The syntax that fetches the next value of a sequence, if sequences are supported.

Overrides:

getSequenceNextValString in class Dialect

Parameters:

sequenceName - the name of the sequence

Returns:

String

Throws:

MappingException - if no sequences

getCreateSequenceString

public String getCreateSequenceString(String sequenceName)

The syntax used to create a sequence, if sequences are supported.

Overrides:

getCreateSequenceString in class Dialect

Parameters:

sequenceName - the name of the sequence

Returns:

String

Throws:

MappingException - if no sequences

getDropSequenceString

public String getDropSequenceString(String sequenceName)

The syntax used to drop a sequence, if sequences are supported.

Overrides:

getDropSequenceString in class Dialect

Parameters:

sequenceName - the name of the sequence

Returns:

String

Throws:

MappingException - if no sequences

getQuerySequencesString

public String getQuerySequencesString()

A query used to find all sequences

Overrides:

getQuerySequencesString in class Dialect

See Also:

SchemaUpdate

getLowercaseFunction

public String getLowercaseFunction()

The name of the SQL function that transforms a string to lowercase

Overrides:

getLowercaseFunction in class Dialect

Returns:

String

supportsLimit

public boolean supportsLimit()

Does this Dialect have some kind of LIMIT syntax?

Overrides:

supportsLimit in class Dialect

supportsLimitOffset

public boolean supportsLimitOffset()

Does this dialect support an offset?

Overrides:

supportsLimitOffset in class Dialect

getLimitString

public String getLimitString(String querySelect,
                             int offset,
                             int limit)

Add a LIMIT clause to the given SQL SELECT

Overrides:

getLimitString in class Dialect

Returns:

the modified SQL

supportsVariableLimit

public boolean supportsVariableLimit()

Overrides:

supportsVariableLimit in class Dialect

useMaxForLimit

public boolean useMaxForLimit()

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

Overrides:

useMaxForLimit in class Dialect