org.hibernate.dialect

Class DB2Dialect

Known Direct Subclasses:
DB2390Dialect, DB2400Dialect, DerbyDialect

public class DB2Dialect
extends Dialect

An SQL dialect for DB2.
Author:
Gavin King

Field Summary

Fields inherited from class org.hibernate.dialect.Dialect

CLOSED_QUOTE, DEFAULT_BATCH_SIZE, NO_BATCH, QUOTE

Constructor Summary

DB2Dialect()

Method Summary

boolean
dropConstraints()
String
generateTemporaryTableName(String baseTableName)
String
getAddColumnString()
String
getCreateSequenceString(String sequenceName)
String
getCreateTemporaryTablePostfix()
String
getCreateTemporaryTableString()
String
getCurrentTimestampSelectString()
String
getDropSequenceString(String sequenceName)
String
getForUpdateString()
String
getIdentityColumnString()
String
getIdentityInsertString()
String
getIdentitySelectString()
String
getLimitString(String sql, boolean hasOffset)
String
getLowercaseFunction()
String
getQuerySequencesString()
ResultSet
getResultSet(CallableStatement ps)
String
getSelectClauseNullString(int sqlType)
String
getSequenceNextValString(String sequenceName)
boolean
isCurrentTimestampSelectStringCallable()
static void
main(String[] args)
int
registerResultSetOutParameter(CallableStatement statement, int col)
boolean
supportsCommentOn()
boolean
supportsCurrentTimestampSelection()
boolean
supportsEmptyInList()
boolean
supportsIdentityColumns()
boolean
supportsLimit()
boolean
supportsNotNullUnique()
boolean
supportsOuterJoinForUpdate()
boolean
supportsParametersInInsertSelect()
boolean
supportsSequences()
boolean
supportsTemporaryTables()
boolean
supportsUnionAll()
boolean
useMaxForLimit()

Methods inherited from class org.hibernate.dialect.Dialect

appendIdentitySelectToInsert, appendLockHint, applyLocksToSql, areStringComparisonsCaseInsensitive, bindLimitParametersFirst, bindLimitParametersInReverseOrder, buildSQLExceptionConverter, closeQuote, createCaseFragment, createOuterJoinFragment, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, dropConstraints, dropTemporaryTableAfterUse, forUpdateOfColumns, generateTemporaryTableName, getAddColumnString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getCascadeConstraintsString, getCastTypeName, getColumnComment, getCreateMultisetTableString, getCreateSequenceString, getCreateSequenceString, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getCurrentTimestampSQLFunctionName, getCurrentTimestampSelectString, getDefaultProperties, getDialect, getDialect, getDropForeignKeyString, getDropSequenceString, getDropSequenceStrings, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnString, getIdentityColumnString, getIdentityInsertString, getIdentitySelectString, getIdentitySelectString, getKeywords, getLimitString, getLimitString, getLockingStrategy, getLowercaseFunction, getMaxAliasLength, getNativeIdentifierGeneratorClass, getNoColumnsInsertString, getNullColumnString, getQuerySequencesString, getResultSet, getSelectClauseNullString, getSelectGUIDString, getSelectSequenceNextValString, getSequenceNextValString, 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, supportsLimit, supportsLimitOffset, supportsLobValueChangePropogation, supportsNotNullUnique, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPooledSequences, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInList, supportsSequences, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTemporaryTables, supportsUnboundedLobLocatorMaterialization, supportsUnionAll, supportsUnique, supportsUniqueConstraintInCreateAlterTable, supportsVariableLimit, toBooleanValueString, toString, transformSelectString, useInputStreamToInsertBlob, useMaxForLimit

Constructor Details

DB2Dialect

public DB2Dialect()

Method Details

dropConstraints

public boolean dropConstraints()
Overrides:
dropConstraints in interface Dialect

generateTemporaryTableName

public String generateTemporaryTableName(String baseTableName)
Overrides:
generateTemporaryTableName in interface Dialect

