Limitations

Understand the limitations and solutions when implementing Online cache group policy.

  • Relationships between MBOs are not supported, unless they are between MBOs generated from the same load operation (also referred to as multiple MBOs from a single load operation or a shared-read operation).
  • The findAll and findByPrimaryKey object queries and any other user-defined object queries are removed, and all buttons are disabled.
  • An MBO using the Online cache policy must have at least one load argument-to-Propagate to attribute mapping.
  • The generated findByParameter object query is read only and can be modified only by specifying propagate to attribute settings. The propagated attributes are ANDed together in the findByParameter object query.
  • The requirement of propagating the value of the load argument to an attribute can be bypassed, and is illustrated with this example:
    1. SELECT id, empName, empDeptId FROM sampledb.dba.emp (no load argument)
    2. Modify the load definition to be:
      SELECT   id,  empName,  empDeptId FROM sampledb.dba.emp 
      WHERE :fakeLP != null
      
    3. Create a new int attribute (fakeAttrib) on the MBO and propagate fakeLP to the newly added attribute (fakeAttrib) on the Load Arguments tab.

      The object query now takes an argument even though it is not used. In effect, the load operation is used to select the data and the generated object query returns all the rows returned from the load operation.