My Oracle Support Banner

How to Handle Database Change Notification Requests In the Listener (Doc ID 1062016.1)

Last updated on AUGUST 09, 2023

Applies to:

JDBC - Version 11.1.0.7 and later
Information in this document applies to any platform.

Goal

With the introduction of the 11g JDBC driver, it now has a new feature which supports changes made at the database level to be sent to the JDBC client program. The Oracle JDBC driver provides support for the Database Change Notification feature of an Oracle Database. This article shows how to process the change requests coming from the database in the listener which is setup on the client.

Please see the documentation below which describes this feature in more detail.

JDBC Developer's Guide Release 19  
26 Continuous Query Notification
https://docs.oracle.com/en/database/oracle/oracle-database/19/jjdbc/continuos-query-notification.html#GUID-4987516F-872F-47D1-B9E7-270A28D50AF8

JDBC Developer's Guide and Reference Release 21
28 Continuous Query Notification
https://docs.oracle.com/en/database/oracle/oracle-database/21/jjdbc/continuos-query-notification.html#GUID-4987516F-872F-47D1-B9E7-270A28D50AF8

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.