My Oracle Support Banner

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

Last updated on AUGUST 02, 2019

Applies to:

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

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

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.