DB Adapter output XML repeats records in the child collection
(Doc ID 2000033.1)
Last updated on MARCH 27, 2020
Applies to:Oracle SOA Suite - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Using the DB Adapter to query a parent and child table. The child table can have n records for each parent and the output XML is expected to contain the collection of parent records, each having the associated collection of child records embedded.
Issue is that the output XML is repeating the first child record n times for each parent record instead of showing each record. So if there are 10 child records for a given parent, the output XML contains the first child record repeated 10 times.
DB Adapter configured with the parent and child tables imported, the parent selected as the root an the 1:M relationship. Default generated XML is used and the results of the adapter invoke are viewed through the EM instance audit trail.
Example Expected Output:
JDBC debug output in WebLogic shows that the correct records are returned from the DB so the issue appears to be in the XML mapping.
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