Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

JasperReportsIntegration- Dont Work with Oracle21c XE #47


My info:
Configuration Info
The current configuration is loaded from: /opt/apache-tomcat-9.0.65/webapps/jri/WEB-INF
Config-Directory: /opt/apache-tomcat-9.0.65/webapps/jri/WEB-INF/conf
Config-File: /opt/apache-tomcat-9.0.65/webapps/jri/WEB-INF/conf/
Reports-Directory: /opt/apache-tomcat-9.0.65/webapps/jri/WEB-INF/reports
Temp-Directory: /opt/apache-tomcat-9.0.65/webapps/jri/report_tmp
Logs-Directory: /opt/apache-tomcat-9.0.65/webapps/jri/WEB-INF/logs
Java-Runtime-Version: 11.0.17
JasperReports-Version: 6.4.1

My JasperReportIntegration dont Work, Dont connect to Oracle21cXE, the default jdbc Test always is empty or blank page, when i check the log it says that:

HTTP Status 500 – Internal Server Error
Type Exception Report
Message Could not connect via JDBC: ORA-01017: invalid username/password; logon denied
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
java.lang.RuntimeException: Could not connect via JDBC: ORA-01017: invalid username/password; logon denied
de.oc.utils.Utils.throwRuntimeException(Unknown Source)
de.oc.db.ConnectionUtility.getConnection(Unknown Source)
de.oc.integration.jasper.webapp.AppConfig.getConnection(Unknown Source)
de.oc.integration.jasper.webapp.ReportWrapper.service(Unknown Source)
Note The full stack trace of the root cause is available in the server logs.
Apache Tomcat/9.0.65

Connection parameters are ok in
I have been testing with ojdbc8.jar, orai18n.jar, ojdbc6.jar, ojdbc11.jar, ucp11.jar and ojdbc8.jar and it dont work.

Any suggest? thank you so much for the great tool.


  • replies 5
  • views 966
  • likes 0

The error is "invalid username/password"
Did you check this? Did you try resetting the user/pass?


Hi everybody:
I got it. I want to share you how to solve it

MAYO 22 2023

Environment (AWS EC2 t2.small)

Oracle Linux 8.6-x86_64
Oracle Database 23c Free
Ords 23.1.2.r1151944
Apex 23.1.0
Java-Runtime-Version: 11.0.19
Apache Tomcat 9-0-65
Jasper Report Integration 2.4.0.


  1. Edit listener.ora add databases:

(ORACLE_HOME = /opt/oracle/product/23c/dbhomeFree
(ORACLE_HOME = /opt/oracle/product/23c/dbhomeFree

  1. Warning Check the correct way to setting url to jdbc in file /opt/apache-tomcat-9.0.65/webapps/jri/WEB-INF/conf/
  2. Edit SQLNET.ORA /opt/oracle/product/23c/dbhomeFree/network/admin/sqlnet.ora
  3. If "ORA-01017: invalid username/password; logon denied" error, then you need to re-create your password.

It works with jri 2.10.0 too.

that's all folks


I forget it

ojdbc8.jar in /opt/apache-tomcat-9.0.65/lib


Hi @oegidio,

thank you for the feedback and finding a solution!

All the best