Package org.jumpmind.db.platform.mssql

Class MsSqlJdbcSqlTemplate

java.lang.Object

org.jumpmind.db.sql.AbstractSqlTemplate

org.jumpmind.db.sql.JdbcSqlTemplate

org.jumpmind.db.platform.mssql.MsSqlJdbcSqlTemplate

All Implemented Interfaces:

ISqlTemplate

public class MsSqlJdbcSqlTemplate
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
MsSqlJdbcSqlTemplate(DataSource dataSource, SqlTemplateSettings settings, DatabaseInfo databaseInfo)

Method Summary

Modifier and Type	Method	Description
protected boolean	allowsNullForIdentityColumn()
protected void	setTinyIntValue(PreparedStatement ps, int i, Object arg, int argType)
ISqlTransaction	startSqlTransaction()
ISqlTransaction	startSqlTransaction(boolean autoCommit)

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

close, close, close, close, close, close, doesObjectAlreadyExist, doesObjectNotExist, doSetValue, execute, findSQLException, getConnection, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDataSource, getDriverName, getDriverVersion, getIsolationLevel, getLobHandler, getObjectFromResultSet, getResultSetValue, getResultSetValue, getSelectLastInsertIdSql, 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, setValues, setValues, 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

MsSqlJdbcSqlTemplate

public MsSqlJdbcSqlTemplate(DataSource dataSource,
 SqlTemplateSettings settings,
 DatabaseInfo databaseInfo)

Method Details

startSqlTransaction

public ISqlTransaction startSqlTransaction()

Specified by:

startSqlTransaction in interface ISqlTemplate

Overrides:

startSqlTransaction in class JdbcSqlTemplate

startSqlTransaction

public ISqlTransaction startSqlTransaction(boolean autoCommit)

Specified by:

startSqlTransaction in interface ISqlTemplate

Overrides:

startSqlTransaction in class JdbcSqlTemplate

allowsNullForIdentityColumn

protected boolean allowsNullForIdentityColumn()

Overrides:

allowsNullForIdentityColumn in class JdbcSqlTemplate

setTinyIntValue

protected void setTinyIntValue(PreparedStatement ps,
 int i,
 Object arg,
 int argType)
                        throws SQLException

Overrides:

setTinyIntValue in class JdbcSqlTemplate

Throws:

SQLException