File Permission error while calling java Stored Procedure

[dhaval tamboli]

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).

java.security.AccessControlException: the Permission (java.io.FilePermission /opt/temp.ini read) has not been granted to ORIGDV85B. The PL/SQL to grant this is dbms_java.grant_permission( 'ORIGDV85B', 'SYS:java.io.FilePermission', '/opt/temp.ini', 'read' )

After that I gave grant using

exec dbms_java.grant_permission( 'dbuser', 'SYS:java.io.FilePermission', '/opt/temp.ini', 'read' );

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

java.io.FileNotFoundException: No such file or directory

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

select * from USER_JAVA_POLICY where grantee_name = 'dbuser';

And I can see it's enabled..

Let me know, if i am wrong somewhere

Thanks

[dhaval tamboli]

Disregrad dbuser in giving grants.
I used ORIGDV85B only

[Martin Vajsar]

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]

you are right, that file was on client machine. I added it on database server.

Thanks