© 2002 BEA Systems, Inc.


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

© 2002 BEA Systems, Inc.

Copyright © 2002 BEA Systems, Inc. All Rights Reserved