MySQLDialect

extends MySQLDialect

java.lang.Object
↳	net.sf.hibernate.dialect.Dialect
	↳	net.sf.hibernate.dialect.MySQLDialect
		↳	com.atlassian.hibernate.dialect.MySQLDialect

Class Overview

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)

Summary

[Expand]

Inherited Constants

From class net.sf.hibernate.dialect.Dialect

Public Constructors
	MySQLDialect()

Public Methods
String	getAddForeignKeyConstraintString(String constraintName, String[] foreignKey, String referencedTable, String[] primaryKey) 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).

[Expand]

Inherited Methods

From class net.sf.hibernate.dialect.MySQLDialect

From class net.sf.hibernate.dialect.Dialect

String	appendIdentitySelectToInsert(String arg0)
boolean	bindLimitParametersFirst()
boolean	bindLimitParametersInReverseOrder()
SQLExceptionConverter	buildSQLExceptionConverter()
char	closeQuote()
CaseFragment	createCaseFragment()
JoinFragment	createOuterJoinFragment()
boolean	dropConstraints()
String	getAddColumnString()
String	getAddForeignKeyConstraintString(String arg0, String[] arg1, String arg2, String[] arg3)
String	getAddPrimaryKeyConstraintString(String arg0)
String	getCascadeConstraintsString()
String	getCreateSequenceString(String arg0)
final Properties	getDefaultProperties()
static Dialect	getDialect()
static Dialect	getDialect(Properties arg0)
String	getDropForeignKeyString()
String	getDropSequenceString(String arg0)
final Map	getFunctions()
String	getIdentityColumnString()
String	getIdentityInsertString()
String	getIdentitySelectString()
String	getLimitString(String arg0, boolean arg1, int arg2)
String	getLimitString(String arg0, boolean arg1)
String	getLowercaseFunction()
String	getNoColumnsInsertString()
String	getNullColumnString()
String	getQuerySequencesString()
char	getSchemaSeparator()
String	getSequenceNextValString(String arg0)
String	getTypeName(int arg0, int arg1)
String	getTypeName(int arg0)
ViolatedConstraintNameExtracter	getViolatedConstraintNameExtracter()
boolean	hasAlterTable()
boolean	hasDataTypeInIdentityColumn()
char	openQuote()
boolean	qualifyIndexName()
void	registerColumnType(int arg0, int arg1, String arg2)
void	registerColumnType(int arg0, String arg1)
void	registerFunction(String arg0, SQLFunction arg1)
boolean	supportsCheck()
boolean	supportsForUpdate()
boolean	supportsForUpdateNowait()
boolean	supportsForUpdateOf()
boolean	supportsIdentityColumns()
boolean	supportsIfExistsAfterTableName()
boolean	supportsIfExistsBeforeTableName()
boolean	supportsLimit()
boolean	supportsLimitOffset()
boolean	supportsSequences()
boolean	supportsUnique()
boolean	supportsUniqueConstraintInCreateAlterTable()
boolean	supportsVariableLimit()
String	toString()
boolean	useMaxForLimit()

From class java.lang.Object

Public Constructors

public MySQLDialect ()

Public Methods

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

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.