Package org.jumpmind.db.platform.mysql

Class MySqlJdbcSqlTemplate

java.lang.Object

org.jumpmind.db.sql.AbstractSqlTemplate

org.jumpmind.db.sql.JdbcSqlTemplate

org.jumpmind.db.platform.mysql.MySqlJdbcSqlTemplate

All Implemented Interfaces:

ISqlTemplate

public class MySqlJdbcSqlTemplate
extends JdbcSqlTemplate

Field Summary

Fields inherited from class org.jumpmind.db.sql.JdbcSqlTemplate

dataSource, dataTruncationCodes, dataTruncationStates, deadlockCodes, deadlockSqlStates, foreignKeyChildExistsViolationCodes, foreignKeyChildExistsViolationMessageParts, foreignKeyChildExistsViolationSqlStates, foreignKeyViolationCodes, foreignKeyViolationMessageParts, foreignKeyViolationSqlStates, isEmptyStringNulled, isolationLevel, lobHandler, objectAlreadyExistsCodes, objectAlreadyExistsStates, objectDoesNotExistCodes, objectDoesNotExistStates, primaryKeyViolationCodes, primaryKeyViolationMessageParts, primaryKeyViolationSqlStates, requiresAutoCommitFalseToSetFetchSize, settings, supportsGetGeneratedKeys, uniqueKeyViolationNameRegex

Fields inherited from class org.jumpmind.db.sql.AbstractSqlTemplate

dateOverrideToTimestamp, identifierQuoteString, logSqlBuilder

Constructor Summary

Constructors

Constructor	Description
MySqlJdbcSqlTemplate(DataSource dataSource, SqlTemplateSettings settings, SymmetricLobHandler lobHandler, DatabaseInfo databaseInfo)

Method Summary

Modifier and Type	Method	Description
String	getSelectLastInsertIdSql(String sequenceName)
void	setValues(PreparedStatement ps, Object[] args, int[] argTypes, org.springframework.jdbc.support.lob.LobHandler lobHandler)

Methods inherited from class org.jumpmind.db.sql.JdbcSqlTemplate

allowsNullForIdentityColumn, close, close, close, close, close, close, doesObjectAlreadyExist, doesObjectNotExist, doSetValue, execute, findSQLException, getConnection, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDataSource, getDriverName, getDriverVersion, getIsolationLevel, getLobHandler, getObjectFromResultSet, getResultSetValue, getResultSetValue, getSettings, getSqlKeywords, getUniqueKeyViolationIndexName, getUpdateCount, insertWithGeneratedKey, insertWithGeneratedKey, isDataTruncationViolation, isDeadlock, isForeignKeyChildExistsViolation, isForeignKeyViolation, isRequiresAutoCommitFalseToSetFetchSize, isStoresLowerCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, isUniqueKeyViolation, lookupColumnName, queryForBlob, queryForBlob, queryForClob, queryForClob, queryForCursor, queryForCursor, queryForCursor, queryForCursor, queryForMap, queryForObject, setDecimalValue, setIsolationLevel, setNanOrNull, setSettings, setTinyIntValue, setValues, startSqlTransaction, startSqlTransaction, supportsGetGeneratedKeys, supportsReturningKeys, testConnection, update, update, update, update, verifyArgType

Methods inherited from class org.jumpmind.db.sql.AbstractSqlTemplate

expandArgs, expandSql, query, query, query, query, query, query, query, query, query, query, query, query, queryForCursor, queryForCursor, queryForInt, queryForInt, queryForLong, queryForMap, queryForMap, queryForObject, queryForRow, queryForString, queryWithHandler, translate, translate, update

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.jumpmind.db.sql.ISqlTemplate

query, query, query, query, query, query, query, query, query, query, queryForCursor, queryForCursor, queryForInt, queryForInt, queryForLong, queryForMap, queryForMap, queryForObject, queryForRow, queryForString, queryWithHandler, translate, update

Constructor Details

MySqlJdbcSqlTemplate

public MySqlJdbcSqlTemplate(DataSource dataSource,
 SqlTemplateSettings settings,
 SymmetricLobHandler lobHandler,
 DatabaseInfo databaseInfo)

Method Details

getSelectLastInsertIdSql

public String getSelectLastInsertIdSql(String sequenceName)

Overrides:

getSelectLastInsertIdSql in class JdbcSqlTemplate

setValues

public void setValues(PreparedStatement ps,
 Object[] args,
 int[] argTypes,
 org.springframework.jdbc.support.lob.LobHandler lobHandler)
               throws SQLException

Overrides:

setValues in class JdbcSqlTemplate

Throws:

SQLException