This chapter describes TopLink's support for Oracle Database Continuous Query Notification (CQN), which allows you to use caching with a shared database in JPA.
Oracle Database Continuous Query Notification was also formerly known as Oracle Database Change Notification.
This chapter contains the following sections:
Users want to use a shared cache with their JPA application, however, external applications update the same database data, or the cache is in a clustered environment. The cache may retain stale data.
The Oracle database provides an API to allow applications to register for notification of database changes. EclipseLink supports registering with the Oracle database and processing database change events to invalidate changed objects in the shared cache
Oracle 11gR2 (11.2) (or higher) database
EclipseLink 2.4 or later.
EclipseLink library: eclipselink.jar
For sample files that illustrate the use of Continuous Query Notification and shared caching in an application that uses JPA, see "EclipseLink/Examples/JPA/DCN" in the EclipseLink documentation.