getAddColumnString

public String getAddColumnString()
Overrides:
getAddColumnString in interface Dialect

getCreateSequenceString

public String getCreateSequenceString(String sequenceName)
Overrides:
getCreateSequenceString in interface Dialect

getCreateTemporaryTablePostfix

public String getCreateTemporaryTablePostfix()
Overrides:
getCreateTemporaryTablePostfix in interface Dialect

getCreateTemporaryTableString

public String getCreateTemporaryTableString()
Overrides:
getCreateTemporaryTableString in interface Dialect

getCurrentTimestampSelectString

public String getCurrentTimestampSelectString()
Overrides:
getCurrentTimestampSelectString in interface Dialect

getDropSequenceString

public String getDropSequenceString(String sequenceName)
Overrides:
getDropSequenceString in interface Dialect

getForUpdateString

public String getForUpdateString()
Overrides:
getForUpdateString in interface Dialect

getIdentityColumnString

public String getIdentityColumnString()
Overrides:
getIdentityColumnString in interface Dialect

getIdentityInsertString

public String getIdentityInsertString()
Overrides:
getIdentityInsertString in interface Dialect

getIdentitySelectString

public String getIdentitySelectString()
Overrides:
getIdentitySelectString in interface Dialect

getLimitString

public String getLimitString(String sql,
                             boolean hasOffset)
Overrides:
getLimitString in interface Dialect

getLowercaseFunction

public String getLowercaseFunction()
Overrides:
getLowercaseFunction in interface Dialect

getQuerySequencesString

public String getQuerySequencesString()
Overrides:
getQuerySequencesString in interface Dialect

getResultSet

public ResultSet getResultSet(CallableStatement ps)
            throws SQLException
Overrides:
getResultSet in interface Dialect

getSelectClauseNullString

public String getSelectClauseNullString(int sqlType)
Overrides:
getSelectClauseNullString in interface Dialect

getSequenceNextValString

public String getSequenceNextValString(String sequenceName)
Overrides:
getSequenceNextValString in interface Dialect

isCurrentTimestampSelectStringCallable

public boolean isCurrentTimestampSelectStringCallable()
Overrides:
isCurrentTimestampSelectStringCallable in interface Dialect

main

public static void main(String[] args)

registerResultSetOutParameter

public int registerResultSetOutParameter(CallableStatement statement,
                                         int col)
            throws SQLException
Overrides:
registerResultSetOutParameter in interface Dialect

supportsCommentOn

public boolean supportsCommentOn()
Overrides:
supportsCommentOn in interface Dialect

supportsCurrentTimestampSelection

public boolean supportsCurrentTimestampSelection()
Overrides:
supportsCurrentTimestampSelection in interface Dialect

supportsEmptyInList

public boolean supportsEmptyInList()
Overrides:
supportsEmptyInList in interface Dialect

supportsIdentityColumns

public boolean supportsIdentityColumns()
Overrides:
supportsIdentityColumns in interface Dialect

supportsLimit

public boolean supportsLimit()
Overrides:
supportsLimit in interface Dialect

supportsNotNullUnique

public boolean supportsNotNullUnique()
Overrides:
supportsNotNullUnique in interface Dialect

supportsOuterJoinForUpdate

public boolean supportsOuterJoinForUpdate()
Overrides:
supportsOuterJoinForUpdate in interface Dialect

supportsParametersInInsertSelect

public boolean supportsParametersInInsertSelect()
Overrides:
supportsParametersInInsertSelect in interface Dialect

supportsSequences

public boolean supportsSequences()
Overrides:
supportsSequences in interface Dialect

supportsTemporaryTables

public boolean supportsTemporaryTables()
Overrides:
supportsTemporaryTables in interface Dialect

supportsUnionAll

public boolean supportsUnionAll()
Overrides:
supportsUnionAll in interface Dialect

useMaxForLimit

public boolean useMaxForLimit()
Overrides:
useMaxForLimit in interface Dialect