Package org.jumpmind.db.platform.db2

Class Db2JdbcSqlTemplate

java.lang.Object

org.jumpmind.db.sql.AbstractSqlTemplate

org.jumpmind.db.sql.JdbcSqlTemplate

org.jumpmind.db.platform.db2.Db2JdbcSqlTemplate

All Implemented Interfaces:

ISqlTemplate

public class Db2JdbcSqlTemplate
extends JdbcSqlTemplate

Field Summary

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

dataSource, dataTruncationCodes, dataTruncationStates, deadlockCodes, deadlockSqlStates, foreignKeyChildExistsViolationCodes, foreignKeyChildExistsViolationMessageParts, foreignKeyChildExistsViolationSqlStates, foreignKeyViolationCodes, foreignKeyViolationMessageParts, foreignKeyViolationSqlStates, 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
Db2JdbcSqlTemplate(DataSource dataSource, SqlTemplateSettings settings, SymmetricLobHandler lobHandler, DatabaseInfo databaseInfo)

Method Summary

Modifier and Type	Method	Description
protected boolean	allowsNullForIdentityColumn()
String	getSelectLastInsertIdSql(String sequenceName)
String	getUniqueKeyViolationIndexName(Throwable ex)
boolean	supportsGetGeneratedKeys()

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, getSettings, getSqlKeywords, 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, setValues, startSqlTransaction, startSqlTransaction, 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

Db2JdbcSqlTemplate

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

Method Details

getSelectLastInsertIdSql

public String getSelectLastInsertIdSql(String sequenceName)

Overrides:

getSelectLastInsertIdSql in class JdbcSqlTemplate

supportsGetGeneratedKeys

public boolean supportsGetGeneratedKeys()

Specified by:

supportsGetGeneratedKeys in interface ISqlTemplate

Overrides:

supportsGetGeneratedKeys in class JdbcSqlTemplate

allowsNullForIdentityColumn

protected boolean allowsNullForIdentityColumn()

Overrides:

allowsNullForIdentityColumn in class JdbcSqlTemplate

getUniqueKeyViolationIndexName

public String getUniqueKeyViolationIndexName(Throwable ex)

Specified by:

getUniqueKeyViolationIndexName in interface ISqlTemplate

Overrides:

getUniqueKeyViolationIndexName in class JdbcSqlTemplate