MySQLPlatform (Oracle Fusion Middleware Java API Reference for Oracle TopLink)

java.lang.Object
- org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
- - org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - - org.eclipse.persistence.platform.database.DatabasePlatform
    - - org.eclipse.persistence.platform.database.MySQLPlatform

All Implemented Interfaces:

java.io.Serializable, java.lang.Cloneable, org.eclipse.persistence.internal.databaseaccess.Platform
```
public class MySQLPlatform
extends DatabasePlatform
```
Purpose: Provides MySQL specific behavior.

Responsibilities:
- Native SQL for Date, Time, & Timestamp.
- Native sequencing.
- Mapping of class types to database types for the schema framework.
- Pessimistic locking.
- Platform specific operators.
Since:

OracleAS TopLink 10g (10.1.3)

See Also:

Serialized Form

Field Summary
- Fields inherited from class org.eclipse.persistence.platform.database.DatabasePlatform
  DEFAULT_VARCHAR_SIZE
- Fields inherited from class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  DEFAULT_MAX_BATCH_WRITING_SIZE, DEFAULT_PARAMETERIZED_MAX_BATCH_WRITING_SIZE, IS_VALID_TIMEOUT, Types_NCLOB, Types_SQLXML

Constructor Summary

Constructors
Constructor and Description

MySQLPlatform()

Constructors
Constructor and Description
`MySQLPlatform()`

Method Summary

