InputStream Help

[klaforce]

I am using Java to create a CFX tag in Coldfusion to read an Excel File, but I am having trouble opening the file using InputStream. I have the following code:

response.write(file + "<BR>");
InputStream myxls = new FileInputStream(file.toString());

(where response.write writes to the browser, and the string file comes in from request) If I hard code the path like this:

InputStream myxls = new FileInputStream("C:\\CFusionMX\\

http://wwwroot\\WEB-INF\\classes\\2005

Traffic Flow Team Action Register.xls");

it works great, but in I use the variable file (which holds the same value I hardcoded) it will not work. Does anyone have any suggestions? Thanks for your help.

 

[klaforce]

Also, the exception thrown is java.io.FileNotFoundException

 

[sedj]

post the stack trace (so we can see the file name its trying to load)

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[klaforce]

Well, once I did that I found the error quickly. Thanks for your help.

Keith

 

[Naug]

I recommend using File.separatorChar rather then \\ in paths

 

[klaforce]

Oh, I have never heard of File.separatorChar. Why is it better?

 

[Naug]

It uses the default separator of the OS. So under Unix it would be /, under Windows \ and so if you use relative paths you dont have to change that when moving between OS. Also you dont have to escape it so no chance of messing up there.

There are exceptions though (afaik) - I ran into problem with ziping - zip accepts both \ and / but the program that read it was expecting / and I couldnt figure where I went wrong

 

[klaforce]

Oh that is awesome, thanks for the tip.

Keith