net.java.ao.db

Class MsJdbcSQLServerDatabaseProvider

java.lang.Object

net.java.ao.DatabaseProvider

net.java.ao.db.SQLServerDatabaseProvider

net.java.ao.db.MsJdbcSQLServerDatabaseProvider

All Implemented Interfaces:

Disposable

public class MsJdbcSQLServerDatabaseProvider
extends SQLServerDatabaseProvider

Nested Class Summary

Nested classes/interfaces inherited from class net.java.ao.DatabaseProvider

DatabaseProvider.RenderFieldOptions, DatabaseProvider.SqlListener

Field Summary

Fields inherited from class net.java.ao.DatabaseProvider

logger, quoteRef, sqlLogger, typeManager

Constructor Summary

Constructors

Constructor and Description
MsJdbcSQLServerDatabaseProvider(DisposableDataSource dataSource, String schema)

Method Summary

Methods

Modifier and Type	Method and Description
void	putNull(PreparedStatement stmt, int index) Stores an SQL NULL value in the database.

Methods inherited from class net.java.ao.db.SQLServerDatabaseProvider

getReservedWords, getTables, insertReturningKey, parseValue, renderAlterTableAddColumnStatement, renderAlterTableChangeColumn, renderAlterTableChangeColumnStatement, renderAlterTableDropKey, renderAutoIncrement, renderCreateIndex, renderDropIndex, renderFieldDefault, renderFieldOptionsInAlterColumn, renderMetadataQuery, renderPrimaryKey, renderQueryLimit, renderQuerySelect, renderUnique, setQueryResultSetProperties

Methods inherited from class net.java.ao.DatabaseProvider

_getFunctionNameForField, _getTriggerNameForField, _renderDropFunctionForField, _renderDropSequenceForField, _renderDropTriggerForField, _renderFunctionForField, _renderSequenceForField, _renderTriggerForField, addSqlListener, commitTransaction, convertTypeToString, dispose, executeInsertReturningKey, executeUpdate, executeUpdateForAction, executeUpdatesForActions, findForeignKeysForField, getConnection, getDateFormat, getExistingIndexName, getImportedKeys, getIndexes, getMaxIDLength, getSchema, getSequences, getTypeManager, handleBlob, handleUpdateError, hasIndex, hasIndex, isCaseSensitive, isNumericType, isSchemaNotEmpty, loadQuoteString, onSql, preparedStatement, preparedStatement, preparedStatement, processID, processOnClause, processOrderClause, processTableName, processWhereClause, putBoolean, querySelectFields, queryTableName, quote, quoteTableName, removeSqlListener, renderAccessories, renderAccessoriesForField, renderAction, renderAlterTableAddColumn, renderAlterTableAddKey, renderAlterTableDropColumn, renderAlterTableDropColumnStatement, renderAppend, renderConstraintsForTable, renderDate, renderDropAccessories, renderDropAccessoriesForField, renderDropColumnActions, renderDropTableStatement, renderField, renderFields, renderFieldType, renderForeignKey, renderInsert, renderQuery, renderQueryGroupBy, renderQueryHaving, renderQueryJoins, renderQueryOrderBy, renderQueryWhere, renderTable, renderValue, rollbackTransaction, setPostConnectionProperties, setQueryStatementProperties, shorten, shouldQuoteID, shouldQuoteTableName, startTransaction, withSchema

Methods inherited from class java.lang.Object

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

Constructor Detail

MsJdbcSQLServerDatabaseProvider

public MsJdbcSQLServerDatabaseProvider(DisposableDataSource dataSource,
                               String schema)

Method Detail

putNull

public void putNull(PreparedStatement stmt,
           int index)
             throws SQLException

Description copied from class: DatabaseProvider

Stores an SQL NULL value in the database. This method is required due to the fact that not all JDBC drivers handle NULLs in the same fashion. The default implementation calls PreparedStatement.setNull(int, int), retrieving parameter type from metadata. Databases which require a different implementation (e.g. PostgreSQL) should override this method.

Overrides:

putNull in class DatabaseProvider

Parameters:

stmt - The statement in which to store the NULL value.

index - The index of the parameter which should be assigned NULL.

Throws:

SQLException