Package org.jumpmind.db.platform.sybase

Class SybaseJdbcSqlTemplate

java.lang.Object

org.jumpmind.db.sql.AbstractSqlTemplate

org.jumpmind.db.sql.JdbcSqlTemplate

org.jumpmind.db.platform.sybase.SybaseJdbcSqlTemplate

All Implemented Interfaces:

ISqlTemplate

Direct Known Subclasses:

AseJdbcSqlTemplate, SqlAnywhereJdbcSqlTemplate

public class SybaseJdbcSqlTemplate
extends JdbcSqlTemplate
implements ISqlTemplate

Field Summary

Fields

Modifier and Type	Field	Description
protected boolean	isUsingJtds
protected int	jdbcMajorVersion
protected static final String	NATIVE_PREPARED_STATEMENT_NAME

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

Method Summary

Modifier and Type	Method	Description
protected boolean	allowsNullForIdentityColumn()
protected String	getSelectLastInsertIdSql(String sequenceName)
protected int	getUpdateCount(Statement stmt)
protected void	setDecimalValue(PreparedStatement ps, int i, Object arg, int argType)
void	setValues(PreparedStatement ps, Object[] args)
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, getUniqueKeyViolationIndexName, insertWithGeneratedKey, insertWithGeneratedKey, isDataTruncationViolation, isDeadlock, isForeignKeyChildExistsViolation, isForeignKeyViolation, isRequiresAutoCommitFalseToSetFetchSize, isStoresLowerCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, isUniqueKeyViolation, lookupColumnName, queryForBlob, queryForBlob, queryForClob, queryForClob, queryForCursor, queryForCursor, queryForCursor, queryForCursor, queryForMap, queryForObject, setIsolationLevel, setNanOrNull, setSettings, setTinyIntValue, 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

doesObjectAlreadyExist, doesObjectNotExist, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDriverName, getDriverVersion, getSqlKeywords, getUniqueKeyViolationIndexName, insertWithGeneratedKey, isDataTruncationViolation, isDeadlock, isForeignKeyChildExistsViolation, isForeignKeyViolation, isStoresLowerCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, isUniqueKeyViolation, query, query, query, query, query, query, query, query, query, query, queryForBlob, queryForClob, queryForCursor, queryForCursor, queryForCursor, queryForCursor, queryForCursor, queryForInt, queryForInt, queryForLong, queryForMap, queryForMap, queryForMap, queryForObject, queryForObject, queryForRow, queryForString, queryWithHandler, startSqlTransaction, startSqlTransaction, testConnection, translate, update, update, update, update, update

Field Details

NATIVE_PREPARED_STATEMENT_NAME

protected static final String NATIVE_PREPARED_STATEMENT_NAME

See Also:

• Constant Field Values

jdbcMajorVersion

protected int jdbcMajorVersion

isUsingJtds

protected boolean isUsingJtds

Constructor Details

SybaseJdbcSqlTemplate

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

Method Details

allowsNullForIdentityColumn

protected boolean allowsNullForIdentityColumn()

Overrides:

allowsNullForIdentityColumn in class JdbcSqlTemplate

setDecimalValue

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

Overrides:

setDecimalValue in class JdbcSqlTemplate

Throws:

SQLException

getUpdateCount

protected int getUpdateCount(Statement stmt)
                      throws SQLException

Overrides:

getUpdateCount in class JdbcSqlTemplate

Throws:

SQLException

setValues

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

Overrides:

setValues in class JdbcSqlTemplate

Throws:

SQLException

supportsGetGeneratedKeys

public boolean supportsGetGeneratedKeys()

Specified by:

supportsGetGeneratedKeys in interface ISqlTemplate

Overrides:

supportsGetGeneratedKeys in class JdbcSqlTemplate

getSelectLastInsertIdSql

protected String getSelectLastInsertIdSql(String sequenceName)

Overrides:

getSelectLastInsertIdSql in class JdbcSqlTemplate