com.beasys.commerce.ebusiness.catalog.service.query
Class JdbcCatalogQueryManagerImpl

java.lang.Object
  com.beasys.commerce.foundation.SessionImpl
      com.beasys.commerce.ebusiness.catalog.service.CatalogServiceImpl
          com.beasys.commerce.ebusiness.catalog.service.JdbcCatalogServiceImpl
              com.beasys.commerce.ebusiness.catalog.service.query.JdbcCatalogQueryManagerImpl

All Implemented Interfaces

CatalogQueryManagerBusiness

public class JdbcCatalogQueryManagerImpl
extends JdbcCatalogServiceImpl
implements CatalogQueryManagerBusiness

The implementation class for the JdbcCatalogQueryManager Session EJB.

This service implementation uses the QueryHelper class to generate SQL at runtime to perform ProductCatalog searches. This utility class searches against both explict and implicit (i.e. properties set through the ConfigurableEntity interface) properties of the Catalog items. The table prefix used for searching implicit property tables is specifed by the following EJB environment property:

• PropertyTableSetPrefix - specifies the table prefix for performing searches over implicit properties.
• supportsLikeEscapeClause - specified whether the LIKE ESCAPE clause is supported in the underlying database connection (if not specified, it will be determined via the JdbcHelper).

See Also

JdbcCatalogQueryManager, JdbcCatalogQueryManagerHome, JdbcHelper

Field Summary

protected Boolean	supportsLikeEscapeClause Whether the underlying database connection supports the LIKE ESCAPE clause.
protected String	tablePrefix The table name prefix for the ConfigurableEntity/EntityPropertyManager tables for custom data searching through expressions.

Fields inherited from class com.beasys.commerce.ebusiness.catalog.service.JdbcCatalogServiceImpl

DATA_SOURCE_NAME, SCHEMA_FILE_NAME, SQL_MANAGER_CLASS

Fields inherited from class com.beasys.commerce.ebusiness.catalog.service.CatalogServiceImpl

CATALOG_MANAGER_HOME, CATALOG_QUERY_DELEGATE, CATEGORY_DELEGATE, CUSTOM_DATA_DELEGATE, PRODUCT_ITEM_DELEGATE

Fields inherited from class com.beasys.commerce.foundation.SessionImpl

_ctx, _environmentNamingContext, _environmentPropertyCache, _isDirty

Constructor Summary

JdbcCatalogQueryManagerImpl()

Method Summary

void	ejbActivate() ejbActivate method.
void	ejbCreate() ejbCreate method.
void	ejbPassivate() ejbPassivate method.
void	ejbPostCreate() ejbPostCreate method.
void	ejbRemove() ejbRemove method.
ProductItemKey[]	search(CatalogRequest request, CatalogQuery query) Returns the results of the search peformed using the supplied catalog query object.
ViewIterator	search(CatalogRequest request, CatalogQuery query, int viewSize) Returns a ViewIterator over the results of the search peformed using the supplied catalog query object.
CategoryKey[]	searchCategories(CatalogRequest request, CatalogQuery query) Returns the results of the search peformed using the supplied catalog query object for categories.
void	setSessionContext(SessionContext ctx) setSessionContext method.

Methods inherited from class com.beasys.commerce.ebusiness.catalog.service.JdbcCatalogServiceImpl

getCatalogSchemaName, getCatalogSqlManager, getCatalogSqlManager, getCatalogSqlManagerName, getDatabaseConnection, getJdbcCatalogFactory

Methods inherited from class com.beasys.commerce.ebusiness.catalog.service.CatalogServiceImpl

getCatalogManager, getCatalogManagerJndiName, getConfigBean, setDelegateName, validateAuthorization

Methods inherited from class com.beasys.commerce.foundation.SessionImpl

