download file from database

[Steven Ho]

Hello,
I am trying to download a pdf file from database.
The coding did download some content, but these downloaded file's size appear to be smaller than it should be, comparing to blob in database. Original file size is 40kb but downloaded file size is 39kb as such.
Below is what I've done. Can someone please tell me what did I do wrong?

  
String query = "SELECT * FROM CHALET_MASTER where CM_IntID=1;";
ResultSet rs = stmt.executeQuery(query);
if(rs.next()){
java.sql.Blob blob;
blob = rs.getBlob(CM_BlbDocPdf);
int iLength = (int)(blob.length());

response.setHeader("Content-Disposition", "attachment; filename=\"chalet.pdf\"");
response.setContentType("application/pdf");
response.setContentLength(iLength);

ServletOutputStream op = response.getOutputStream();
op.write(blob.getBytes(1, iLength));
op.flush();
op.close();
}else{
out.println("no file exist");
}

Have a nice day. Thank you all.
[ February 18, 2003: Message edited by: Steven Ho ]