com.atlassian.hibernate.dialect

Class MySQLDialect

java.lang.Object

net.sf.hibernate.dialect.Dialect

net.sf.hibernate.dialect.MySQLDialect

com.atlassian.hibernate.dialect.MySQLDialect

Direct Known Subclasses:

MySQLDialectV2

Deprecated.

since 6.1 This dialect has been replaced with com.atlassian.confluence.impl.hibernate.dialect.MySQLDialect

@Deprecated
public class MySQLDialect
extends net.sf.hibernate.dialect.MySQLDialect

Custom MySQLDialect that specifies the constraint name when calling "add index".

This fixes the problem of multiple indexes and FK contraints being created for tables when they already exist (CONF-1204)

Field Summary

Fields inherited from class net.sf.hibernate.dialect.Dialect

CLOSED_QUOTE, QUOTE

Constructor Summary

Constructors

Constructor and Description
MySQLDialect() Deprecated.

Method Summary

Modifier and Type	Method and Description
String	getAddForeignKeyConstraintString(String constraintName, String[] foreignKey, String referencedTable, String[] primaryKey) Deprecated. note: previously, this string also included an 'add index' component (which meant that for MySQL users get an index added for each of their FK's).

Methods inherited from class net.sf.hibernate.dialect.MySQLDialect

buildSQLExceptionConverter, closeQuote, dropConstraints, getAddColumnString, getDropForeignKeyString, getIdentityColumnString, getIdentitySelectString, getLimitString, getSchemaSeparator, openQuote, qualifyIndexName, supportsIdentityColumns, supportsIfExistsBeforeTableName, supportsLimit

Methods inherited from class net.sf.hibernate.dialect.Dialect

appendIdentitySelectToInsert, bindLimitParametersFirst, bindLimitParametersInReverseOrder, createCaseFragment, createOuterJoinFragment, getAddPrimaryKeyConstraintString, getCascadeConstraintsString, getCreateSequenceString, getDefaultProperties, getDialect, getDialect, getDropSequenceString, getFunctions, getIdentityInsertString, getLimitString, getLowercaseFunction, getNoColumnsInsertString, getNullColumnString, getQuerySequencesString, getSequenceNextValString, getTypeName, getTypeName, getViolatedConstraintNameExtracter, hasAlterTable, hasDataTypeInIdentityColumn, registerColumnType, registerColumnType, registerFunction, supportsCheck, supportsForUpdate, supportsForUpdateNowait, supportsForUpdateOf, supportsIfExistsAfterTableName, supportsLimitOffset, supportsSequences, supportsUnique, supportsUniqueConstraintInCreateAlterTable, supportsVariableLimit, toString, useMaxForLimit

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQLDialect

public MySQLDialect()

Deprecated.

Method Detail

getAddForeignKeyConstraintString

public String getAddForeignKeyConstraintString(String constraintName,
                                               String[] foreignKey,
                                               String referencedTable,
                                               String[] primaryKey)

Deprecated.

note: previously, this string also included an 'add index' component (which meant that for MySQL users get an index added for each of their FK's). However, since we now specify the indexes explicitly in the hibernate mapping files, we need to comment this count to prevent duplicate indexes.

Overrides:

getAddForeignKeyConstraintString in class net.sf.hibernate.dialect.MySQLDialect