[java-list] JasperReport

Rafael De Pauli Baptista Wed, 02 Apr 2003 07:23:57 -0800

Estou com um problema que não consigo resolver.

Fiz meu relatorio em xml.

A parte que eu fiz para fazer a busca sql é assim:

E a classe que tem o static void main é assim:

import dori.jasper.engine.*;
import dori.jasper.engine.design.*;
import dori.jasper.engine.print.*;
import dori.jasper.view.*;

public class relatorio {

    /** Creates a new instance of relatorio */
    public relatorio() {

        try {
            System.setProperty("org.xml.sax.driver", "org.apache.xerces.parsers.SAXParser");

            // First, load JasperDesign from XML and compile it into JasperReport
            JasperDesign jasperDesign = JasperManager.loadXmlDesign("c:\\Falta.xml");
            JasperReport jasperReport = JasperManager.compileReport(jasperDesign);


             // Third, get a database connection
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
            java.sql.Connection conn = java.sql.DriverManager.getConnection("jdbc:odbc:diplomacao","","");

            // Fourth, create JasperPrint using fillReport() method
            JasperPrint jasperPrint = JasperManager.fillReport(jasperReport,null,conn);

            // Or to view report in the JasperViewer
            JasperViewer.viewReport(jasperPrint);


        }catch (Exception e){ e.printStackTrace();}
    }

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {

        relatorio a = new relatorio();
    }

}

E o seguinte erro é retornado

********************************************************************
* WARNING: Unable to compile with "sun.tools.javac.Main" compiler. *
* Cause : java.lang.ClassNotFoundException : sun.tools.javac.Main *
* Compiling with command line "javac" compiler.                    *
********************************************************************
java.sql.SQLException: ResultSet is closed
        at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(JdbcOdbcResultSet.java:6502)
        at sun.jdbc.odbc.JdbcOdbcResultSet.getStatement(JdbcOdbcResultSet.java:4231)
        at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:381)
        at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114)
        at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217)
        at dori.jasper.engine.JasperManager.fillReport(JasperManager.java:737)
        at relatorio.<init>(relatorio.java:41)
        at relatorio.main(relatorio.java:55)
NESTED BY :
java.sql.SQLException: ResultSet is closed
        at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(JdbcOdbcResultSet.java:6502)
        at sun.jdbc.odbc.JdbcOdbcResultSet.getStatement(JdbcOdbcResultSet.java:4231)
        at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:381)
        at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114)
        at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217)
        at dori.jasper.engine.JasperManager.fillReport(JasperManager.java:737)
        at relatorio.<init>(relatorio.java:41)
        at relatorio.main(relatorio.java:55)
NESTED BY :
dori.jasper.engine.JRException: Error closing ResultSet or Statement for report data source : Falta
        at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:390)
        at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114)
        at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217)
        at dori.jasper.engine.JasperManager.fillReport(JasperManager.java:737)
        at relatorio.<init>(relatorio.java:41)
        at relatorio.main(relatorio.java:55)
Caused by: java.sql.SQLException: ResultSet is closed
        at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(JdbcOdbcResultSet.java:6502)
        at sun.jdbc.odbc.JdbcOdbcResultSet.getStatement(JdbcOdbcResultSet.java:4231)
        at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:381)
        ... 5 more

Alguem poderia me ajudar, please!!!!

[java-list] JasperReport

Responder a