return multiple resultsets with jdbc query consumer

asked 2019-07-29 04:49:23 -0600

ahmed_alashrafy gravatar image

updated 2019-07-29 15:39:08 -0600

I have stored procedure which return multiple result sets from the database. how can I them from jdbc consumer I am able only to get first one but not all. The procedures return with multiple ECHO select statements SDC return only the result of first ECHO not the rest, I tried with python script it returned multiple results. The JDBC consumer is with default configuration.

edit retag flag offensive close merge delete

Comments

There's nothing extra/special you need to do to retrieve multiple rows from stored procedure. Can you make sure your stored proc is actually returning expected set of rows using external tool (not from SDC) and also update your question with a screenshot of your JDBC Query Consumer config section?

iamontheinet gravatar imageiamontheinet ( 2019-07-29 11:50:14 -0600 )edit

Also make sure Max Batch Size (Records) is set to > 1

iamontheinet gravatar imageiamontheinet ( 2019-07-29 11:59:46 -0600 )edit