kashifsbr

kashifsbr ·

  • Islamabad, Pakistan
daust/JasperReportsIntegration

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.

daust/JasperReportsIntegration

Integrate and Call Jasper Reports From Oracle APEX

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

daust/JasperReportsIntegration

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
daust/JasperReportsIntegration

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.

daust/JasperReportsIntegration

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...
daust/JasperReportsIntegration

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