Methods
Modifier and Type	Method and Description
`java.lang.String`	`buildProcedureCallString(StoredProcedureCall call, org.eclipse.persistence.internal.sessions.AbstractSession session, org.eclipse.persistence.internal.sessions.AbstractRecord row)` Return the stored procedure syntax for this platform.
`ValueReadQuery`	`buildSelectQueryForIdentity()` INTERNAL: Build the identity query for native sequencing.
`boolean`	`canBatchWriteWithOptimisticLocking(org.eclipse.persistence.internal.databaseaccess.DatabaseCall call)` INTERNAL: Supports Batch Writing with Optimistic Locking.
`int`	`computeMaxRowsForSQL(int firstResultIndex, int maxResults)` INTERNAL: Use the JDBC maxResults and firstResultIndex setting to compute a value to use when limiting the results of a query in SQL.
`int`	`executeBatch(java.sql.Statement statement, boolean isStatementPrepared)` Internal: This gets called on each batch statement execution Needs to be implemented so that it returns the number of rows successfully modified by this statement for optimistic locking purposes (if useNativeBatchWriting is enabled, and the call uses optimistic locking).
`java.lang.String`	`getConstraintDeletionString()` INTERNAL: Used for constraint deletion.
`java.lang.String`	`getFunctionCallHeader()` Used for stored function calls.
`java.lang.String`	`getIdentifierQuoteCharacter()` Deprecated.
`java.lang.String`	`getInOutputProcedureToken()` INTERNAL: MySQL uses the INOUT keyword for this.
`java.lang.String`	`getProcedureAsString()` MySQL does not use the AS token.
`java.lang.String`	`getProcedureBeginString()` INTERNAL: MySQL requires BEGIN.
`java.lang.String`	`getProcedureCallHeader()` INTERNAL: Used for stored procedure calls.
`java.lang.String`	`getProcedureCallTail()` Used for sp calls.
`java.lang.String`	`getProcedureEndString()` INTERNAL: MySQL requires END.
`java.lang.String`	`getSelectForUpdateString()` INTERNAL: Used for pessimistic locking.
`ValueReadQuery`	`getTimestampQuery()` INTERNAL: This method returns the query to select the timestamp from the server for MySQL.
`boolean`	`isForUpdateCompatibleWithDistinct()`
`boolean`	`isMySQL()` Answers whether platform is MySQL.
`void`	`printFieldIdentityClause(java.io.Writer writer)` INTERNAL: Append the receiver's field 'identity' constraint clause to a writer.
`void`	`printSQLSelectStatement(org.eclipse.persistence.internal.databaseaccess.DatabaseCall call, org.eclipse.persistence.internal.expressions.ExpressionSQLPrinter printer, org.eclipse.persistence.internal.expressions.SQLSelectStatement statement)`
`void`	`printStoredFunctionReturnKeyWord(java.io.Writer writer)` INTERNAL: Prints return keyword for StoredFunctionDefinition: CREATE FUNCTION StoredFunction_In (P_IN BIGINT) RETURN BIGINT The method was introduced because MySQL requires "RETURNS" instead: CREATE FUNCTION StoredFunction_In (P_IN BIGINT) RETURNS BIGINT
`boolean`	`requiresProcedureBrackets()` Used for stored procedure creation: MySQL platforms need brackets around arguments declaration even if no arguments exist.
`boolean`	`requiresTableInIndexDropDDL()` INTERNAL: Return if this database requires the table name when dropping an index.
`boolean`	`shouldAlwaysUseTempStorageForModifyAll()` INTERNAL: MySQL supports temp tables for update-all, delete-all queries.
`boolean`	`shouldPrintOutputTokenAtStart()` INTERNAL: MySQL requires the direction at the start of the argument.
`boolean`	`shouldPrintStoredProcedureArgumentNameInCall()` INTERNAL: MySQL stored procedure calls do not require the argument name be printed in the call string e.g. call MyStoredProc(?)
`boolean`	`shouldUseJDBCOuterJoinSyntax()` INTERNAL: JDBC defines an outer join syntax which many drivers do not support.
`boolean`	`supportsAutoConversionToNumericForArithmeticOperations()` Some db allow VARCHAR db field to be used in arithmetic operations automatically converting them to numeric: UPDATE OL_PHONE SET PHONE_ORDER_VARCHAR = (PHONE_ORDER_VARCHAR + 1) WHERE ...
`boolean`	`supportsCountDistinctWithMultipleFields()` INTERNAL: Indicates whether the platform supports the count distinct function with multiple fields.
`boolean`	`supportsGlobalTempTables()` INTERNAL: MySQL supports temp tables for update-all, delete-all queries.
`boolean`	`supportsIdentity()` INTERNAL: Indicates whether the platform supports identity.
`boolean`	`supportsIndividualTableLocking()` INTERNAL: Indicates whether locking clause could be selectively applied only to some tables in a ReadQuery.
`boolean`	`supportsStoredFunctions()`
`void`	`writeDeleteFromTargetTableUsingTempTableSql(java.io.Writer writer, org.eclipse.persistence.internal.helper.DatabaseTable table, org.eclipse.persistence.internal.helper.DatabaseTable targetTable, java.util.Collection pkFields, java.util.Collection targetPkFields, org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform platform)` INTERNAL: Writes MySQL specific SQL for accessing temp tables for delete-all queries.
`void`	`writeUpdateOriginalFromTempTableSql(java.io.Writer writer, org.eclipse.persistence.internal.helper.DatabaseTable table, java.util.Collection pkFields, java.util.Collection assignedFields)` INTERNAL: Writes MySQL specific SQL for accessing temp tables for update-all queries.

Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
addBatch, addStructConverter, allowsSizeInProcedureArguments, appendLiteralToCall, appendParameter, appendParameterInternal, autoCommit, beginTransaction, buildBatchCriteria, buildBatchCriteriaForComplexId, buildCallWithReturning, buildCreateIndex, buildCreateIndex, buildDropIndex, buildDropIndex, buildSequenceObjectAlterIncrementWriter, buildSequenceObjectCreationWriter, buildSequenceObjectDeletionWriter, canBuildCallWithReturning, commitTransaction, convertToDatabaseType, copyInto, createArray, createArray, createStruct, createStruct, dontBindUpdateAllQueryUsingTempTables, executeStoredProcedure, freeTemporaryObject, getAssignmentString, getBatchBeginString, getBatchDelimiterString, getBatchEndString, getCastSizeForVarcharParameter, getClassTypes, getConnection, getCreateViewString, getCreationInOutputProcedureToken, getCreationOutputProcedureToken, getCursorCode, getCustomModifyValueForCall, getDefaultSequenceTableName, getFieldTypeDefinition, getFieldTypes, getIndexNamePrefix, getInputProcedureToken, getJDBCOuterJoinString, getJDBCType, getJDBCType, getJDBCTypeForSetNull, getJdbcTypeName, getMaxBatchWritingSize, getMaxFieldNameSize, getMaxForeignKeyNameSize, getMaxIndexNameSize, getMaxUniqueKeyNameSize, getNoWaitString, getObjectFromResultSet, getOutputProcedureToken, getPartitioningCallback, getPingSQL, getProcedureArgumentSetter, getProcedureArgumentString, getQualifiedName, getQualifiedSequenceTableName, getRefValue, getRefValue, getSelectForUpdateNoWaitString, getSelectForUpdateOfString, getSelectForUpdateWaitString, getSequenceCounterFieldName, getSequenceNameFieldName, getSequencePreallocationSize, getSequenceTableName, getStatementCacheSize, getStoredProcedureParameterPrefix, getStoredProcedureTerminationToken, getStringBindingSize, getStructConverters, getTableCreationSuffix, getTempTableForTable, getTransactionIsolation, getTypeConverters, getVPDClearIdentifierQuery, getVPDCreationFunctionString, getVPDCreationPolicyString, getVPDDeletionString, getVPDSetIdentifierQuery, hasPartitioningCallback, initialize, initializeConnectionData, isAlterSequenceObjectSupported, isCastRequired, isDynamicSQLRequiredForFunctions, isInformixOuterJoin, isLockTimeoutException, isNullAllowedInSelectClause, isXDBDocument, maximumNumericValues, minimumNumericValues, minimumTimeIncrement, prepareBatchStatement, printFieldNotNullClause, printFieldNullClause, printFieldTypeSize, printFieldUnique, printValuelist, printValuelist, registerOutputParameter, requiresNamedPrimaryKeyConstraints, requiresProcedureCallBrackets, requiresProcedureCallOuputToken, requiresTypeNameToRegisterOutputParameter, requiresUniqueConstraintCreationOnTableCreate, retrieveFirstPrimaryKeyOrOne, rollbackTransaction, setCastSizeForVarcharParameter, setCursorCode, setIsCastRequired, setMaxBatchWritingSize, setParameterValueInDatabaseCall, setPartitioningCallback, setPingSQL, setPrintInnerJoinInWhereClause, setPrintOuterJoinInWhereClause, setSequenceCounterFieldName, setSequenceNameFieldName, setSequenceTableName, setShouldBindAllParameters, setShouldBindLiterals, setShouldCacheAllStatements, setShouldForceFieldNamesToUpperCase, setShouldIgnoreCaseOnFieldComparisons, setShouldOptimizeDataConversion, setShouldTrimStrings, setShouldUseRownumFiltering, setStatementCacheSize, setStringBindingSize, setSupportsAutoCommit, setTableCreationSuffix, setTransactionIsolation, setUsesBatchWriting, setUsesByteArrayBinding, setUsesJDBCBatchWriting, setUsesNativeBatchWriting, setUsesNativeSQL, setUsesStreamsForBinding, setUsesStringBinding, shouldBindAllParameters, shouldBindLiterals, shouldCacheAllStatements, shouldCreateIndicesForPrimaryKeys, shouldCreateIndicesOnUniqueKeys, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldIgnoreException, shouldOptimizeDataConversion, shouldPrintAliasForUpdate, shouldPrintConstraintNameAfter, shouldPrintFieldIdentityClause, shouldPrintInnerJoinInWhereClause, shouldPrintInOutputTokenBeforeType, shouldPrintInputTokenAtStart, shouldPrintLockingClauseAfterWhereClause, shouldPrintOuterJoinInWhereClause, shouldPrintOutputTokenBeforeType, shouldPrintStoredProcedureVariablesAfterBeginString, shouldTrimStrings, shouldUseCustomModifyForCall, shouldUseRownumFiltering, supportsANSIInnerJoinSyntax, supportsAutoCommit, supportsDeleteOnCascade, supportsForeignKeyConstraints, supportsIndexes, supportsLocalTempTables, supportsLockingQueriesWithMultipleTables, supportsNestingOuterJoins, supportsOuterJoinsWithBrackets, supportsPrimaryKeyConstraint, supportsTempTables, supportsUniqueColumns, supportsUniqueKeyConstraints, supportsVPD, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesSequenceTable, usesStreamsForBinding, usesStringBinding, wasFailureCommunicationBased, writeCleanUpTempTableSql, writeCreateTempTableSql, writeInsertIntoTableSql, writeLOB, writeParameterMarker, writeTableCreationSuffix

Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
addSequence, addSequence, buildNativeCall, buildSelectQueryForIdentity, buildSelectQueryForSequenceObject, buildSelectQueryForSequenceObject, clone, convertObject, createConnectionCustomizer, getConversionManager, getDataTypesConvertedFrom, getDataTypesConvertedTo, getDefaultSequence, getDefaultSequenceToWrite, getEndDelimiter, getOperator, getPlatformOperators, getSelectSequenceQuery, getSequence, getSequences, getSequencesToWrite, getStartDelimiter, getTableQualifier, getTimestampFromServer, getUpdateSequenceQuery, hasDefaultSequence, initializeDefaultQueries, isAccess, isAttunity, isCloudscape, isDB2, isDBase, isDerby, isFirebird, isH2, isHSQL, isInformix, isMaxDB, isODBC, isOracle, isOracle9, isPointBase, isPostgreSQL, isSQLAnywhere, isSQLServer, isSybase, isSymfoware, isTimesTen, isTimesTen7, removeAllSequences, removeSequence, setConversionManager, setDefaultSequence, setEndDelimiter, setSelectSequenceNumberQuery, setSequencePreallocationSize, setSequences, setStartDelimiter, setTableQualifier, setTimestampQuery, setUpdateSequenceQuery, shouldNativeSequenceUseTransaction, shouldPrepare, shouldSelectDistinctIncludeOrderBy, shouldSelectIncludeOrderBy, supportsNativeSequenceNumbers, supportsSequenceObjects, toString, usesPlatformDefaultSequence

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - MySQLPlatform
```
public MySQLPlatform()
```
- Method Detail
  - buildSelectQueryForIdentity
