JDBC stored procedure returning single resultset

[Former Member]

Hi Guys,

we are working on multiple resultset example. Normally in DB editor i am getting multiple records;

EXECUTE [dbo].[sp_student] @i_status = N'1'

GO

/* Result :

"

1 row(s) returned

1 row(s) returned

1 row(s) returned

1 row(s) returned

(219 ms)" */

but in PI we got only the first row. (JDBC response DT structure occurence is 1...unbounded.)

My reference was this blog;

Thank you in advance

PM

[iaki_vila · Accepted solution]

Hi Peter,

I've never tried to call a SP with multiple resultset, i think it is pretty interesting. Could see in the sxi_monitor the payload in the response of the DB?, if there is only one response the problem could be in the request but if you can notice two results the problem will be in your response schema.

Hope this helps.

Regards.

[Former Member · Accepted solution]

Hi Inaki,

i have been checked sxmb_moni. The response message from DB contain only one resultset.

[former_member184720 · Accepted solution]

I've never tried but just looking at the blog, you might have to create the response structure for each result-set(number of select statements in your procedure)

so may be you can define 4 response segments and see if that helps(instead of setting the response segment to 1..unbounded)