kashifsbr

kashifsbr ·

This is not complete information to suggest the solution.

Looks like some configuration missing for Connection with Database.
open application.properties file located in jri => conf and make appropriate changes for database connection.

How you setup Database Connection?
Please Share the related information. your complete environment details.

Dear @daust
Thanks for the reply,
setenv.bat not found in the bin directory,
Any how I have resolved this problem by setting the values using Tomcat-Service Properties window.

Move to SQL folder in the Jasper Report Integration (jri) folder and execute the script(user_install.sql) on Oracle Command prompt; this will install all the required object to run the Jasper report from APEX.

Solved by using the setting suggested in
https://gitq.com/daust/JasperReportsIntegration/topics/19/json-error-after-call-to-jri-show-report-get-report

used this pl/sql code to call the report, and shows the above error

DECLARE
   l_blob        BLOB;
   l_mime_type   VARCHAR2 (100);
   
   l_proc varchar2(100) := 'get report as blob, then show';
   p_report_url varchar2(1000) := 'http://localhost:8080/jr...

Thank you, I was missing link to this document.
I have configured the Jasper Integration with APEX/ORDS on Apache Tomcat Server.

I have an other question not related to Jasper reporting, the reason for asking that might you can give some hints to handle th...