write pdf files whith servlets

[bruno martins]

hi, i can�t display my pdf file whith this code:
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.lang.*;
import java.sql.*;
public class testepdf extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {


String driver = "org.gjt.mm.mysql.Driver";
String url = "jdbc:mysql://sb/cmv?user=amd&&password=123";
String n1_ = "";


Connection con1;
Statement sta1;

String sql1 = "SELECT * FROM files";
PrintWriter out = response.getWriter();
response.setContentType("application/pdf");



try {
Class.forName(driver);
con1=DriverManager.getConnection(url);
sta1 = con1.createStatement();

ResultSet rs = sta1.executeQuery(sql1);

response.setHeader("Content-disposition",
"inline; filename=\"Acta.pdf\"");

rs.next();

Blob blob = rs.getBlob(3);

if (blob != null)
{
int iLen = (int)blob.length();
response.setContentLength(iLen);
ByteArrayOutputStream output = new ByteArrayOutputStream(iLen);
output.write(blob.getBytes(1, iLen), 0, iLen);
out.write(output.toString());

}

rs.close();
sta1.close();
con1.close();

}
catch(java.lang.ClassNotFoundException e) {
out.println("ERRO na ClassNotFound: " + e.getMessage());
return;
}

catch(SQLException ex) {
out.println("ERRO na ligacao :" + ex.getMessage());
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}

[Jeanne Boyarsky]

So you are trying to display the first file in the datbase (even if the query returns more than one) and the file is in the third column in PDF format?
What error are you getting?

[Bear Bibeault]

bruno, please do not cross-post the same question in multiple forums. Please continue any discussion here,
bear