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!