```
public ValueReadQuery buildSelectQueryForIdentity()
```
    INTERNAL: Build the identity query for native sequencing.
    
    Overrides:
    
    buildSelectQueryForIdentity in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - buildProcedureCallString
```
public java.lang.String buildProcedureCallString(StoredProcedureCall call,
                                        org.eclipse.persistence.internal.sessions.AbstractSession session,
                                        org.eclipse.persistence.internal.sessions.AbstractRecord row)
```
    Return the stored procedure syntax for this platform.
    
    Overrides:
    
    buildProcedureCallString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - computeMaxRowsForSQL
```
public int computeMaxRowsForSQL(int firstResultIndex,
                       int maxResults)
```
    INTERNAL: Use the JDBC maxResults and firstResultIndex setting to compute a value to use when limiting the results of a query in SQL. These limits tend to be used in two ways. 1. MaxRows is the index of the last row to be returned (like JDBC maxResults) 2. MaxRows is the number of rows to be returned MySQL uses case #2 and therefore the maxResults has to be altered based on the firstResultIndex
    
    Overrides:
    
    computeMaxRowsForSQL in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Parameters:
    
    readQuery -
    
    firstResultIndex -
    
    maxResults -
    
    See Also:
    
    MySQLPlatform
  - executeBatch
```
public int executeBatch(java.sql.Statement statement,
               boolean isStatementPrepared)
                 throws java.sql.SQLException
```
    Internal: This gets called on each batch statement execution Needs to be implemented so that it returns the number of rows successfully modified by this statement for optimistic locking purposes (if useNativeBatchWriting is enabled, and the call uses optimistic locking).
    
    Overrides:
    
    executeBatch in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Parameters:
    
    isStatementPrepared - - flag is set to true if this statement is prepared
    
    Returns:
    
    - number of rows modified/deleted by this statement
    
    Throws:
    
    java.sql.SQLException
  - canBatchWriteWithOptimisticLocking
