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

(Doc ID 1553808.1)

Last updated on MAY 17, 2013

Applies to:

JDBC - Version 11.2.0.1 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.abc.DcnListener.onDatabaseChangeNotification:? - RegId: 36
2013-04-14 16:10:18.103 [INFO] Thread-3 com.abc.DcnListener.onDatabaseChangeNotification:? - DatabaseName: SIDE
2013-04-14 16:10:18.104 [INFO] Thread-3 com.abc.DcnListener.onDatabaseChangeNotification:? - TableName: ???
2013-04-14 16:10:18.104 [INFO] Thread-3 com.abc.DcnListener.onDatabaseChangeNotification:? - ObjectNumber: 103178
2013-04-14 16:10:18.104 [INFO] Thread-3 com.abc.DcnListener.onDatabaseChangeNotification:? - RowId: AAAmNpADpAAAbYpAAC
2013-04-14 16:10:18.105 [INFO] Thread-3 com.abc.DcnListener.onDatabaseChangeNotification:? - RowOperation: INSERT

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

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms