Stored java procedure error on oracle client

[dhaval tamboli]

Hi,

I am trying to run one stored java procedure from oracle client. For that I must need to access few java classes from different jar files.
so I loaded my java classes and loaded jar files also. but classes in jar files loaded with some wiered name in oracle.
e.g. if class is com.temp.create.checkProvider, then in oracle it's loaded as '/1000ed42_checkProvider'.. I don't know why that.

so, I thought to include those jar files in jvm classpath. but as it's using database server java.home. java.class.path is null even if on database server i included those jar files in classpath.
now, without setting classpath for oracle client, I am not able to go ahead with my java procedure.

I tried to set classpath using my java program using systemProperty but I figured it won't be applied as classpath is applied at jvm startup. so I am not sure, what to do now.

Pleases let me know if anybody knows anything..

Thanks

[Fatih Keles]

Hi dhaval,

You can see full path for your java classes stored in database with the following sql statement

SELECT DBMS_JAVA.longname (ao.object_name) longname, ao.* FROM all_objects ao WHERE 1 = 1 AND object_type = 'JAVA CLASS'

But I could not understand what you mean by oracle client? Is it sqlplus or toad? or some jdbc code. Can you post some sample code here?

Regards,
Fatih.

[dhaval tamboli]

Thanks for your reply Fatih.
I can see class using that query. and yes I am using SQL Developer.
I feel Oracle JVM is giving me trouble. I'm not sure if we are allowed to change java.home for oracle or if we can include few jar files in oracle jvm classpath.
Actually it's not my class who is giving me problem. I am trying to decrypt database data which calls different provider jar files to create session with them.
to create a session with provider, I need to add few files into classpath and need to change java security policy files.

e.g. in normal jdk. I need to add jar files at jdk/jre/lib/ext dir and change local_policy.jar and us_export_policy.jar files at jdk/jre/lib/security.
but I am not sure how can I do that for oracle jvm.