```
public boolean canBatchWriteWithOptimisticLocking(org.eclipse.persistence.internal.databaseaccess.DatabaseCall call)
```
    INTERNAL: Supports Batch Writing with Optimistic Locking.
    
    Overrides:
    
    canBatchWriteWithOptimisticLocking in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getConstraintDeletionString
```
public java.lang.String getConstraintDeletionString()
```
    INTERNAL: Used for constraint deletion.
    
    Overrides:
    
    getConstraintDeletionString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getFunctionCallHeader
```
public java.lang.String getFunctionCallHeader()
```
    Used for stored function calls.
    
    Overrides:
    
    getFunctionCallHeader in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getProcedureCallTail
```
public java.lang.String getProcedureCallTail()
```
    Used for sp calls.
    
    Overrides:
    
    getProcedureCallTail in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getSelectForUpdateString
```
public java.lang.String getSelectForUpdateString()
```
    INTERNAL: Used for pessimistic locking.
    
    Overrides:
    
    getSelectForUpdateString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - isForUpdateCompatibleWithDistinct
```
public boolean isForUpdateCompatibleWithDistinct()
```
    Overrides:
    
    isForUpdateCompatibleWithDistinct in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getTimestampQuery
```
public ValueReadQuery getTimestampQuery()
```
    INTERNAL: This method returns the query to select the timestamp from the server for MySQL.
    
    Specified by:
    
    getTimestampQuery in interface org.eclipse.persistence.internal.databaseaccess.Platform
    
    Overrides:
    
    getTimestampQuery in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - isMySQL
