kashifsbr

kashifsbr ·

  • Islamabad, Pakistan

Saving Jasper Report output

help wanted

Dear All,

How to save Jasper Report output(pdf) directly to Database without showing the output to user.

Could not connect via JDBC: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException

help wanted

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.

Integrate and Call Jasper Reports From Oracle APEX

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

Integrate and Call Jasper Reports From Oracle APEX

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.

Screenshot 2022-12-06 130719.png

Integrate and Call Jasper Reports From Oracle APEX

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.

Screenshot 2022-12-06 130719.png

how to create xlib_jasperreports packgae

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.

Error While running the report from APEX

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

Error While running the report from APEX

I have a problem calling the report from APEX 22.1 on button click(Screen shot attached),I have install the demo App in the same workspace and I can run the same report from the demo application available with jri, but can not run the same report using my ...

Integrate and Call Jasper Reports From Oracle APEX

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

Integrate and Call Jasper Reports From Oracle APEX

Please Provide detailed step by step guide that how to integrate and Call Jasper Report from Oracle Apex I'm new to Apex and Jasper Reporting.My Environment is,APEX 22.1.4ORDS 22.2Oracle DB 21c XEAPEX is working fine,Now I have to Create Reports in Jasper ...

Joined GitQ

on