[How to use multiple data sources in Jaspersoft Studio or JasperReports Server]

9 hours ago, katarzyna.wawer said:

oracle.jdbc.driver.OracleDriver

Not sure otherwise. That should have worked, I don't see any other reason for this error. Can you check below article and see if changing the driver class, based on which Oracle version you have, removes this error? 

 

https://stackoverflow.com/questions/6202653/difference-between-oracle-jdbc-driver-classes

[How to use multiple data sources in Jaspersoft Studio or JasperReports Server]

On 12/16/2023 at 11:22 AM, katarzyna.wawer said:

I have this error: net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: java.sql.DriverManager.getConnection("jdbc:oracle:thin@//10.7.37.182:1521/apex", "wcy19_77168", "qwerty" )

Hi @katarzyna.wawer

Which driver are you using? Can you check below article and modify your URL to see if that works? 

https://stackoverflow.com/questions/1054105/url-string-format-for-connecting-to-oracle-database-with-jdbc

[Dashboards & Interactive Reports - Supermart Dashboard]

This article is obsolete.

Below article is latest one in this series.

 

 

[Installing JasperReports Server]

Please refer to below article for the latest details about this topic.

https://community.jaspersoft.com/wiki/installation-steps-installer-distribution