```
public boolean isMySQL()
```
    Answers whether platform is MySQL.
    
    Specified by:
    
    isMySQL in interface org.eclipse.persistence.internal.databaseaccess.Platform
    
    Overrides:
    
    isMySQL in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - printFieldIdentityClause
```
public void printFieldIdentityClause(java.io.Writer writer)
                              throws ValidationException
```
    INTERNAL: Append the receiver's field 'identity' constraint clause to a writer.
    
    Overrides:
    
    printFieldIdentityClause in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    ValidationException
  - shouldUseJDBCOuterJoinSyntax
```
public boolean shouldUseJDBCOuterJoinSyntax()
```
    INTERNAL: JDBC defines an outer join syntax which many drivers do not support. So we normally avoid it.
    
    Overrides:
    
    shouldUseJDBCOuterJoinSyntax in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - supportsIdentity
```
public boolean supportsIdentity()
```
    INTERNAL: Indicates whether the platform supports identity. MySQL supports native sequencing through AUTO_INCREMENT field types.
    
    Overrides:
    
    supportsIdentity in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - supportsCountDistinctWithMultipleFields
```
public boolean supportsCountDistinctWithMultipleFields()
```
    INTERNAL: Indicates whether the platform supports the count distinct function with multiple fields.
    
    Overrides:
    
    supportsCountDistinctWithMultipleFields in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - requiresTableInIndexDropDDL
```
public boolean requiresTableInIndexDropDDL()
```
    INTERNAL: Return if this database requires the table name when dropping an index.
    
    Overrides:
    
    requiresTableInIndexDropDDL in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - supportsGlobalTempTables
