<%@ page import="java.util.*, java.sql.*"%>
<%@ page import="net.sf.jasperreports.engine.*" %>
<%@ page import="java.io.*" %>
<%
File reportFile = new File(application.getRealPath("relatorioTeste.jasper"));
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:jtds:sqlserver://pub:1433/Teste","ss","ss");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("Select * from operador");
Map parameters = new HashMap();
while (rs.next()) {
out.println(rs.getString("oper_id"));
parameters.put("oper_nome", "XX");
}
byte[] bytes = JasperRunManager.runReportToPdf(reportFile.getPath(), parameters, conn);
response.setContentType("application/pdf");
response.setContentLength(bytes.length);
ServletOutputStream ouputStream = response.getOutputStream();
ouputStream.write(bytes, 0, bytes.length);
ouputStream.flush();
ouputStream.close();
%>
Ola pessoal estou com problemas aki executei essa classe mais me da
erro…
Preciso de opnioes…
javax.servlet.ServletException: Error executing SQL statement for report : relatorioTeste
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.testeJasper_jsp._jspService(testeJasper_jsp.java:86)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802