Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trying to generate a pdf with jasper reports

807575Jul 4 2005 — edited Oct 1 2005
Fellas,

i hav trying to generate a pdf with jasper reports, but i cant. I create a file .jasper with iReports. This is my code:

emite.java
package utilitarios;

//import net.sf.jasperreports
import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.view.JasperViewer;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import java.util.HashMap;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class emitebl {

private static Connection getConnection( ) throws ClassNotFoundException, SQLException{
String driver = "org.postgresql.Driver";
String url = "jdbc:postgresql://localhost/sist";
String user = "usuario";
String password = "";

Class.forName(driver);
Connection con = DriverManager.getConnection( url, user, password );
return con;
}

public void geraRelatorio( ) throws JRException, Exception{
Connection con = getConnection( );
Statement stm = con.createStatement( );
String query = "SELECT * FROM emissaobl WHERE id=4";
ResultSet rs = stm.executeQuery(query);

JRResultSetDataSource jrRS = new JRResultSetDataSource(rs);

Map parameters = new HashMap();

JasperFillManager.fillReportToFile("emitebl.jasper",parameters,jrRS);
JasperExportManager.exportReportToPdfFile("emitebl.jrprint"); 

JasperViewer.viewReport("emissao_bl.pdf",false); 
}
} 
emissao.jsp:
<%@ page import="utilitarios.*" %>
<% 
new emitebl().geraRelatorio();
%>
Following the error message exception:
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: emitebl.jasper
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
	org.apache.jsp.emissaobl.exportapdf_jsp._jspService(exportapdf_jsp.java:76)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)

root cause

net.sf.jasperreports.engine.JRException: emitebl.jasper
	net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:73)
	net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:270)
	utilitarios.emitebl.geraRelatorio(emitebl.java:37)
	org.apache.jsp.emissaobl.exportapdf_jsp._jspService(exportapdf_jsp.java:54)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)
where i hav to put the .jasper file?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2005
Added on Jul 4 2005
1 comment
556 views