Package org.jumpmind.db.platform.sqlite

Class SqliteJdbcSqlTemplate

java.lang.Object

org.jumpmind.db.sql.AbstractSqlTemplate

org.jumpmind.db.sql.JdbcSqlTemplate

org.jumpmind.db.platform.sqlite.SqliteJdbcSqlTemplate

All Implemented Interfaces:

ISqlTemplate

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

Method Summary

Modifier and Type	Method	Description
<T> T	getObjectFromResultSet(ResultSet rs, Class<T> clazz)
String	getSelectLastInsertIdSql(String sequenceName)
boolean	isUniqueKeyViolation(Throwable ex)
void	setValues(PreparedStatement ps, Object[] args)
void	setValues(PreparedStatement ps, Object[] args, int[] argTypes, org.springframework.jdbc.support.lob.LobHandler lobHandler)
boolean	supportsGetGeneratedKeys()

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, getResultSetValue, getResultSetValue, getSettings, getSqlKeywords, getUniqueKeyViolationIndexName, getUpdateCount, insertWithGeneratedKey, insertWithGeneratedKey, isDataTruncationViolation, isDeadlock, isForeignKeyChildExistsViolation, isForeignKeyViolation, isRequiresAutoCommitFalseToSetFetchSize, isStoresLowerCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, lookupColumnName, queryForBlob, queryForBlob, queryForClob, queryForClob, queryForCursor, queryForCursor, queryForCursor, queryForCursor, queryForMap, queryForObject, setDecimalValue, setIsolationLevel, setNanOrNull, setSettings, setTinyIntValue, 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

SqliteJdbcSqlTemplate

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

Method Details

isUniqueKeyViolation

public boolean isUniqueKeyViolation(Throwable ex)

Specified by:

isUniqueKeyViolation in interface ISqlTemplate

Overrides:

isUniqueKeyViolation in class JdbcSqlTemplate

supportsGetGeneratedKeys

public boolean supportsGetGeneratedKeys()

Specified by:

supportsGetGeneratedKeys in interface ISqlTemplate

Overrides:

supportsGetGeneratedKeys in class JdbcSqlTemplate

getSelectLastInsertIdSql

public String getSelectLastInsertIdSql(String sequenceName)

Overrides:

getSelectLastInsertIdSql in class JdbcSqlTemplate

getObjectFromResultSet

public <T> T getObjectFromResultSet(ResultSet rs,
 Class<T> clazz)
                             throws SQLException

Overrides:

getObjectFromResultSet in class JdbcSqlTemplate

Throws:

SQLException

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

setValues

public void setValues(PreparedStatement ps,
 Object[] args)
               throws SQLException

Overrides:

setValues in class JdbcSqlTemplate

Throws:

SQLException