Jump to content

ms.jobid

Members
  • Posts

    2
  • Joined

  • Last visited

ms.jobid's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. <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
  2. <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)
×
×
  • Create New...