File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes Stored java procedure error on oracle client Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Stored java procedure error on oracle client" Watch "Stored java procedure error on oracle client" New topic
Author

Stored java procedure error on oracle client

dhaval tamboli
Greenhorn

Joined: Aug 02, 2010
Posts: 25
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
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
Hi dhaval,

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



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
Greenhorn

Joined: Aug 02, 2010
Posts: 25
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Stored java procedure error on oracle client