Jump to content
Changes to the Jaspersoft community edition download ×

Connection error on subreport query


Recommended Posts

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

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...