dwonloading issue

[Goran Markovic]

Hi,
I have a problem during downloading a file from database.
I first upload file under file name and using uploadinterceptor.
Now when I downloading, I create a .jsp page which list files in database, providing link to each of them to download.
When user choose file, request goes to action (let say action with name -Download)
that action further process to servlet, which read from database file and output it:

package msg_project.utility;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
public class FileDownloader extends HttpServlet{
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String filename = request.getQueryString();
OutputStream out = response.getOutputStream();
Connection conn = null;
try
{
String userName = "root";
String password = "slobodan";
String url = "jdbc:mysql:///file_storage";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection (url, userName, password);
Statement stat = conn.createStatement();
String selection = "select filedata from test where filename= "+"'"+filename+"'";
ResultSet theFile = stat.executeQuery(selection);
InputStream in=null;
while(theFile.next()) {
in = theFile.getBinaryStream(1);
}
byte[] raw = new byte[in.available()];
int read = 0;
while((read=in.read(raw))!=-1){
out.write(raw);
}
out.flush();
out.close();
}
catch (SQLException es)
{
System.err.println ("SQL Exception"+es);
System.err.println (es.getSQLState());
}
catch (Exception e)
{
e.printStackTrace();
System.err.println ("Cannot connect to database server");
}
}
}

The problem is that, file offered to download has name - Download.action - ! Not the real name what it was uploaded under , just name of action followed .action suffix.
What goes wrong, and how can I improve this code?!
Thanks in advance

[David Newton]

This isn't really Struts-related and might be better-asked on a servlet-oriented forum.

You have to set the content disposition/etc. to get a different filename; searching the web for file download will find many examples.

[Goran Markovic]

But how can I avoid that in my address bar to stay action name with suffix, like Download.action, and not a page which that action return as a result like - download_form.jsp-
just as it name of page supplied as a result page?

[Goran Markovic]

found solution. thanks anyway...

[David Newton]

When solutions are found it's nice to include them in the thread so that in the future people asking the same question might also find the answer.

Thanks!