store a file in tomcat server

[S Shehab]

Hi pals,

i got a servlet is going to connect to a DB then do some queries then write the result in excel file on the local hard disk , what i wanna instead writing the file on the local hard disk i wanna to store it on the tomcat in a specific path so it can be downloaded ,

Any suggestions ?

[William Brogden]

What is preventing you from accomplishing this with standard Java?

Kindly read this FAQ page.

Punctuation and logical sentence structure are your friends when communicating a question. Programmers who can't write clear documentation don't get hired.

Bill

[S Shehab]

nothing but i need all the application fully web based ..

[William Brogden]

The standard Java library and the servlet API are all you need.

What have you tried?

Where are you stuck?

Do you have code that works outside the servlet environment?

Bill

[S Shehab]

ya here it is :

 public void flushToExcel(File file, HSSFWorkbook hssfworkbook) {
 
FileOutputStream fos = null;
try {
fos = new FileOutputStream(file);
hssfworkbook.write(fos);

}
 
catch (FileNotFoundException e) {
 
System.out.println("File not found.");
e.printStackTrace();
}
catch (IOException e) {
 
System.out.println("IO Exception");
e.printStackTrace();
 
}
 
finally {

try {
fos.close();
 
}
catch (IOException e) {
 
System.out.println("Can't close the Output Stream");
e.printStackTrace();
 
}

}

}   
 
public  File createFile(String fileName)  {
filePath_Name =System.getProperty("user.dir") + "\\" + fileName + ".xls";
// this what i wanna replace with the server path but i dont know how to get the server path
 
File file = new File(filePath_Name);



 
return file;
}
 

 

[S Shehab]

i tried to get the absolute path for the file i created but i found it like this : "c:\program files\eclipse\mfile.xls", so this will not work on the web.

[William Brogden]

I just noticed you are posting the same question in the servlets forum. Posting duplicates is considered impolite since it wastes our time.

Bill

[S Shehab]

ya because i thought it may fit the Servlet forum , rather tomcat forum because the answer on the servlet forum will be generic not specified specific server so it will be more useful for all posters ..
what do you think close the thread in tomcat and keep the another one?

[Bear Bibeault]

Corss-posting is consider very very rude. If you feel you have posted in the wrong forum, ask a moderator to move it for you. Do not start a new post yourself. I'll close this one, and were I you, I'd profusely apologize to William.