Problems with JasperReports
Galley, if you don't understand excuse very well, and that alone half weak in English, but we are going to the that interests, I am beginning with JasperReports, and I am coming across a mistake that is not going for way front any, if somebody can help myself, below the example that I am using proceeds and the mistake.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRResultSetDataSource;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.view.JasperViewer;
publicclass PrimeiroRelatorio{
privatestatic Connection con=null;
public Connection conecta()
{
try
{
if (con==null)
{
String url = ("jdbc:mysql://localhost:3306/sca");
String usuario ="root";
String senha ="bdsca";
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(url,usuario,senha);
System.out.println("Conectou ao banco com sucesso");
}
}
catch (Exception e){e.printStackTrace();}
return con;
}
publicvoid geraRelatorio()throws JRException
{
try
{
String query = ("Select * From Fornecedor");
PreparedStatement pstm = conecta().prepareStatement(query);
ResultSet rs = pstm.executeQuery();
java.util.Map parameters =new java.util.HashMap();
parameters.put("Par_Teste","Vlr_Teste" );
JRResultSetDataSource jr =new JRResultSetDataSource(rs);
JasperReport jasperReport = JasperManager.loadReport("new_report.jasper" );
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, jr);
JasperViewer.viewReport(jasperPrint);
}
catch(Exception ex){ex.printStackTrace();}
}
publicstaticvoid main(String[] args)throws JRException, Exception
{
new PrimeiroRelatorio().geraRelatorio();
}
}
and here the error
Exception in thread"main" java.lang.ExceptionInInitializerError
at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:113)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:83)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:428)
at PrimeiroRelatorio.geraRelatorio(PrimeiroRelatorio.java:49)
at PrimeiroRelatorio.main(PrimeiroRelatorio.java:60)
Caused by: org.apache.commons.logging.LogConfigurationException: java.lang.NullPointerException
at org.apache.commons.logging.LogFactory.newFactory(LogFactory.java:558)
at org.apache.commons.logging.LogFactory.getFactory(LogFactory.java:355)
at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:390)
at net.sf.jasperreports.engine.fill.JRBaseFiller.<clinit>(JRBaseFiller.java:250)
... 5 more
Caused by: java.lang.NullPointerException
at org.apache.commons.logging.LogFactory.newFactory(LogFactory.java:543)
... 8 more
Thanks Gallery
