Topic awaiting preservation: How do I download a file from Oracle with a click.

I have used the uploadBean from http://www.javazoom.net/jzservlets/servlets.html to be able to upload files into Oracle database Long Raw column.

I am not sure how I could download it when user click on a link. I was thinking of an icon and when user click on the icon, there will be a prompt asking the user if they want to Save it or Open it.

Has anyone has example doing this in JSP?

Thank you.

Since you are using JSP what you will need to do is in your response change the header to that of the file type. Then you will need to select the data using SQL and your connection to the database.

Then simply output the data. I am not up to date on my JSP syntax but your code would look something like

<jsp:directive.page contentType="File/Type"/>

<%

String sql = "SELECT field FROM table WHERE id = givenId;



//Do the database query

//Put the data into a String called theFile



out.println(theFile);



%>

If the JSP directive option doesn't work then you might want to try
response.setContentType("File/Type");

Now finally depending upon your content type you might need to set up your main server to treat the files correctly.