Querying tables using DBAdapter

Version: 11.1.1.4 (11g)

 

I have configured a DBAdapter which polls data from few tables in some frequency.  Those tables have data in header-lines-distribution format.  I created a data in these tables with 1 header - 2 lines. The 1st line have 2 distributions and the 3rd line have 1 distribution.  When data is queried by the DBAdapter I expect the xml in the below format

 

<header>

    <line1>

        <dist1>

        <dist2>

    <line2>

        <dist1>

 

But the actual output is not in order i.e it gives me output like this

 

<header>

    <line2>

        <dist1>

    <line1>

        <dist2>

   <dist1>

 

How DBAdapter controls the order of table lines?

 

Thanks

sen