close

Filter

loading table of contents...

Connector for HCL Commerce Manual / Version 2101

Table Of Contents

3.13 Event-based Commerce Cache Invalidation

Note

Note

Event-based Commerce Cache Invalidation is only available if the HCL Commerce Extension is used

Content Cloud integrates with HCL Commerce without importing catalog data into the CMS. Since all catalog data is requested dynamically from the HCL Commerce system, Content Cloud comes with its own caching layer to provide fast access to HCL Commerce data. In order to promptly reflect any changes of HCL Commerce data, Content Cloud supports event based cache invalidation. Apply the following changes to enable event based cache invalidation:

  1. Add the CacheInvalidationHandler as described in Section 3.7, “Configuring REST Handlers”

  2. Add database triggers for cache invalidation of segments and marketing spots. In order to create corresponding entries in HCL Commerce CACHEIVL table (where Dynacache Invalidation events are stored), several database triggers are needed. These are database specific but HCL Commerce already provides correct working examples in the HCL Commerce workspace. You do not need all the sample triggers but only those for Segments and Marketing Spots.

    Copy the triggers for the INSERT, UPDATE and DELETE cases for the following tables:

    • EMSPOT

    • MBRGRP

    and add them to your database (for example, by using http://HOST/webapp/wcs/admin/servlet/db.jsp)

    The sample files are located in the following directories:

    • Oracle:

      WCDE-ZIP\schema\oracle\cm.wcs.cacheivl.trigger.sql

    • IBM DB2:

      WCDE-ZIP\schema\db2\cm.wcs.cacheivl.trigger.sql

    • Cloudscape/Derby:

      WCDE-ZIP\schema\clouscape\cm.wcs.cacheivl.trigger.sql

Note

Note

If enabled HCL workspaces in your environment setup, you need to create these triggers for each workspace. If you enabled 5 workspaces for example, you need to create these triggers 5 times. Examples are given in the mentioned example files.

Search Results

Table Of Contents
warning

Your Internet Explorer is no longer supported.

Please use Mozilla Firefox, Google Chrome, or Microsoft Edge.