By Juergenkress-Oracle on Dec 21, 2015
The DB Adapter has some nice features, but sometimes you can get fooled. One of my colleagues experiences this one day. The query returned the same row - just repeated many times.
The reason for this is because the primary key was not defined correctly.
The good thing is that the documentation describes this - and more: Oracle documentation
For tables where primary key is defined - this should not be a problem, but in cases where it is not defined or you are querying a view - you would need to specify a primary key yourself. A couple of relevant notes here:
- If you do not provide a valid primary key, then the unique constraint is not guaranteed, and this could result in possible loss of messages at runtime. That is, rows with duplicate primary key values are likely to be lost.
- You should ensure that you primary key is less than 100 bytes.
- Oracle recommends that you use varchar instead of char for primary key columns
For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.