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:
- SELECT id, empName, empDeptId FROM sampledb.dba.emp
(no load argument)
- Modify the load definition to be:
SELECT id, empName, empDeptId FROM sampledb.dba.emp
WHERE :fakeLP != null
- 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.