com.beasys.commerce.ebusiness.catalog.sql
Class OracleSqlManager

java.lang.Object
  |
  +--com.beasys.commerce.ebusiness.catalog.sql.JdbcSqlManager
        |
        +--com.beasys.commerce.ebusiness.catalog.sql.OracleSqlManager

public class OracleSqlManager

extends JdbcSqlManager

The OracleSqlManager class implements the CatalogSqlManager interface using Oracle compliant SQL.
This is an advanced (internal) class and may be subject to change.

Constructor Summary

OracleSqlManager()

Method Summary

ProductItemKey[]

getItemKeys(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey, int beginIndex, int endIndex) Returns an array of all product item keys of the specified category within the specified ordered range.

Methods inherited from class com.beasys.commerce.ebusiness.catalog.sql.JdbcSqlManager

addItem, createCategory, createItem, getAncestors, getCatalogSchemaManager, getCategories, getCategory, getCategoryCount, getCategoryKeys, getItem, getItemCategories, getItemCategories, getItemCount, getItemCount, getItemKeys, getItems, getJdbcCatalogFactory, getKeywords, getOrphanedItemCount, getOrphanedItemKeys, getParent, getRootCategory, getSiblingCount, getSiblingKeys, getSubCategoryCount, getSubCategoryKeys, initialize, moveCategory, removeCategory, removeItem, removeItem, setKeywords, updateCategory, updateItem

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleSqlManager

public OracleSqlManager()

Method Detail

getItemKeys

public ProductItemKey[] getItemKeys(java.sql.Connection connection,
                                    CatalogRequest request,
                                    CategoryKey categoryKey,
                                    int beginIndex,
                                    int endIndex)
                             throws CatalogException,
                                    java.sql.SQLException

Returns an array of all product item keys of the specified category within the specified ordered range.

Parameters:

connection - The database connection object.

request - The catalog request object.

categoryKey - The key of the target category.

beginIndex - The lower bound index for returned product item keys.

endIndex - The upper bound index for returned product item keys.

Returns:

An array of all the product item keys.

Throws:

CatalogException - on general error.

Overrides:

getItemKeys in class JdbcSqlManager