File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

File Permission error while calling java Stored Procedure

 
dhaval tamboli
Greenhorn
Posts: 25
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Guys,

May be I am making stupid fundamental mistake, but I am not able to figure out, what!!

Let me tel you briefly, What I am trying to do.

I loaded few jar files to oracle using loadjava and created one java class, to call one class(which is in jar file) and get the result.
now, that class(jar one) calls one file on disk (which is hardcoded) and depending on that it performs operation.

Firstly, I got this error (which is expected).



After that I gave grant using



so now, it should work, but now I am getting this error



Actually, It's not able to find file, but I am 100% sure I have provided right file name and path.
So I am not sure why this error!!

By the way, my oracle is at /opt/oracle11

I am not sure, what I am doing regarding giving grant is correct or not, but I verified grant by
And I can see it's enabled..

Let me know, if i am wrong somewhere

Thanks
 
dhaval tamboli
Greenhorn
Posts: 25
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Disregrad dbuser in giving grants.
I used ORIGDV85B only
 
Martin Vajsar
Sheriff
Pie
Posts: 3747
62
Chrome Netbeans IDE Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You probably have this right, but just for sure: does the directory you're trying to access reside on the same machine as the database server?
Database procedures (including Java) cannot access directories and files stored on client machine.
 
dhaval tamboli
Greenhorn
Posts: 25
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you are right, that file was on client machine. I added it on database server.

Thanks
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic