ms.jobid

Members

ms.jobid's Achievements

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 posted a topic in Products

<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
Jasper Postgres stored procedure results error : Caused by: org.postgresql.util.PSQLException: Multiple ResultSets were returned by the query.

ms.jobid posted a topic in Products

<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)