We help IT Professionals succeed at work.

Invoking SSL connection from Oracle Stored procedure

Vinaya
Vinaya asked
on
Medium Priority
294 Views
Last Modified: 2008-02-01
Hi,

I am looking to invoke a java calss from an oracle procedure.
In the java class have an HTTPS connection to a server in the internet
My code works in my local m/c as a stanalone class but throws an exception
"java.net.SocketException: SSL implementation not available" while invoking from the oracle stored procedure.

I have all the files in path in my local m/c and also loaded into the oracle thr' loadJava utility
Pls suggest.

Regards
Vinaya


Comment
Watch Question

Principal Technologist
CERTIFIED EXPERT
Commented:
Maybe that the JSSE packages are missing in the class-path.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
You might need to set up this in your code:

System.setProperty("java.protocol.handler.pkgs",
        "com.sun.net.ssl.internal.www.protocol");
   Security.addProvider(new com.sun.net.ssl.internal.ssl.Provider());

see this:

http://www.javaworld.com/javaworld/javatips/jw-javatip96.html

Acton

Author

Commented:
I have done both.
Its working fine in my local system.
But when I try to call this class form oracle server, I get the Exception

Regards
Vinaya
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.