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