OracleSqlManager Class

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

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.

Hierarchy
Object
  JdbcSqlManager
    OracleSqlManager
All Implemented Interfaces

CatalogSqlManager

Constructor Summary
OracleSqlManager()
 

Method Summary
public ProductItemKey[]
getItemKeys(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 from  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 from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
   
Methods from interface com.beasys.commerce.ebusiness.catalog.sql.CatalogSqlManager
addItem, createCategory, createItem, getAncestors, getCatalogSchemaManager, getCategories, getCategory, getCategoryCount, getCategoryKeys, getItem, getItemCount, getItemCount, getItemKeys, getItemKeys, getItems, getJdbcCatalogFactory, getKeywords, getOrphanedItemCount, getOrphanedItemKeys, getParent, getRootCategory, getSiblingCount, getSiblingKeys, getSubCategoryCount, getSubCategoryKeys, initialize, moveCategory, removeCategory, removeItem, removeItem, setKeywords, updateCategory, updateItem
 

Constructor Detail

OracleSqlManager

public OracleSqlManager()
 

Method Detail

getItemKeys(Connection, CatalogRequest, CategoryKey, int, int) Method

public ProductItemKey[] getItemKeys(Connection connection, 
                                  CatalogRequest request, 
                                  CategoryKey categoryKey, 
                                  int beginIndex, 
                                  int endIndex)
     throws CatalogException, SQLException
Returns an array of all product item keys of the specified category within the specified ordered range.

Overrides
JdbcSqlManager.getItemKeys(Connection, CatalogRequest, CategoryKey, int, int)

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.

Exceptions

CatalogException
on general error.
SQLException