Re: PostgreSQL and SOAP, suggestions?

Hannu Krosing wrote:

>pgsql(at)mohawksoft(dot)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=0 where 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>
<ROWSET columns="28" rows="2">
<ROW ROWID="0">
<acd>P</acd>
<muzenbr>68291</muzenbr>
<cat2>Performer</cat2>
<cat3>Jazz Instrument</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 Opera House 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>