Reading Multiple records in Single row keyword by using JDBC Sender adapter

[Former Member]

Hi,

Sender JDBC adapter reads the data in following format if we have multiple recods returned by Stored procedure or Query. e.g

<resultset>

<row>

<column-name1>column-value</column-name1>

<column-name2>column-value</column-name2>

<column-name3>column-value</column-name3>

</row>

<row>

<column-name1>column-value</column-name1>

<column-name2>column-value</column-name2>

<column-name3>column-value</column-name3>

</row>

</resultset>

I want the format to be like below when JDBC sender read the data

<resultset>

<row>

<column-name1>column-value1</column-name1>

<column-name2>column-value1</column-name2>

<column-name3>column-value1</column-name3>

<column-name1>column-value2</column-name1>

<column-name2>column-value2</column-name2>

<column-name3>column-value2</column-name3>

</row>

</resultset>

Is it possible to achieve it in a Stored Procedure. There can be more than 200 records in a Single call.

Kulwinder

[Former Member · Accepted solution]

Hi,

Not possible.

the XML will not alow you to add the same feild name inside a single tag.

<resultset>

<row>

<column-name1>column-value1</column-name1>
<column-name2>column-value1</column-name2>
<column-name3>column-value1</column-name3>

<column-name1>column-value2</column-name1>
<column-name2>column-value2</column-name2>
<column-name3>column-value2</column-name3>

</row>

</resultset>