Hi All;
I am trying to test the web services consumer example on a DB2 v9 ESE
Windows server. I have tried 2 methods which both return the same
error:
-----------------------------------------------------------------------
[IBM][CLI Driver][DB2/NT] SQL0443N Routine "DB2XML.SOAPHTT PV"
(specific name "SOAPHTTPVI VO") has returned an error SQLSTATE with
diagnostic text "Error during socket connect". SQLSTATE=38309
------------------------------------------------------------------------
Here is the code that generates the error (method #1)
-------------------------------------------------------------------------
values db2xml.soaphttp v('http://services.xmetho ds.net/soap'
,''
,varchar('<ns1: getRate xmlns:ns1="urn: xmethods-CurrencyExchang e"
SOAP-ENV:encodingSty le="http://schemas.xmlsoap .org/soap/encoding/">'
|| '<country1 xsi:type="xsd:s tring">usa</country1>'
|| '<country2 xsi:type="xsd:s tring">euro</country2>'
|| '</ns1:getRate>')
)
---------------------------------------------------------------------------
Here is the code for method #2
---------------------------------------------------------------------------
VALUES substr(DB2XML.S OAPHTTPV ('http://services.xmetho ds.net:80/soap',
'',
XMLCAST(XMLELEM ENT(NAME "ns:getRate ",
XMLNAMESPACES(' urn:xmethods-CurrencyExchang e' as "ns"),
XMLELEMENT(NAME "country1", 'united states'),
XMLELEMENT(NAME "country2", 'korea')) as varchar(160))),
1, 160);
----------------------------------------------------------------------------
Is the provider still functional? Do I have a firewall issue? Has
anyone gotten these to work? Thanks for any help or insight.
Pete H 4 2714
Hi Pete
this error can occur, if the remote web service is not available. It
might be that you just tried it at a time where the XMothods server was
down. It might also be a firewall issue in case DB2 is not allowed to
connect.
I just tried your first UDF call on my DB2 V9 on Windows and it worked
right away.
So - in case you get this error you might want to double check if the
server is responding - for example you can use the endpoint URL in a
browser and see if you get some response. And you might also want to
check your firewall settings.
Regards,
Michael
peteh wrote:
Hi All;
I am trying to test the web services consumer example on a DB2 v9 ESE
Windows server. I have tried 2 methods which both return the same
error:
-----------------------------------------------------------------------
[IBM][CLI Driver][DB2/NT] SQL0443N Routine "DB2XML.SOAPHTT PV"
(specific name "SOAPHTTPVI VO") has returned an error SQLSTATE with
diagnostic text "Error during socket connect". SQLSTATE=38309
------------------------------------------------------------------------
Here is the code that generates the error (method #1)
-------------------------------------------------------------------------
values db2xml.soaphttp v('http://services.xmetho ds.net/soap'
,''
,varchar('<ns1: getRate xmlns:ns1="urn: xmethods-CurrencyExchang e"
SOAP-ENV:encodingSty le="http://schemas.xmlsoap .org/soap/encoding/">'
|| '<country1 xsi:type="xsd:s tring">usa</country1>'
|| '<country2 xsi:type="xsd:s tring">euro</country2>'
|| '</ns1:getRate>')
)
---------------------------------------------------------------------------
Here is the code for method #2
---------------------------------------------------------------------------
VALUES substr(DB2XML.S OAPHTTPV ('http://services.xmetho ds.net:80/soap',
'',
XMLCAST(XMLELEM ENT(NAME "ns:getRate ",
XMLNAMESPACES(' urn:xmethods-CurrencyExchang e' as "ns"),
XMLELEMENT(NAME "country1", 'united states'),
XMLELEMENT(NAME "country2", 'korea')) as varchar(160))),
1, 160);
----------------------------------------------------------------------------
Is the provider still functional? Do I have a firewall issue? Has
anyone gotten these to work? Thanks for any help or insight.
Pete H
sc*******@gmail .com wrote:
Hi Pete
I just tried your first UDF call on my DB2 V9 on Windows and it worked
right away.
Hi Michael;
Can you confirm that you cut-and-pasted the EXACT statement from my
post and it ran OK? That would seem to point to a firewall issue as
I've tried it many times over the last few days with no success.
Thanks!
Pete H
Hello Pete,
sorry for the late response - but yes, I copied and paste the exact
statement you posted here. The first one works right away. The second
one fails with the following error:
SQL0443N Routine "DB2XML.SOAPHTT PV" (specific name "SOAPHTTPVI VO") has
returned an error SQLSTATE with diagnostic text "1 is an invalid
index".
SQLSTATE=38327
But this is due to changes in XMLCAST function in DB2 version 9.1 - you
have to use XMLSERIALIZE now - change the 2nd statement to:
VALUES substr(DB2XML.S OAPHTTPV ('http://services.xmetho ds.net:80/soap',
'',
XMLSERIALIZE(XM LELEMENT(NAME "ns:getRate ",
XMLNAMESPACES(' urn:xmethods-CurrencyExchang e' as "ns"),
XMLELEMENT(NAME "country1", 'united states'),
XMLELEMENT(NAME "country2", 'korea')) as varchar(160))),
1, 160);
So from my perspective that looks pretty much like a firewall issue.
Regards,
Michael
peteh wrote:
sc*******@gmail .com wrote:
Hi Pete
I just tried your first UDF call on my DB2 V9 on Windows and it worked
right away.
Hi Michael;
Can you confirm that you cut-and-pasted the EXACT statement from my
post and it ran OK? That would seem to point to a firewall issue as
I've tried it many times over the last few days with no success.
Thanks!
Pete H
sc*******@gmail .com wrote:
Hello Pete,
sorry for the late response - but yes, I copied and paste the exact
statement you posted here. The first one works right away. The second
one fails with the following error:
Thanks for confirning. I've been working with our network services
group to resolve. Btw, great info on XMLSerialize.
Pete H This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: asj |
last post by:
Just when I say web services may be hyped, here comes a news report
that says Swedish Referendum Results will be delivered in real time
over the internet using Java web services.
In one sense, exposing the real-time results as a web service is sorta
cool, since other apps can tie in to it and distribute the info to
multiple targets. n the other hand, wouldn't deploying the
information via HTML be easier for the majority of people who...
|
by: Burns |
last post by:
Hi
I'm trying to write a service. It's a pretty simple thing at the moment that just writes to the EventLog, just so I can get my head around the basics of writing Services. It's compiled fine in Visual Studio, but I'm having a bit of bother getting it to run
Visual Studio says to use InstallUtil.exe to install the service first, so I used it as follows
installutil /AssemblyName myServic
Which appeared to run fine, but the service...
|
by: Sahil Malik [MVP] |
last post by:
Okay so now I understand (surprised though) - that WebServices can indeed
pass ByRef/ref parameters. All I have to do is mark an integer parameter of
a WebMethod as "ref". Funnily enough, this is also supported per the SOAP
Spec, and from what I understand, .NET's implementation of WebServices,
donot follow the standard, but instead shimmy this behavior by working with
a strict request/response WSDL.
So my question is - If I mark an int...
|
by: Woody Splawn |
last post by:
I am asking this question here because I asked this question in the
Reporting Services Newsgroup and did not get an answer. Does anyone know if
Reporting Services is intended to work in a client/Server or Local machine
environment? Based on what I have seen my guess is yes but that is a guess.
In some materal it talks about it running on a web server but my supposition
is that this does not necessarily mean that it would not make for a...
|
by: Lilly |
last post by:
I was testing a very simple web services written in Axis (1.2RC2) with
just a single method, returning a string "test". The method doesn't
need any parameters. when I tested it using .Net client, it returns
null. Could anyone please tell me what could ne wrong? I've beening
fighting this problem for days now, but still no luck..
Could anyone tell me what could be wrong? Where can I find sample code
for Axis/.Net combination?
Thanks.
| |
by: Anonieko |
last post by:
A lot of times, web hostings for ASPNET 2.0 will offer only MS Access
DB for database for basic plan, a question often asked is how can I use
the membership services, role, web parts services, etc for this MS
Access db. Well, microsoft offers a download sample. Instructions
are below.
HOW TO USE MS ACCESS DB FOR ASPNET APPLICATION SERVICES ( membership,
profile, roles, etc providers)
|
by: kbutterly |
last post by:
Good afternoon,
I have what appears to be a caching issue, but i'm a bit of a newbie at
http headers so it may be something else.
I have a small asp.net 2.0 application that is called to serve up some
SQL Reporting Services reports. The asp pages are running under SSL as
are the pages that call the asp app.
The asp app runs correctly, but the reports cannot be opened or saved.
|
by: JT |
last post by:
Hi,
I think I need a "best practices" lesson on web sites and web services.
In order to conform to the restraints of my web host, my web services
seem to need to be in a subfolder of my web site. So if I have a
wwwroot folder containing my site, which maps to www.MySite.com, then
to reference my web service, MyService, I place it in a folder that
maps to wwwroot/MyService/MyService.asmx. This is dandy. I reference
it by using the...
|
by: =?Utf-8?B?U2NvdHQ=?= |
last post by:
I have seen many articles describing why versioning web services are
important. I have a scenario that I would like to propose to seek a solution.
I have a publicly consumable web service. Two different clients, A and B,
consume this service. I make framework and architecture modifications that
are needed to my web services. Client "A" is ready for the upgrade while
client "B" is not ready. I have to publish the update immediately...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |