My Oracle Support Banner

Database Change Notifications - JDBC Driver Returns Question Marks (???) Instead Of TableName (Doc ID 1553808.1)

Last updated on JULY 02, 2023

Applies to:

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

Symptoms

When using Database Change Notifications, notifications are not received and table registrations are not seen for notifications in the USER_CHANGE_NOTIFICATION table.
In spite of the user being successfully granted change notification, the firewall port is open between client server and the database server, and the client host IP and port number are included during initial registration, the issue is observed.

Logs show TableName as ??? :

2013-04-14 16:10:18.103 [INFO] Thread-3 com.<package>.DcnListener.onDatabaseChangeNotification:? - RegId: 36
2013-04-14 16:10:18.103 [INFO] Thread-3 com.<package>.DcnListener.onDatabaseChangeNotification:? - DatabaseName: <NAME>
2013-04-14 16:10:18.104 [INFO] Thread-3 com.<package>.DcnListener.onDatabaseChangeNotification:? - TableName: ???
2013-04-14 16:10:18.104 [INFO] Thread-3 com.<package>.DcnListener.onDatabaseChangeNotification:? - ObjectNumber: 103178
2013-04-14 16:10:18.104 [INFO] Thread-3 com.<package>.DcnListener.onDatabaseChangeNotification:? - RowId: AAAmNpADpAAAbYpAAC
2013-04-14 16:10:18.105 [INFO] Thread-3 com.<package>.DcnListener.onDatabaseChangeNotification:? - RowOperation: INSERT

Issue is seen with WE8ISO8859P15 database NLS_CHARACTERSET. The same code works fine with: AL32UTF8, WE8ISO8859P1, WE8MSWIN1252 character sets.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
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.