File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Oracle JDK Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle JDK" Watch "Oracle JDK" New topic

Oracle JDK

David Fahy

Joined: Feb 13, 2004
Posts: 6
Hi all,
I am trying to write a stored procedure in pl/sql to encrypt some fields in my database(Oracle 9i). I am using a java method wrapped in pl/sql to do the encryption/decryption. The problem is that I cannot access the javax.crypto classes (secretkeyfactory etc). I have included all the JCE jar files in the {java.home}/lib/ext/ directory and I have updated the file to use security.provider.3=com.sun.crypto.provider.SunJCE. My java method compiles and works fine outside oracle (using the websphere JDK) and also compiles and runs when using the Oracle JDK outside the database but once I have loaded the method into the database (loadjava) it will not compile using the internal oracle JDK. There must be some configuration that I have overlooked. I have also included the java home directory path in my classpath. Any help would be greatly appreciated. Thanks
It is sorta covered in the JavaRanch Style Guide.
subject: Oracle JDK
It's not a secret anymore!