Connection error on subreport query

[2002 JI Open Discussion]

By: julien Bottemanne - jbottemanne

Connection error on subreport query

2003-06-20 04:36

Hi,

 

The compilation goes well with ireport but when i integrate the .jasper report in my application i've got these error message on my sql query of my subreport :

 

dori.jasper.engine.JRException: Error executing report query :

 

select ID_INT from TEMP_CB_JASPER

 

 

this sql query is valid.

 

Here is my code :

 

Hashtable parameters = new Hashtable();

parameters.put("NOM", iBean.getCivilite()+" "+iBean.getNom());

parameters.put("PRENOM", iBean.getPrenom());

parameters.put(......

....

java.sql.Connection connection;

 

String url = "jdbc:microsoft:sqlserver://10.33.33.3:1433;user=xxx;password=xxx";

connection = DriverManager.getConnection(url,"xxx","xxx");

connection.setAutoCommit(false);

 

JasperManager.runReportToPdfFile(modeleFile, sortieFile, parameters, connection);

 

connection.close();

 

 

 

 

By: julien Bottemanne - jbottemanne

[sUCCESS] NEVER USE MICROSOFT JDBC DRIVER

2003-06-20 06:51

I change my Microsoft JDBC driver and now it works fine with this JDBC driver :

 

net.sourceforge.jtds.jdbc.Driver