tag:blogger.com,1999:blog-6220586.post33362848322788830..comments2024-03-28T17:37:31.444+08:00Comments on Tardate 2016: First Tests of 11g Native Web ServicesAnonymoushttp://www.blogger.com/profile/14028723940654655284noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-6220586.post-30431680673968469012009-06-23T03:30:44.916+08:002009-06-23T03:30:44.916+08:00We've implemented this at my company - however...We've implemented this at my company - however we're struggling with the strange way Oracle appears to handle basic authentication. When using preemptive authentication to call the web service, Oracle appears to run out of available http connections after four or five calls. Anyone else had experience of this?darkcrafthttps://www.blogger.com/profile/13742257494866574593noreply@blogger.comtag:blogger.com,1999:blog-6220586.post-19066907606585100622009-05-30T02:47:51.927+08:002009-05-30T02:47:51.927+08:00I found your post exteremly useful in setting up m...I found your post exteremly useful in setting up my Oracle web service, however, I am also getting this "Incorrect Input Doc/URL" when I point my browser to the wsdl:<br /><br />http://localhost:8081/orawsv/ws_user/PEEPCOUNT?wsdl<br /><br />ws_user has these:<br />XDB_WEBSERVICES <br />XDB_WEBSERVICES_OVER_HTTP <br />XDB_WEBSERVICES_WITH_PUBLIC<br /><br /><br />I have scoured the internets for this error and am only coming up with 3 or 4 sites referencing this error, this being one of them. <br /><br />soapui also chokes on the wsdl. <br />Any ideas on where I can take this?squirrelhttps://www.blogger.com/profile/04189332391828777782noreply@blogger.comtag:blogger.com,1999:blog-6220586.post-71403590737307864122007-12-01T10:37:00.000+08:002007-12-01T10:37:00.000+08:00Thanks for adding the tip ... yes, soapui is a gre...Thanks for adding the tip ... yes, soapui is a great tool. Last I used it, the only niggle was it didn't support an easy way to select on/off an HTTP proxyAnonymoushttps://www.blogger.com/profile/14028723940654655284noreply@blogger.comtag:blogger.com,1999:blog-6220586.post-62096265553106563932007-11-29T04:51:00.000+08:002007-11-29T04:51:00.000+08:00For those struggling with Perl code, soapui is a g...For those struggling with Perl code, soapui is a great alternative to test.<BR/><BR/>http://www.soapui.org/<BR/><BR/>Enter authentication parameters when defining the service end point.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6220586.post-7686390029578150972007-08-18T10:19:00.000+08:002007-08-18T10:19:00.000+08:00Thanks for the additional links Marco.And Chris, y...Thanks for the additional links Marco.<BR/><BR/>And Chris, you are right. It seems the servlet mapping must be orawsv if you want to use the autogenerated WSDL (direct calls to the endpoint work OK - which was what I was trying at the time).Anonymoushttps://www.blogger.com/profile/14028723940654655284noreply@blogger.comtag:blogger.com,1999:blog-6220586.post-120503955457227152007-08-17T08:01:00.000+08:002007-08-17T08:01:00.000+08:00Well, I found out that"DBMS_XDB.addServletMapping(...Well, I found out that<BR/><BR/>"DBMS_XDB.addServletMapping(PATTERN => '/orawsvThisCanNOTBeAnything/*'<BR/><BR/>That is, the url created in the returned WSDL seems to be orawsv always, so whilst direct soap calls might work to your new URL - the WSDL is screwed if you change this.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6220586.post-33933881347951106372007-08-17T00:14:00.000+08:002007-08-17T00:14:00.000+08:00Extra pointers (from me) regarding the example giv...Extra pointers (from me) regarding the example given on the OTN XMLDB Forum by Mark, is described here:<BR/><BR/>http://www.liberidu.com/blog/?p=246Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6220586.post-26782813507720578762007-08-17T00:13:00.000+08:002007-08-17T00:13:00.000+08:00Try Mark Drake's example, give here: http://forum...Try Mark Drake's example, give here: http://forums.oracle.com/forums/thread.jspa?threadID=542931, on the XMLDB forum.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6220586.post-12359002718030034082007-08-16T21:40:00.000+08:002007-08-16T21:40:00.000+08:00Jumped up, down, left and right - and I can't get ...Jumped up, down, left and right - and I can't get these to work.<BR/><BR/>http://192.168.0.100:8080/orawsv/SCOTT/EMPCOUNT?wsdl gives me<BR/><BR/><soap:Value>soap:Sender<BR/></soap:Value> <BR/></soap:faultcode><BR/><soap:faultstring><BR/>Error processing input<BR/></soap:faultstring><BR/><BR/>Yet http://192.168.0.100:8080/ws?wsdl gives me the correct response.<BR/><BR/>I've done 3 days just trying to get this example going :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6220586.post-3813520088318910382007-08-16T05:50:00.000+08:002007-08-16T05:50:00.000+08:00What I noticed lately, but this needs also further...What I noticed lately, but this needs also further investigation on my side, is that Oracle also pushes Database Vault to enable you to control all the ACL settings and grants.<BR/><BR/>The OWSM (fna Obelix) part was clearly demonstrated on Oracle Open World 2006 to control the web service access.<BR/><BR/>Grz<BR/><BR/>MarcoAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6220586.post-36601443379131703662007-08-15T20:06:00.000+08:002007-08-15T20:06:00.000+08:00thanks Marco, yes you a right about the case-sensi...thanks Marco, yes you a right about the case-sensitivity (and the fact that its no surprise to any old Oracle hands).<BR/><BR/>I liked the diagram you included in your posting <A HREF="http://www.liberidu.com/blog/?p=244" REL="nofollow">Oracle 11g - How to enable native WSDL services</A> too. Security was cetainly one aspect I was thinking deeply about when checking out this feature, and my first thought is that you'd probably want to consider a deployment in conjunction with OWSM for any serious use .. as was shown clearly in the picture.Anonymoushttps://www.blogger.com/profile/14028723940654655284noreply@blogger.comtag:blogger.com,1999:blog-6220586.post-31386003715896805442007-08-14T06:37:00.000+08:002007-08-14T06:37:00.000+08:00Also a strang (but explainable) thing I found out ...Also a strang (but explainable) thing I found out is that the URL is case-sensitive...Anonymousnoreply@blogger.com