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 laterInformation 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
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 |