hi,

i have the following xml tree:



this structure doesn't change, so i've always two of the nodes "node" (i call them node a and node b). is possible now that i have the following flat database schema (everything in one table)?

- root_id
- name
- id_a
- xyz_a
- id_b
- xyz_b

i've tried this with two component elements, like



but, unfortunately then i get just the second node in my result tree (i'm just reading from the database).
is there any possibility to map this tree to one db table?



thanks.[/code]

nobody any idea? :-/

Im not sure i understand the question fully, but in any case, this seems a little awkward.


shouldnt the second one be
[code]
<component name="Node2" node="node">
<property name="id" node="id" column="id_b" type="string"/>
...
</component>
</code]

yes, of course should it be "Node2". copy and paste error. ;-)
but the important thing is the node attribute. if i have two different node names, everything works fine. if i have the same node name for both components, only one component is shown. i guess the first one is overwritten by the second one.

so, i've tried to do something now with a "set" and "composite-element". but up to now i havn't found something which helps me.