My Oracle Support Banner

Data Change Notification Event in JDBC Reports Wrong ROWID (Doc ID 1500154.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

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.

For example:

1. The following row is updated using sqlplus:

SQL> update <owner>.<table> set <column>=191 WHERE rowid = 'AAASRrAAAAAAA3fAAA';

 

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:

SQL> select <column> ,rowid from <owner>.<table> where rowid = 'AAASRrAABAANa0OAAA';

no rows selected

 

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
Cause
Solution
References


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.