org.hibernate.dialect

Class TimesTenDialect


public class TimesTenDialect
extends Dialect

A SQL dialect for TimesTen 5.1. Known limitations: joined-subclass support because of no CASE support in TimesTen No support for subqueries that includes aggregation - size() in HQL not supported - user queries that does subqueries with aggregation No CLOB/BLOB support No cascade delete support. No Calendar support No support for updating primary keys.
Author:
Sherry Listgarten and Max Andersen

Field Summary

Fields inherited from class org.hibernate.dialect.Dialect

CLOSED_QUOTE, DEFAULT_BATCH_SIZE, NO_BATCH, QUOTE

Constructor Summary

TimesTenDialect()

Method Summary

JoinFragment
createOuterJoinFragment()
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
getLimitString(String querySelect, int offset, int limit)
LockingStrategy
getLockingStrategy(Lockable lockable, LockMode lockMode)
String
getQuerySequencesString()
String
getSelectSequenceNextValString(String sequenceName)
String
getSequenceNextValString(String sequenceName)
boolean
isCurrentTimestampSelectStringCallable()
boolean
qualifyIndexName()
boolean
supportsColumnCheck()
boolean
supportsCurrentTimestampSelection()
boolean
supportsEmptyInList()
boolean
supportsLimit()
boolean
supportsLimitOffset()
boolean
supportsSequences()
boolean
supportsTableCheck()
boolean
supportsTemporaryTables()
boolean
supportsUnique()
boolean
supportsUniqueConstraintInCreateAlterTable()
boolean
supportsVariableLimit()
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

TimesTenDialect

public TimesTenDialect()

Method Details

createOuterJoinFragment

public JoinFragment createOuterJoinFragment()
Overrides:
createOuterJoinFragment in interface Dialect

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

getLimitString

public String getLimitString(String querySelect,
                             int offset,
                             int limit)
Overrides:
getLimitString in interface Dialect

getLockingStrategy

public LockingStrategy getLockingStrategy(Lockable lockable,
                                          LockMode lockMode)
Overrides:
getLockingStrategy in interface Dialect

getQuerySequencesString

public String getQuerySequencesString()
Overrides:
getQuerySequencesString in interface Dialect

getSelectSequenceNextValString

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

getSequenceNextValString

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

isCurrentTimestampSelectStringCallable

public boolean isCurrentTimestampSelectStringCallable()
Overrides:
isCurrentTimestampSelectStringCallable in interface Dialect

qualifyIndexName

public boolean qualifyIndexName()
Overrides:
qualifyIndexName in interface Dialect

supportsColumnCheck

public boolean supportsColumnCheck()
Overrides:
supportsColumnCheck in interface Dialect

supportsCurrentTimestampSelection

public boolean supportsCurrentTimestampSelection()
Overrides:
supportsCurrentTimestampSelection in interface Dialect

supportsEmptyInList

public boolean supportsEmptyInList()
Overrides:
supportsEmptyInList in interface Dialect

supportsLimit

public boolean supportsLimit()
Overrides:
supportsLimit in interface Dialect

supportsLimitOffset

public boolean supportsLimitOffset()
Overrides:
supportsLimitOffset in interface Dialect

supportsSequences

public boolean supportsSequences()
Overrides:
supportsSequences in interface Dialect

supportsTableCheck

public boolean supportsTableCheck()
Overrides:
supportsTableCheck in interface Dialect

supportsTemporaryTables

public boolean supportsTemporaryTables()
Overrides:
supportsTemporaryTables in interface Dialect

supportsUnique

public boolean supportsUnique()
Overrides:
supportsUnique in interface Dialect

supportsUniqueConstraintInCreateAlterTable

public boolean supportsUniqueConstraintInCreateAlterTable()
Overrides:
supportsUniqueConstraintInCreateAlterTable in interface Dialect

supportsVariableLimit

public boolean supportsVariableLimit()
Overrides:
supportsVariableLimit in interface Dialect

useMaxForLimit

public boolean useMaxForLimit()
Overrides:
useMaxForLimit in interface Dialect