2 Replies Latest reply: Dec 4, 2012 7:45 AM by Arik RSS

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

    962769
      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