Forum:

Servlets

The system cannot find the path specified

carina caoor

Ranch Hand

Posts: 300

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi i have written a jsp which browse for a file and read its contents .. when i browse the file the IE is passing complete file path to the servlet
C:\example\book1.xls where as when i try to run the same program on Firefox it says file cannot be found.. seeing this is thought i will restrict my application to be used on IE, but now when i run my app(server running on my machine) from other machine it tries to search the file on my machine and give errors

[error]

C:\Documents and Settings\rsrinivasan\Desktop\plots.xls (The system cannot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at excelread.FAFilePopulate.doGet(FAFilePopulate.java:38)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)

Input.jsp

where onchange send the file name to the servlet
ReadFile.java

String filename = request.getParameter("filename"); 
System.out.println(filename);
int m=1,j=1,k=1;
  
if (filename != null && !filename.equals(""))
{

POIFSFileSystem fs =new POIFSFileSystem(new FileInputStream(filename));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row;
HSSFCell cell;

out.println("<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>");
        out.println("<rows>"); 
    int rows; // No of rows
    rows = sheet.getPhysicalNumberOfRows();
    
    System.out.println("the total number of rows are"+rows);
 
    int cols = 0; // No of columns
    int tmp = 0;
 
    // This trick ensures that we get the data properly even if it doesn't start from first few rows
    for(int i = 0; i < 10 || i < rows; i++) {
        row = sheet.getRow(i);
        if(row != null) {
            tmp = sheet.getRow(i).getPhysicalNumberOfCells();
           //out.println("tmp value"+tmp);
            if(tmp > cols) cols = tmp;
            
        }
    }
    row=sheet.getRow(0);
    if(row != null)
    {out.println("<head>");
    for(int c = 0; c < cols; c++) {
         out.println("<column width=\"*\" type=\"ro\" align=\"left\">"+row.getCell((short)c)+"</column>\n");
    }
    out.println("<column width=\"*\" type=\"ch\" align=\"left\">"+"Check"+"</column>\n");
    out.println("</head>");
    }
    for(int r1= 1; r1 < rows; r++) {
        row = sheet.getRow(r);
        if(row != null) {
        out.println("<row id='r1"+m+"'>\n");
        m++;
            for(int c = 0; c<cols; c++) {
               cell = row.getCell((short)c);
        //cell = row.getCell(1);
                if(cell != null)
                {
                out.println("<cell id='c"+j+"'>"+cell+"</cell>");
                j++;
                
                
                    
                }
            }
            out.println("<cell id='cn"+k+"'></cell>"); 
            k++;
            out.println("\n</row>");   
            }
    }out.println("</rows>");
}

please suggest me something how do i get the file path where instance of the application is running on some other system other then mine

[ November 06, 2008: Message edited by: Paul Sturrock ]
[ November 09, 2008: Message edited by: ruquia tabassum ]

Paul Sturrock

Bartender

Posts: 10336

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

where onchange send the file name to the servlet

What uploads the file to the server? Does the file C:\Documents and Settings\rsrinivasan\Desktop\plots.xls exist on the server?
[ November 06, 2008: Message edited by: Paul Sturrock ]

JavaRanch FAQ HowToAskQuestionsOnJavaRanch

carina caoor

Ranch Hand

Posts: 300

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

as tomcat is running on my system c:\Documents and Setting\rsrinivasan\plots.xls doesnot exists on my system, plots.xls file exists on the system name rsrinivasan.... as instance of my application is running on rsrinivasan system from there when a file is uploaded it gives me the error "system cannot find the path specified"

Jesper de Jong

Java Cowboy

Posts: 16084

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

The way you're trying to do it, doesn't work.

Tomcat does not automatically get the file and does not automatically save it on the server if you add a file upload input element on your HTML form. You need something to handle the file upload. Use a library, such as Apache Commons FileUpload for example, to get the file from the client computer and save it on the server.

Jesper's Blog - Pluralsight Author Page

carina caoor

Ranch Hand

Posts: 300

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Instead of saving the file from client computer on the server machine cant there be any other possible solution? because i cannot store the file on the server machine it increases the overhead on server, the application is accessed by suppose 100 employees and every one uploads a file every 10 minutes and each file is more than 500KB per day around 50000 files get stored on the serve machine ... which makes the server less efficient,slow.

if i run a batch such that the temporary files stored are to be deleted every morning still there will be some point of time in a busy day where the server gets loaded with large data and becomes slow.
Also as the server maintains all the live database i cannot store and delete files from it very frequently...

Please suggest me something how do i solve this issue...

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.