Generate csv file on a button click

[violeta]

Hello everyone,
I have a web page where a user can choose a group name, and then he's sent to another jsp where I display members for the chosen group based on a query result. I want the user to be able to click on a button that will let him save the result as csv file. I tried to create the file when the jsp loads; however, there was a problem when more than one user clicked on the button at the same time, because the file was getting overwritten and only one user was getting file with the right result. When 100 users click on the button, I don't want to save 100 files to the server. Is there any efficient way to do it?

[travishein]

not sure why would would need to write to a csv file on the server in the first place, couldn't the generator just stream the csv content back to the client in the response ?

but if you do need to invoke some external utility to render a csv file, instead of it using a hard coded /tmp/file.csv path, which yes, gets stomped on when more than one concurrent user does the request,
could you at the start of the request, generate a unique file name. then instead of redirecting to the url of the csv file (which you must be doing, to need to have the file there in the first place?) , have the servlet stream the generated file back, then delete the file after.

..psudocode..

public void doGet(HttpServletRequest request, HttpServletResponse response) {
  // generate unique csv file name
 String csvFileName =  "/tmp/report-" + String.valueOf(new Date().getTime()) + ".csv"
// render to this file
  // open this file
  InputStream in = new FileInputStream(csvFileName);    
  OutputStream out =   response.getOutputStream();
  response.setContentType("text/csv");
  // while not end of input stream  {
    // read bits, write to output stream
  } // while
  out.flush();
  in.close();
  // delete the generated file.
  new File(csvFileName).delete();
}