postgres Stored procedure Multiple ResultSets were returned by the query - How do i map the result of the postgres stored procedure result into my JRXML file fields

[ms.jobid]

<parameter name="refcursor" class="java.sql.ResultSet" isForPrompting="false"/>

<![CDATA[call rsccc.jrxmltest6('file_id'::refcursor);FETCH ALL IN "file_id";]]

Caused by: org.postgresql.util.PSQLException: Multiple ResultSets were returned by the query.

    at org.postgresql.jdbc.PgStatement.getSingleResultSet(PgStatement.java:259)

    at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:138)

 

How do i map the result of the postgres stored procedure result into my JRXML file fields

[Mehak Rajkumar]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.
 

[pjimenez_2]

Hello,

You can get the full results from your stored procedure by following this article here:

https://community.jaspersoft.com/wiki/how-execute-oracle-stored-procedure-jaspersoft-studio-621

This article is a little dated and is for Oracle, but it should run the same way for any JDBC connection.  I hope this solution works for you.

Regards,

Paul