If your product catalog is stored in an Oracle database, you must configure the catalog to properly handle full text searching. There are two main steps involved in this configuration:
Set up the proper ConText full text indexes on the appropriate columns in the database.
Make sure the
simulateTextSearchQueries
property of each product catalog repository component is set tofalse
.
These steps are described in more detail in the sections that follow.
Setting Up the ConText Indexes
The SQL Repository has built-in support for Oracle’s ConText full text search engine, which processes queries and returns information based on the content or themes of text stored in a text column of an Oracle database. To enable full text searching on columns, you must create ConText indexes for the columns. See your Oracle documentation for information about how to do this.
Note: By default, an Oracle database rebuilds a full-text index after each commit. This behavior can cause a full deployment to hang indefinitely. To prevent this, you should configure ConText indexing to occur at regular intervals, using the following format:
CREATE INDEXschema-index-name
ONschema-table
(column
) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('SYNC (EVERY "interval-string
" ');
If you are using the default product catalog, index these tables:
DCS_PRODUCT
DCS_CATEGORY
If you have imported the Pioneer Cycling product catalog into Oracle, index these tables:
DCS_PRODUCT
DCS_CATEGORY
DFR_PRODUCT
DFR_CATEGORY
DJP_PRODUCT
DJP_CATEGORY
If you have imported the Motorprise product catalog into Oracle, index these tables:
DCS_PRODUCT
DCS_CATEGORY
DBC_CATEGORY_DE
DBC_PRODUCT_DE
In each of these tables, create a ConText index on the DESCRIPTION, LONG_DESCRIPTION, and DISPLAY_NAME columns.
Configuring the Repository Components for Full Text Searching
To enable a SQL Repository to use full text searching in an Oracle database, the simulateTextSearchQueries
property of the SQL Repository component must be set to false
. Make sure this property is set to false
for any SQL Repository component that connects to an Oracle database.
If you are using the default product catalog, the SQL Repository component for the catalog has the Nucleus address /atg/commerce/catalog/ProductCatalog
.
If you have exported the Pioneer Cycling catalog into Oracle, there are three SQL Repository components for the catalog:
/atg/commerce/catalog/ProductCatalog
/atg/commerce/catalog/FrenchProductCatalog
/atg/commerce/catalog/JapaneseProductCatalog