JDBC lookup returing only single row

[former_member209575]

Hi All,

I am doing a jdbc lookup using graphical function in message mapping. I am able to connect the database and retrive result, but only one row.

I am expecting mulitple rows as ouput in lookup. if i am excuting the same query directly in database i am getting multiple rows as output.

I am coonecting to a sql 2005 database .

Please advice how to get multiple rows in output.

is ther any additional configuration , i have to do for getting multiple rows

Regards

Pradeep P N

[RKothari · Accepted solution]

Hello,

Have you tried checking the option Insert context change after each result value.

Refer blog:

/people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-graphical-support-for-jdbc-and-rfc-lookups

[former_member209575 · Accepted solution]

Hi

I have checked it, but only one row is coming as output,

Also in RFc lookup I am getting multiple rows

[Former Member · Accepted solution]

Hi,

You need to use some global variables and store your output..if want to use multiple rows data..

as the return is type string you can return only row from the UDF...

I have used global varaibles to store the data and retrieved from the same where ever needed..

HTH

Rajesh

[former_member209575 · Accepted solution]

Hi Rajesh,

I am using graphical JDBC lookup in PI 7.1., not using anu UDF's

Regards

Pradeep P N

[baskar_gopalakrishnan2 · Accepted solution]

I think you need to do UDF to extract multiple rows of data. Jdbc graphical lookup will return just one row of table.

[Former Member · Accepted solution]

Usually, i develope the jdbc lookup, by using an UDF.... Try it!

[aashish_sinha · Accepted solution]

Hi,

first look out if in source Structure Elements are of 0-Unbounded and same for target.

Next is to check whether you are mapping correct node of element.

Thanks

Aashish Sinha