Creating a file in Database server in java

Question

My requirement is to create a file in the server in Java. I initially tried with the code given below:

File file = new File(<path in the server>);
file.createNewFile(); --- raises an exception

But when I am giving a path in server I am getting an exception

java.io.IOException: No such file or directory
at java.io.UnixFileSystem.createFileExclusively(Native Method)

Any help or suggestion on how to create a file in the server would be highly appreciated.

Kuchi · Accepted Answer · 2014-02-21 09:14:59Z

2

No such file or directory

There are basically two cases where this happens.

The file or directory doesn't exist (check the spelling).
You program doesn't have the permissions required to read and write in the given Folder. (You have to check this in your file system, depending on your operating system)

UnixFileSystem.createFileExclusively

I'm pretty sure that in this case you have to set the permissions on your folder right...

answered Feb 21, 2014 at 9:14

Kuchi

4,7643 gold badges32 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user3336147 Over a year ago

I am using the output of the SQL as the file path. select substr(value,1,decode(instr(value,','),0, length(value),instr(value,',')-1) ) from v$parameter where name = 'utl_file_dir'; I can write to this directory in PLSQL using utl_file API, is there a similar way in Java.

Kuchi Over a year ago

I suggest you explain exactly what your trying to do in Java in your question. I'm pretty sure that your database and whoever executes the Java are two different user in the System...

user3336147 Over a year ago

I have a Java program, which when run should write the SQL results into a .csv file. And this .csv file needs to reside in the server.

Gimby Over a year ago

So check and fix the user rights (or have them fixed if you cannot) as Kuchi is trying to explain to you.

Collectives™ on Stack Overflow

Creating a file in Database server in java

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related