Data Change Notification Event in JDBC Reports Wrong ROWID
(Doc ID 1500154.1)
Last updated on MARCH 08, 2017
Applies to:JDBC - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Application using Data Change Notification sometimes receives the wrong ROWID within updates. This happens only for a few rows within a table and not all the rows.
1. The following row is updated using sqlplus:
On the application side, the event received is the following:
2012.10.16 11:00:03:054 EDT | FieldDebug | CommonPersistency
OracleDCNListener event received: Connection information : local=lin16-hs22/xxx.xxx.xxx.xx:47633, remote=<machine>./xxx.xxx.xxx.xx:43672
Registration ID : 41227
Notification version : 1
Event type : QUERYCHANGE
Database name : <DatabaseName>
Query Change Description (length=1)
query ID=6571, query change event type=QUERYCHANGE
Table Change Description (length=1): operation=[UPDATE], tableName=<owner>.<table>, objectNumber=74859
Row Change Description (length=1):
ROW: operation=UPDATE, ROWID=AAASRrAABAANa0OAAA
The wrong ROWID is reported and does not exist at all in the table:
no rows selected
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|