com.ontimize.db.handler

Class MySQLSQLStatementHandler

java.lang.Object

com.ontimize.db.handler.DefaultSQLStatementHandler

com.ontimize.db.handler.MySQLSQLStatementHandler

All Implemented Interfaces:

SQLStatementHandler

public class MySQLSQLStatementHandler
extends DefaultSQLStatementHandler

Field Summary

Fields

Modifier and Type	Field and Description
static String	LIMIT
static String	OFFSET

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

CONFLICT_CHARS, queryConditionsProcessor, sqlNameEval, useAsInSubqueries

Constructor Summary

Constructors

Constructor and Description
MySQLSQLStatementHandler()

Method Summary

Methods

Modifier and Type	Method and Description
protected void	changeGenerateKeyNames(EntityResult result, List columnNames)
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 recordNumber, int startIndex) Returns a SQLStatement class that stores the information needed to execute a select query against two subselects used a join.
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.
SQLStatementBuilder.SQLStatement	createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset, boolean descending, boolean forceDistinct)
protected String[]	getColumnNames(ResultSetMetaData rsMetaData)
boolean	isPageable()

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

addInnerMultilanguageColumns, addMultilanguageLeftJoinTables, addOuterMultilanguageColumns, addOuterMultilanguageColumnsPageable, addSpecialCharacters, changeColumnName, changeColumnNames, checkColumnName, createCountQuery, createCountQuery, createCountQuery, createDeleteQuery, createInsertQuery, createJoinFromSubselectsQuery, createJoinSelectQuery, createJoinSelectQuery, createLeftJoinSelectQuery, createLeftJoinSelectQueryPageable, createQueryConditions, createQueryConditions, createQueryConditionsWithoutWhere, createSelectClause, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSelectQuery, createSortStatement, createSortStatement, createUpdateQuery, generatedKeysToEntityResult, getQueryConditionsProcessor, getResultSetValue, getSQLNameEval, hasIsolationFunction, isDelimited, 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

LIMIT

public static final String LIMIT

See Also:

Constant Field Values

OFFSET

public static final String OFFSET

See Also:

Constant Field Values

Constructor Detail

MySQLSQLStatementHandler

public MySQLSQLStatementHandler()

Method Detail

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

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

Specified by:

createSelectQuery in interface SQLStatementHandler

Overrides:

createSelectQuery in class DefaultSQLStatementHandler

isPageable

public boolean isPageable()

Specified by:

isPageable in interface SQLStatementHandler

Overrides:

isPageable in class DefaultSQLStatementHandler

getColumnNames

protected String[] getColumnNames(ResultSetMetaData rsMetaData)

Overrides:

getColumnNames in class DefaultSQLStatementHandler

Parameters:

rsMetaData - Database metadata. See custom implementation at MySQLSQLStatementHandler.

Returns:

Column names.

Since:

5.2071EN-0.1 In mysql 5.x.x rsMetaData.getColumnName(i) is not enough to return column names that have been modified with "as" e.g. select customerid as mycustomer from... In this case, the modifier "mycustomer" is only found by using method rsMetaData.getColumnLabel(i). This patch fixes two possibilities.

changeGenerateKeyNames

protected void changeGenerateKeyNames(EntityResult result,
                          List columnNames)

Overrides:

changeGenerateKeyNames in class DefaultSQLStatementHandler

createLeftJoinSelectQueryPageable

public 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 recordNumber,
                                                                 int startIndex)

Description copied from class: DefaultSQLStatementHandler

Returns a SQLStatement class that stores the information needed to execute a select query against two subselects used a join.

Specified by:

createLeftJoinSelectQueryPageable in interface SQLStatementHandler

Overrides:

createLeftJoinSelectQueryPageable in class DefaultSQLStatementHandler

secondaryTable - secondary query is executed against

secondaryKeys - a Vector specifying the column names of the secondary table that be used to combine the two tables

secondaryTableRequestedColumns - column list that be requested in the query from secondary table

secondaryTableConditions - a Hashtable specifying conditions that must comply the set of records returned from secondary table

wildcards - column list which wildcards can be used in

columnSorting - column list where query sorting is established

forceDistinct - true if query result cannot have duplicated records

descending - true if sorting should be descending

recordNumber - number of rows to return

startIndex - number of initial row

Returns:

a SQLStatement class which stores the SQL Statement and the required values