• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

File Permission error while calling java Stored Procedure

 
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Disregrad dbuser in giving grants.
I used ORIGDV85B only
 
Sheriff
Posts: 3837
66
Netbeans IDE Oracle Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
you are right, that file was on client machine. I added it on database server.

Thanks
 
reply
    Bookmark Topic Watch Topic
  • New Topic