Is It Possible to Tell When Dedicated CQN Network Thread Has an Outage? (Doc ID 2498932.1)

Last updated on OCTOBER 17, 2022

Applies to:

Goal

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.
 

Solution

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