```
public boolean supportsGlobalTempTables()
```
    INTERNAL: MySQL supports temp tables for update-all, delete-all queries.
    
    Overrides:
    
    supportsGlobalTempTables in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - supportsIndividualTableLocking
```
public boolean supportsIndividualTableLocking()
```
    INTERNAL: Indicates whether locking clause could be selectively applied only to some tables in a ReadQuery. Example: the following locks the rows in SALARY table, doesn't lock the rows in EMPLOYEE table: on Oracle platform (method returns true): SELECT t0.EMP_ID..., t1.SALARY FROM EMPLOYEE t0, SALARY t1 WHERE ... FOR UPDATE t1.SALARY on SQLServer platform (method returns true): SELECT t0.EMP_ID..., t1.SALARY FROM EMPLOYEE t0, SALARY t1 WITH (UPDLOCK) WHERE ...
    
    Overrides:
    
    supportsIndividualTableLocking in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - supportsStoredFunctions
```
public boolean supportsStoredFunctions()
```
    Overrides:
    
    supportsStoredFunctions in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - supportsAutoConversionToNumericForArithmeticOperations
```
public boolean supportsAutoConversionToNumericForArithmeticOperations()
```
    Some db allow VARCHAR db field to be used in arithmetic operations automatically converting them to numeric: UPDATE OL_PHONE SET PHONE_ORDER_VARCHAR = (PHONE_ORDER_VARCHAR + 1) WHERE ... SELECT ... WHERE ... t0.MANAGED_ORDER_VARCHAR BETWEEN 1 AND 4 ...
    
    Overrides:
    
    supportsAutoConversionToNumericForArithmeticOperations in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - shouldAlwaysUseTempStorageForModifyAll
```
public boolean shouldAlwaysUseTempStorageForModifyAll()
```
    INTERNAL: MySQL supports temp tables for update-all, delete-all queries.
    
    Overrides:
    
    shouldAlwaysUseTempStorageForModifyAll in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - shouldPrintStoredProcedureArgumentNameInCall
```
public boolean shouldPrintStoredProcedureArgumentNameInCall()
```
    INTERNAL: MySQL stored procedure calls do not require the argument name be printed in the call string e.g. call MyStoredProc(?) instead of call MyStoredProc(myvariable = ?)
    
    Overrides:
    
    shouldPrintStoredProcedureArgumentNameInCall in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getIdentifierQuoteCharacter
```
public java.lang.String getIdentifierQuoteCharacter()
```
    Deprecated.
    
    INTERNAL: MySQL uses ' to allow identifier to have spaces.
    
    Overrides:
    
    getIdentifierQuoteCharacter in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    See Also:
    
    DatasourcePlatform.getStartDelimiter(), DatasourcePlatform.getEndDelimiter()
  - getInOutputProcedureToken
```
public java.lang.String getInOutputProcedureToken()
```
    INTERNAL: MySQL uses the INOUT keyword for this.
    
    Overrides:
    
    getInOutputProcedureToken in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getProcedureAsString
```
public java.lang.String getProcedureAsString()
```
    MySQL does not use the AS token.
    
    Overrides:
    
    getProcedureAsString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - shouldPrintOutputTokenAtStart
```
public boolean shouldPrintOutputTokenAtStart()
```
    INTERNAL: MySQL requires the direction at the start of the argument.
    
    Overrides:
    
    shouldPrintOutputTokenAtStart in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getProcedureCallHeader
```
public java.lang.String getProcedureCallHeader()
```
    INTERNAL: Used for stored procedure calls.
    
    Overrides:
    
    getProcedureCallHeader in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getProcedureBeginString
```
public java.lang.String getProcedureBeginString()
```
    INTERNAL: MySQL requires BEGIN.
    
    Overrides:
    
    getProcedureBeginString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getProcedureEndString
```
public java.lang.String getProcedureEndString()
```
    INTERNAL: MySQL requires END.
    
    Overrides:
    
    getProcedureEndString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - writeUpdateOriginalFromTempTableSql
