com.ontimize.db.handler

Class SQLServerSQLStatementHandler

java.lang.Object

com.ontimize.db.handler.DefaultSQLStatementHandler

com.ontimize.db.handler.SQLServerSQLStatementHandler

All Implemented Interfaces:

SQLStatementHandler

public class SQLServerSQLStatementHandler
extends DefaultSQLStatementHandler

Field Summary

Fields

Modifier and Type	Field and Description
static String	GENERATED_KEY_COLUMN_NAME
static String	TOP_100_PERCENT

Fields inherited from class com.ontimize.db.handler.DefaultSQLStatementHandler

CONFLICT_CHARS, queryConditionsProcessor, sqlNameEval, useAsInSubqueries

Constructor Summary

Constructors

Constructor and Description
SQLServerSQLStatementHandler()

Method Summary

Methods

Modifier and Type	Method and Description
protected void	changeGenerateKeyNames(EntityResult result, List columnNames)
SQLStatementBuilder.SQLStatement	createCountQuery(String table, Hashtable conditions, Vector wildcards, Vector countColumns) Returns a SQLStatement class that stores the information needed to execute a query that obtains the number of query records
protected SQLStatementBuilder.SQLStatement	createLeftJoinSelectQueryPageable(String mainTable, String subquery, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending, int recordCount)
protected String	createSelectClause(boolean forceDistinct)
SQLStatementBuilder.SQLStatement	createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending, boolean forceDistinct) Returns a SQLStatement class that stores the information needed to execute a select query.
protected String	createSelectQuery(String table, Vector askedColumns, int recordsNumber, boolean forceDistinct)
boolean	isDelimited()
boolean	isPageable()

Methods inherited from class com.ontimize.db.handler.DefaultSQLStatementHandler

addInnerMultilanguageColumns, addMultilanguageLeftJoinTables, addOuterMultilanguageColumns, addOuterMultilanguageColumnsPageable, addSpecialCharacters, changeColumnName, changeColumnNames, checkColumnName, createCountQuery, createCountQuery, createDeleteQuery, createInsertQuery, createJoinFromSubselectsQuery, createJoinSelectQuery, createJoinSelectQuery, createLeftJoinSelectQuery, createLeftJoinSelectQueryPageable, createQueryConditions, createQueryConditions, createQueryConditionsWithoutWhere, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSortStatement, createSortStatement, createUpdateQuery, generatedKeysToEntityResult, getColumnNames, getQueryConditionsProcessor, getResultSetValue, getSQLNameEval, hasIsolationFunction, isUseAsInSubqueries, qualify, readBinaryStream, readCharacterStream, readCharacterStream, resultSetToEntityResult, resultSetToEntityResult, setObject, setSQLConditionValuesProcessor, setSQLNameEval, setTimestampObject, setUseAsInSubqueries

Methods inherited from class java.lang.Object

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

Field Detail

GENERATED_KEY_COLUMN_NAME

public static final String GENERATED_KEY_COLUMN_NAME

See Also:

Constant Field Values

TOP_100_PERCENT

public static final String TOP_100_PERCENT

See Also:

Constant Field Values

Constructor Detail

SQLServerSQLStatementHandler

public SQLServerSQLStatementHandler()

Method Detail

isPageable

public boolean isPageable()

Specified by:

isPageable in interface SQLStatementHandler

Overrides:

isPageable in class DefaultSQLStatementHandler

isDelimited

public boolean isDelimited()

Specified by:

isDelimited in interface SQLStatementHandler

Overrides:

isDelimited in class DefaultSQLStatementHandler

createSelectClause

protected String createSelectClause(boolean forceDistinct)

Overrides:

createSelectClause in class DefaultSQLStatementHandler

createSelectQuery

public SQLStatementBuilder.SQLStatement createSelectQuery(String table,
                                                 Vector requestedColumns,
                                                 Hashtable conditions,
                                                 Vector wildcards,
                                                 Vector columnSorting,
                                                 int recordCount,
                                                 boolean descending,
                                                 boolean forceDistinct)

Description copied from class: DefaultSQLStatementHandler

Returns a SQLStatement class that stores the information needed to execute a select query.

Specified by:

createSelectQuery in interface SQLStatementHandler

Overrides:

createSelectQuery in class DefaultSQLStatementHandler

Parameters:

table - name of the table the query is executed against

requestedColumns - a Vector specifying the requested column name in the query

conditions - condition list used to created the query

wildcards - column list that can use wildcards

columnSorting - column list where query sorting is established

recordCount - number of records requested in the query

descending - true if sorting should be descending

forceDistinct - true if query result cannot have duplicated records

Returns:

a SQLStatement class

See Also:

SQLStatementBuilder.SQLStatement

createSelectQuery

protected String createSelectQuery(String table,
                       Vector askedColumns,
                       int recordsNumber,
                       boolean forceDistinct)

createLeftJoinSelectQueryPageable

protected SQLStatementBuilder.SQLStatement createLeftJoinSelectQueryPageable(String mainTable,
                                                                 String subquery,
                                                                 String secondaryTable,
                                                                 Vector mainKeys,
                                                                 Vector secondaryKeys,
                                                                 Vector mainTableRequestedColumns,
                                                                 Vector secondaryTableRequestedColumns,
                                                                 Hashtable mainTableConditions,
                                                                 Hashtable secondaryTableConditions,
                                                                 Vector wildcards,
                                                                 Vector columnSorting,
                                                                 boolean forceDistinct,
                                                                 boolean descending,
                                                                 int recordCount)

Overrides:

createLeftJoinSelectQueryPageable in class DefaultSQLStatementHandler

createCountQuery

public SQLStatementBuilder.SQLStatement createCountQuery(String table,
                                                Hashtable conditions,
                                                Vector wildcards,
                                                Vector countColumns)

Description copied from class: DefaultSQLStatementHandler

Returns a SQLStatement class that stores the information needed to execute a query that obtains the number of query records

Specified by:

createCountQuery in interface SQLStatementHandler

Overrides:

createCountQuery in class DefaultSQLStatementHandler

Parameters:

table - name of the table the query is executed against

conditions - condition list used in the query

wildcards - column list that can use wildcards

Returns:

a SQLStatement class

changeGenerateKeyNames

protected void changeGenerateKeyNames(EntityResult result,
                          List columnNames)

Overrides:

changeGenerateKeyNames in class DefaultSQLStatementHandler