ReportServer Forum

Glandike

Member

Registered: 2015-11-10

Jasper report connection + jar files

Hi!

Could you help me with understanding RS jar dependency and versioning? For example, when i try to replace the current jasper libruary from 6.0.3 to 6.2.0 RS doesn't start -- even login window doesn't appear. And it doesn't show any errors. But that not the biggest issue. When i try to add jasper-function.jar (version is correct) to web-inf/lib (as i guees, your project management frimework should simply build it in project) Report Server starts and works well, except one - all database connection are failed. RS can't connect to any database.

All this is done for one purpose: i need to make several database connection in jasper report, but then i try to set parameter which described database connection, RS couldn't realize what i want. Looks like RS can't find right driver, but when i trying to initiate it, he produce errors each time.

Could you help me please?

Error: An error occured during report execution.
The report could not be executed: Could not execute report: Error evaluating expression : Source text : java.sql.DriverManager.getConnection("jdbc:sqlserver://192.168.90.25:1433;databaseName=gz16", "///", "q12as")
To get help please contact an administrator.
Details
net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: Could not execute report: Error evaluating expression : Source text : java.sql.DriverManager.getConnection("jdbc:sqlserver://192.168.90.25:1433;databaseName=gz16", "///", "q12as") at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:218) at 
********************
 at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:88) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:456) at net.datenwerke.rs.base.service.reportengines.jasper.JasperReportEngine.executeReport(JasperReportEngine.java:302) ... 55 more 
Caused by: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://192.168.90.25:1433;databaseName=gz16 
at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) 
at Main_1455612242718_395409.evaluate(Main_1455612242718_395409:145) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:249) ... 65 more

Last edited by Glandike (2016-02-16 11:02:25)