Class MySQLDialect

  • Direct Known Subclasses:
    MySQLDialectV2

    @Deprecated
    public class MySQLDialect
    extends net.sf.hibernate.dialect.MySQLDialect
    Deprecated.
    since 6.1 This dialect has been replaced with com.atlassian.confluence.impl.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 Description
      MySQLDialect()
      Deprecated.
       
    • Method Summary

      All Methods Instance Methods Concrete Methods Deprecated Methods 
      Modifier and Type Method 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
    • 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