clearRelationalBinding, clearRelationalBinding, clearRelationalBinding, clearRelationalBinding, doRelationalBinding, doRelationalBinding, doRelationalBindingOnElement, doRelationalBindingOnElement, doRelationalBindingOnSingleton, doRelationalBindingOnSingleton, doRelationalBindingWithMapKey, doRelationalBindingWithMapKey, enumerateRelationalBinding, enumerateRelationalBinding, getEnvironmentNamingContext, getEnvironmentProperty, getEnvironmentProperty, getEnvironmentPropertyCache, getPersistenceHelperPlugin, getSessionContext

Methods inherited from class java.lang.Object

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

Field Detail

tablePrefix

protected String tablePrefix

The table name prefix for the ConfigurableEntity/EntityPropertyManager tables for custom data searching through expressions.

This will be initialized from the PropertyTableSetPrefix environment property.

supportsLikeEscapeClause

protected Boolean supportsLikeEscapeClause

Whether the underlying database connection supports the LIKE ESCAPE clause.

This will be initialized form the supportsLikeEscapeClause environment property. It will be null to use JdbcHelper.supportsLikeEscapeClause(java.sql.Connection) method.

Constructor Detail

JdbcCatalogQueryManagerImpl

public JdbcCatalogQueryManagerImpl()

Method Detail

ejbCreate

public void ejbCreate()
               throws CreateException

Description copied from class: SessionImpl

ejbCreate method.

Overrides:

ejbCreate in class JdbcCatalogServiceImpl

Throws

CreateException

ejbPostCreate

public void ejbPostCreate()
                   throws CreateException

Description copied from class: SessionImpl

ejbPostCreate method.

Overrides:

ejbPostCreate in class JdbcCatalogServiceImpl

Throws

CreateException

ejbActivate

public void ejbActivate()
                 throws EJBException

Description copied from class: SessionImpl

ejbActivate method.

Overrides:

ejbActivate in class JdbcCatalogServiceImpl

Throws

EJBException

ejbPassivate

public void ejbPassivate()
                  throws EJBException

Description copied from class: SessionImpl

ejbPassivate method.

Overrides:

ejbPassivate in class JdbcCatalogServiceImpl

Throws

EJBException

ejbRemove

public void ejbRemove()
               throws EJBException

Description copied from class: SessionImpl

ejbRemove method.

Overrides:

ejbRemove in class JdbcCatalogServiceImpl

Throws

EJBException

setSessionContext

public void setSessionContext(SessionContext ctx)
                       throws EJBException

Description copied from class: SessionImpl

setSessionContext method.

Overrides:

setSessionContext in class JdbcCatalogServiceImpl

Throws

EJBException

search

public ProductItemKey[] search(CatalogRequest request,
                               CatalogQuery query)
                        throws CatalogException

Returns the results of the search peformed using the supplied catalog query object.

Specified by:

search in interface CatalogQueryManagerBusiness

Parameters

request - The catalog request object.

catalogQuery - The catalog query object.

Returns

An array of product item keys.

Throws

CatalogException - on general error.

searchCategories

public CategoryKey[] searchCategories(CatalogRequest request,
                                      CatalogQuery query)
                               throws RemoteException,
                                      CatalogException

Returns the results of the search peformed using the supplied catalog query object for categories.

Specified by:

searchCategories in interface CatalogQueryManagerBusiness

Parameters

request - The catalog request object.

catalogQuery - The catalog query object.

Returns

An array of category keys.

Throws

CatalogException - on general error.

RemoteException

search

public ViewIterator search(CatalogRequest request,
                           CatalogQuery query,
                           int viewSize)
                    throws CatalogException,
                           RemoteException

Returns a ViewIterator over the results of the search peformed using the supplied catalog query object.

Specified by:

search in interface CatalogQueryManagerBusiness

Parameters

request - The catalog request object.

catalogQuery - The catalog query object.

viewSize - The view size of the returned ViewIterator.

Returns

A ViewIterator over the product items returned by the search.

Throws

CatalogException - on general error.

RemoteException