My Oracle Support Banner

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

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