```
public void writeUpdateOriginalFromTempTableSql(java.io.Writer writer,
                                       org.eclipse.persistence.internal.helper.DatabaseTable table,
                                       java.util.Collection pkFields,
                                       java.util.Collection assignedFields)
                                         throws java.io.IOException
```
    INTERNAL: Writes MySQL specific SQL for accessing temp tables for update-all queries.
    
    Overrides:
    
    writeUpdateOriginalFromTempTableSql in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    java.io.IOException
  - writeDeleteFromTargetTableUsingTempTableSql
```
public void writeDeleteFromTargetTableUsingTempTableSql(java.io.Writer writer,
                                               org.eclipse.persistence.internal.helper.DatabaseTable table,
                                               org.eclipse.persistence.internal.helper.DatabaseTable targetTable,
                                               java.util.Collection pkFields,
                                               java.util.Collection targetPkFields,
                                               org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform platform)
                                                 throws java.io.IOException
```
    INTERNAL: Writes MySQL specific SQL for accessing temp tables for delete-all queries.
    
    Overrides:
    
    writeDeleteFromTargetTableUsingTempTableSql in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    java.io.IOException
  - printSQLSelectStatement
```
public void printSQLSelectStatement(org.eclipse.persistence.internal.databaseaccess.DatabaseCall call,
                           org.eclipse.persistence.internal.expressions.ExpressionSQLPrinter printer,
                           org.eclipse.persistence.internal.expressions.SQLSelectStatement statement)
```
    Overrides:
    
    printSQLSelectStatement in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - requiresProcedureBrackets
```
public boolean requiresProcedureBrackets()
```
    Used for stored procedure creation: MySQL platforms need brackets around arguments declaration even if no arguments exist.
    
    Overrides:
    
    requiresProcedureBrackets in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - printStoredFunctionReturnKeyWord
```
public void printStoredFunctionReturnKeyWord(java.io.Writer writer)
                                      throws java.io.IOException
```
    INTERNAL: Prints return keyword for StoredFunctionDefinition: CREATE FUNCTION StoredFunction_In (P_IN BIGINT) RETURN BIGINT The method was introduced because MySQL requires "RETURNS" instead: CREATE FUNCTION StoredFunction_In (P_IN BIGINT) RETURNS BIGINT
    
    Overrides:
    
    printStoredFunctionReturnKeyWord in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    java.io.IOException

Class MySQLPlatform

Field Summary

Fields inherited from class org.eclipse.persistence.platform.database.DatabasePlatform

Fields inherited from class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

Constructor Summary

Method Summary

Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform

Methods inherited from class java.lang.Object

Constructor Detail

MySQLPlatform

Method Detail

buildSelectQueryForIdentity

buildProcedureCallString

computeMaxRowsForSQL

executeBatch

canBatchWriteWithOptimisticLocking

getConstraintDeletionString

getFunctionCallHeader

getProcedureCallTail

getSelectForUpdateString

isForUpdateCompatibleWithDistinct

getTimestampQuery

isMySQL

printFieldIdentityClause

shouldUseJDBCOuterJoinSyntax

supportsIdentity

supportsCountDistinctWithMultipleFields

requiresTableInIndexDropDDL

supportsGlobalTempTables

supportsIndividualTableLocking

supportsStoredFunctions

supportsAutoConversionToNumericForArithmeticOperations

shouldAlwaysUseTempStorageForModifyAll

shouldPrintStoredProcedureArgumentNameInCall

getIdentifierQuoteCharacter

getInOutputProcedureToken

getProcedureAsString

shouldPrintOutputTokenAtStart

getProcedureCallHeader

getProcedureBeginString

getProcedureEndString

writeUpdateOriginalFromTempTableSql

writeDeleteFromTargetTableUsingTempTableSql

printSQLSelectStatement

requiresProcedureBrackets

printStoredFunctionReturnKeyWord