[creating report from java fails with errors]

sorry about that, I just edited it differently for this post

[Add data to existing report template using java]

sorry your answer and accidently clicked accepted; as yet to try.

[creating report from java fails with errors]

I found code to produce a report via java code and thought this would be easily possible but found too many errors occurring. I am able to create a report from a template using the normal procedural steps but programmatically it fails. This is critical as i need to be able to query the DB and render the reports automatically on a schedule.

 

 

net.sf.jasperreports.engine.JRException: java.io.FileNotFoundException: C:UsersmmmDocumentsworkspace-sts-webappsHelloJasperfirstReport.jrxml (The system cannot find the file specified)

 

  JRResultSetDataSource rsdt=new JRResultSetDataSource(rs);                                     JasperReport jrpt = JasperCompileManager.compileReport("C:\Users\mmm\Documents\workspace-sts-webapps\HelloJasper\firstReport.jrxml");                          //InputStream is=this.getClass().getResourceAsStream("firstReport.jrxml");             //jrpt = JasperCompileManager.compileReport(is);                                       JasperPrint jp = JasperFillManager.fillReport(jrpt, new HashMap(), rsdt);             JasperViewer jv = new JasperViewer(jp);             jv.setVisible(true);             [/code]

 

Now when I actually add the report first using one of the templates, I get another error:

 

et.sf.jasperreports.engine.JRException: Error compiling report java source files: C:UsersmmmDocumentsworkspace-sts-websHelloJasperfirstReport_1473970204847_393001.java 

 

 

[Add data to existing report template using java]

I have still been unable to successfully create a connection to a datasource. The actual connection works but it cannot reference the existing tables within that database. I posted on this before but would like to take an alternative approach by creating the report from within java code. For example I will query the database and then try and commit the data to a specific report..

Connection conn = DriverManager.getConnection(connectionUrl);stmt = conn.createStatement();rs   = stmt.executeQuery( query );JRResultSetDataSource rsdt = new JRResultSetDataSource(rs);JasperPrint  jp;JasperReport jrpt = null;jrpt = JasperCompileManager.compileReport("Flower_Landscape.jrxml");InputStream is = this.getClass().getResourceAsStream("Flower_Landscape.jrxml");jrpt = JasperCompileManager.compileReport(is);jp   = JasperFillManager.fillReport("HelloJasper/Flower_Landscape.jrxml", new HashMap(), rsdt);JasperViewer jv = new JasperViewer(jp);jv.setVisible(true);con.close();   [/code]

I am looking for  a tutorial or assistance on how to get this done. I thought I could manipulate the fields from the xml but I have no idea on how to do this. 

[object not found creating new report]

Does anyone have any tutorials or example related jasper projects that are created within spring tool suite?

[object not found creating new report]

Hozawa

Thanks for your response. Yes, within the datasource selection in the report wizard I selected the data adapter but not sure what the dataset you referring to.

As I mentioned above, I tested the data adapter with the test connection and it worked fine so user credentials show privileges.

 

Could you please look at the image:/sites/default/files/images/JaspersoftReportWizard.png

[object not found creating new report]

My first attempt at JasperSoft Reports, community edition.Installed the necessary plugin to get it to work in Spring Tool Suite. Created a new report project and added the data adapter to connect to a sql database and the connection worked fine. Then tried to create a new report and select a datasource and design a query. This is where the error is produced:

 

 

    user lacks privilege or object not found: 

 

and the object in this case happens to be the DB table. I have been unable to retrieve any solution online and hoping someone can direct me here.

Appreciate your response.