Is It Possible to Tell When Dedicated CQN Network Thread Has an Outage?
(Doc ID 2498932.1)
Last updated on JUNE 23, 2021
Applies to:JDBC - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
When using Continuous Query Notification (CQN, previously called Database Change Notification, or DCN), DML/DDL notifications are returned to the JDBC driver via a separate/dedicated network connection. The JDBC driver spawns a separate thread whose sole purpose is to listen for these notifications. This is done via the DatabaseChangeRegistration.addListener() method call.
How can you be alerted if that dedicated listener socket itself gets disconnected from the database? This is not referring to the overall JDBC connection, just the specific listener socket particular to CQN notifications.
Similarly, there do notappear to be custom keepalive or connection timeout settings available for this notification listener.
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