Meaningless Drivel is fun!*
The moose likes Web Services and the fly likes Calling web service with a url Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » Web Services
Bookmark "Calling web service with a url" Watch "Calling web service with a url" New topic
Author

Calling web service with a url

Matt Kohanek
Village Idiot
Ranch Hand

Joined: Apr 04, 2009
Posts: 483

Hi.

I have a web service that I need to call from pl sql. Previously it was done by adding parameters to the url for the web service and using utl_http package
ie

Then I would parse that response

Now after migrating to weblogic, this has been returning a not found error.

So I added the wsdl for the service to a soapUI project, and passed the value. It worked fine there, so the web service seems to be up and functioning.

Here is the basic xml for the request:

So assuming the wsdl for that is:

http://webservice.com/service_name?wsdl

is there a way for me to invoke with parameters? (maybe the params need to be altered somewhat - how would I find out what the new ones are? I have tried looking at the wsdl but have not figured it out using that)

I have never invoked a web service in this manner, so I am not entirely sure what is causing it to fail after the weblogic migration

Thanks



True wisdom is in knowing you know nothing - Socrates
Ivan Krizsan
Ranch Hand

Joined: Oct 04, 2006
Posts: 2198
    
    1
Hi!
Have you seen this? http://akdora.wordpress.com/2007/08/03/calling-a-web-service-by-plsql-utl_http/
Best wishes!


My free books and tutorials: http://www.slideshare.net/krizsan
Matt Kohanek
Village Idiot
Ranch Hand

Joined: Apr 04, 2009
Posts: 483

Hi Ivan,

I actually used exactly that. I knew about that way of doing it from previous usage. It was just that the code was already built in another way, so changing it to that method would have meant more code change than may have been necessary. I wanted to try to get it done by just changing the url. Turns out, with the weblogic migration, the web service no longer has an endpoint (at least an interface for one). So that was not an option anymore.

Thanks very much for the help though!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Calling web service with a url