This discussion is archived
2 Replies Latest reply: Dec 4, 2012 5:45 AM by Arik RSS

How to create a DB Adapter with select query having inner query

962769 Newbie
Currently Being Moderated
Hi All,

I am trying to create a DB Adapter with select query. The query has some inner queries in it. It is just like this select a, b, c, (select d from e) d, (select e from e) e from tablename.

The problem here is with the xsd generated for this query. Xsd is not getting generated properly for all the fields it is just getting generated till c element and when it encounters

the inner query it is stopping the generation of xsd. So for the above query the xsd is something similar to the below

<xs:complexType name="rewOutput">
<xs:sequence>
<xs:element name="a" type="xs:string" nillable="true"/>
<xs:element name="b" type="xs:string" nillable="true"/>
<xs:element name="c" type="xs:string" nillable="true"/>
<xs:element name="select_d" type="xs:string" nillable="true"/>
</xs:sequence>
</xs:complexType>

as shown above the xsd is just getting generated till the first inner query. What should be done to get the full fledged xsd. Should it be manually built ?? Please help me on this.

Thanks In Advance.

Edited by: 959766 on Nov 30, 2012 1:20 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points