当前页面: 在线文档首页 > Hibernate 3.2.4 正式版 API 英文文档

IngresDialect (Hibernate API Documentation) - Hibernate 3.2.4 正式版 API 英文文档

Overview  Package   Class  Use  Tree  Deprecated  Index  Help
PREV CLASS   NEXT CLASS	FRAMES    NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---

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.

Known limitations: - only supports simple constants or columns on the left side of an IN, making (1,2,3) in (...) or (

Author:

Ian Booth, Bruce Lunsford, Max Rydahl Andersen

---

Field Summary

 

Fields inherited from class org.hibernate.dialect.Dialect

CLOSED_QUOTE, DEFAULT_BATCH_SIZE, NO_BATCH, QUOTE

 

Constructor Summary

IngresDialect()

 

Method Summary
boolean	dropConstraints()           Do we need to drop constraints before dropping tables in this dialect?
String	generateTemporaryTableName(String baseTableName)           Generate a temporary table name given the bas table.
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	getCreateTemporaryTablePostfix()           Get any fragments needing to be postfixed to the command for temporary table creation.
String	getCreateTemporaryTableString()           Command used to create a temporary table.
String	getCurrentTimestampSQLFunctionName()           Expression for current_timestamp
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	supportsNotNullUnique()           Ingres explicitly needs "unique not null", because "with null" is default
boolean	supportsSequences()           Does this dialect support sequences?
boolean	supportsSubselectAsInPredicateLHS()           Are subselects supported as the left-hand-side (LHS) of IN-predicates.
boolean	supportsTemporaryTables()           Does this dialect support temporary tables?
boolean	supportsVariableLimit()           Does this dialect support bind variables (i.e., prepared statememnt parameters) for its limit/offset?
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, applyLocksToSql, areStringComparisonsCaseInsensitive, bindLimitParametersFirst, bindLimitParametersInReverseOrder, buildSQLExceptionConverter, closeQuote, createCaseFragment, createOuterJoinFragment, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, dropTemporaryTableAfterUse, forUpdateOfColumns, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getCascadeConstraintsString, getCastTypeName, getColumnComment, getCreateMultisetTableString, getCreateSequenceString, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getCurrentTimestampSelectString, getDefaultProperties, getDialect, getDialect, getDropForeignKeyString, getDropSequenceStrings, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnString, getIdentityColumnString, getIdentityInsertString, getIdentitySelectString, getIdentitySelectString, getKeywords, getLimitString, getLockingStrategy, 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, supportsBindAsCallableArgument, supportsCascadeDelete, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsCommentOn, supportsCurrentTimestampSelection, supportsEmptyInList, supportsExistsInSelect, supportsExpectedLobUsagePattern, supportsIdentityColumns, supportsIfExistsAfterTableName, supportsIfExistsBeforeTableName, supportsInsertSelectIdentity, supportsLobValueChangePropogation, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPooledSequences, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInList, supportsSubqueryOnMutatingTable, supportsTableCheck, supportsUnboundedLobLocatorMaterialization, 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?

Returns:

True (Ingres does support "for update of" syntax...)

---

getAddColumnString

public String getAddColumnString()

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

Overrides:

getAddColumnString in class Dialect

Returns:

The "add column" fragment.

---

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

---

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

---

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

---

getQuerySequencesString

public String getQuerySequencesString()

A query used to find all sequences

Overrides:

getQuerySequencesString in class Dialect

Returns:

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

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

Returns:

True if this dialect supports some form of LIMIT.

---

supportsLimitOffset

public boolean supportsLimitOffset()

Does this dialect support an offset?

Overrides:

supportsLimitOffset in class Dialect

Returns:

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

---

getLimitString

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

Add a LIMIT clause to the given SQL SELECT

Overrides:

getLimitString in class Dialect

Parameters:

querySelect - The query to which to apply the limit.

offset - The offset of the limit

limit - The limit of the limit ;)

Returns:

the modified SQL

---

supportsVariableLimit

public boolean supportsVariableLimit()

Description copied from class: Dialect

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

Overrides:

supportsVariableLimit in class Dialect

Returns:

True if bind variables can be used; false otherwise.

---

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

Returns:

True if limit is relative from offset; false otherwise.

---

supportsNotNullUnique

public boolean supportsNotNullUnique()

Ingres explicitly needs "unique not null", because "with null" is default

Overrides:

supportsNotNullUnique in class Dialect

---

supportsTemporaryTables

public boolean supportsTemporaryTables()

Does this dialect support temporary tables?

Overrides:

supportsTemporaryTables in class Dialect

Returns:

True if temp tables are supported; false otherwise.

---

getCreateTemporaryTableString

public String getCreateTemporaryTableString()

Description copied from class: Dialect

Command used to create a temporary table.

Overrides:

getCreateTemporaryTableString in class Dialect

Returns:

The command used to create a temporary table.

---

getCreateTemporaryTablePostfix

public String getCreateTemporaryTablePostfix()

Description copied from class: Dialect

Get any fragments needing to be postfixed to the command for temporary table creation.

Overrides:

getCreateTemporaryTablePostfix in class Dialect

Returns:

Any required postfix.

---

generateTemporaryTableName

public String generateTemporaryTableName(String baseTableName)

Description copied from class: Dialect

Generate a temporary table name given the bas 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.

---

getCurrentTimestampSQLFunctionName

public String getCurrentTimestampSQLFunctionName()

Expression for current_timestamp

Overrides:

getCurrentTimestampSQLFunctionName in class Dialect

Returns:

The function name.

---

supportsSubselectAsInPredicateLHS

public boolean supportsSubselectAsInPredicateLHS()

Description copied from class: Dialect

Are subselects supported as the left-hand-side (LHS) of IN-predicates.

In other words, is syntax like "... IN (1, 2, 3) ..." supported?

Overrides:

supportsSubselectAsInPredicateLHS in class Dialect

Returns:

True if subselects can appear as the LHS of an in-predicate; false otherwise.

---

Overview  Package   Class  Use  Tree  Deprecated  Index  Help
PREV CLASS   NEXT CLASS	FRAMES    NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---