Re: PostgreSQL and SOAP, suggestions?

Hannu Krosing wrote:

>pgsql@mohawksoft.com kirjutas E, 31.03.2003 kell 19:52:
>  
>
>>Actually, as far as I am aware, the header is for metadata, i.e. it is the
>>place to describe the data being returned.
>>    
>>
>
>Did you read the SOAP spec ?
>
yes

>
>  
>
>>The description of the fields
>>isn't the actual data retrieved, so it doesn't belong in the body, so it
>>should go into the header.
>>    
>>
>
>That is logical, but this is not what the spec tells.
>
This is exactly what the spec calles for. The spec, at least 1.1, says 
very little about what should not be in the header. For an XML request, 
it should carry. It is very particular about soap header attributes, but 
header contents is very flexable.

>
>Also the spec requires immediate child elements of SOAP:Header to have
>full namespace URI's.
>
Yup, that was a bug.

>
>And another question - why do you have the namespace MWSSQL defined but
>never used ?
>
That was part of the same bug as above, it now outputs this:

<?xml version = "1.0"?>
<mwssql:Envelope xmlns:mwssql="http://www.mohawksoft.com/mwssql/envelope"><mwssql:Header> <exec:sql>update cgrpairs set
ratio=0where srcitem=100098670</exec:sql> <exec:affected>2657</exec:affected> <qry:sql>select * from ztitles limit
2</qry:sql><qry:ROWSET>  <qry:ROW columns="28">   <t:acd>undefined</t:acd>   <t:muzenbr>undefined</t:muzenbr>
<t:cat2>undefined</t:cat2>  <t:cat3>undefined</t:cat3>   <t:cat4>undefined</t:cat4>
<t:performer>undefined</t:performer>  <t:performer2>undefined</t:performer2>   <t:title>undefined</t:title>
<t:artist1>undefined</t:artist1>  <t:engineer>undefined</t:engineer>   <t:producer>undefined</t:producer>
<t:labelname>undefined</t:labelname>  <t:catalog>undefined</t:catalog>   <t:distribut>undefined</t:distribut>
<t:released>undefined</t:released>  <t:origrel>undefined</t:origrel>   <t:nbrdiscs>undefined</t:nbrdiscs>
<t:spar>undefined</t:spar>  <t:minutes>undefined</t:minutes>   <t:seconds>undefined</t:seconds>
<t:monostereo>undefined</t:monostereo>  <t:studiolive>undefined</t:studiolive>   <t:available>undefined</t:available>
<t:previews>undefined</t:previews>  <t:pnotes>undefined</t:pnotes>   <t:artistid>undefined</t:artistid>
<t:datasrc>undefined</t:datasrc>  <t:extid>undefined</t:extid>  </qry:ROW> </qry:ROWSET></mwssql:Header><mwssql:Body>
<ROWSETcolumns="28" rows="2">  <ROW ROWID="0">   <acd>P</acd>   <muzenbr>68291</muzenbr>   <cat2>Performer</cat2>
<cat3>JazzInstrument</cat3>   <cat4>Guitar</cat4>   <performer>Steve Khan</performer>   <performer2>Khan,
Steve</performer2>  <title>Evidence</title>   <artist1></artist1>   <engineer></engineer>   <producer></producer>
<labelname>Novus</labelname>  <catalog>3074</catalog>   <distribut>BMG</distribut>   <released>02/13/1990</released>
<origrel>n/a</origrel>  <nbrdiscs>1</nbrdiscs>   <spar>n/a</spar>   <minutes></minutes>   <seconds></seconds>
<monostereo>Stereo</monostereo>  <studiolive>Studio</studiolive>   <available>N</available>   <previews></previews>
<pnotes></pnotes>  <artistid>100025343</artistid>   <datasrc>1</datasrc>   <extid>68291</extid>  </ROW>  <ROW
ROWID="1">  <acd>P</acd>   <muzenbr>67655</muzenbr>   <cat2>Collection</cat2>   <cat3>Jazz Instrument</cat3>
<cat4></cat4>  <performer>Various Artists</performer>   <performer2>Various Artists</performer2>   <title>Metropolitan
OperaHouse Jam Session</title>   <artist1></artist1>   <engineer></engineer>   <producer></producer>   <labelname>Jazz
Anthology</labelname>  <catalog>550212</catalog>   <distribut>n/a</distribut>   <released>1992</released>
<origrel>n/a</origrel>  <nbrdiscs>1</nbrdiscs>   <spar>n/a</spar>   <minutes></minutes>   <seconds></seconds>
<monostereo>Mono</monostereo>  <studiolive>Live</studiolive>   <available>N</available>   <previews></previews>
<pnotes></pnotes>  <artistid>100050450</artistid>   <datasrc>1</datasrc>   <extid>67655</extid>  </ROW>
</ROWSET></mwssql:Body>
</mwssql:Envelope>