Win a copy of Secure Financial Transactions with Ansible, Terraform, and OpenSCAP this week in the Cloud/Virtualization forum!
  • 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
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Rob Spoor
  • Henry Wong
  • Liutauras Vilda
Saloon Keepers:
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
Bartenders:
  • Frits Walraven
  • Himai Minh
  • Jj Roberts

Stored java procedure error on oracle client

 
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 25
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Look ma! I'm selling my stuff!
SKIP - a book about connecting industrious people with elderly land owners
https://coderanch.com/t/skip-book
reply
    Bookmark Topic Watch Topic
  • New Topic