org.opensubsystems.patterns.listdata.persist.db
Class OracleListDatabaseUtils

java.lang.Object
  org.opensubsystems.patterns.listdata.persist.db.ListDatabaseUtils
      org.opensubsystems.patterns.listdata.persist.db.OracleListDatabaseUtils

public class OracleListDatabaseUtils
extends ListDatabaseUtils

This class is used for common list retrieval and manipulation routines specific for Oracle 9i.

Version:

$Id: OracleListDatabaseUtils.java,v 1.14 2007/01/07 06:14:23 bastafidli Exp $

Author:

Julo Legeny

Code reviewer:

Miro Halas

Code reviewed:

1.11 2004/12/22 09:24:36 jlegeny

Field Summary

Fields inherited from class org.opensubsystems.patterns.listdata.persist.db.ListDatabaseUtils

LIST_INDEX_PREFIX

Constructor Summary

OracleListDatabaseUtils()
Constructor

Method Summary

protected java.lang.String

preprocessSelectQuery(java.lang.String inputQuery, ListOptions options, ListDatabaseSchema schema) Method that preprocess query (by adding specific SQL clauses for example LIMIT, ...) to improve performance of selecting items from the list at specific position.

Methods inherited from class org.opensubsystems.patterns.listdata.persist.db.ListDatabaseUtils

allocateObjectList, convertValueToSQL, getConstructListIndexName, getInstance, getObjectList, getObjectListKeepSelected, getSelectCount, getSelectList, getSQLOperation, getSQLValue, getTotalRecords, getWhereClause, getWhereClause, parseCondition, preprocessSelectQueryForCreationDate, setOptionPositioning

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleListDatabaseUtils

public OracleListDatabaseUtils()

Constructor

Method Detail

preprocessSelectQuery

protected java.lang.String preprocessSelectQuery(java.lang.String inputQuery,
                                                 ListOptions options,
                                                 ListDatabaseSchema schema)
                                          throws org.opensubsystems.core.error.OSSException

Method that preprocess query (by adding specific SQL clauses for example LIMIT, ...) to improve performance of selecting items from the list at specific position. This method can be overwritten by DB specific method.

Overrides:

preprocessSelectQuery in class ListDatabaseUtils

Parameters:

inputQuery - - query that will be preprocessed

options - - initialized list options that will be used for retrieving begin position, page size, ...

schema - - list database schema

Returns:

String - preprocessed query

Throws:

org.opensubsystems.core.error.OSSException - - error during preprocessing select query