Re: PostgreSQL and SOAP, suggestions?
От | mlw |
---|---|
Тема | Re: PostgreSQL and SOAP, suggestions? |
Дата | |
Msg-id | 3E878F20.1010402@mohawksoft.com обсуждение исходный текст |
Ответ на | PostgreSQL and SOAP, version 7.4/8.0 (mlw <pgsql@mohawksoft.com>) |
Ответы |
Re: PostgreSQL and SOAP, suggestions?
(Hannu Krosing <hannu@tm.ee>)
Re: PostgreSQL and SOAP, suggestions? (Peter Eisentraut <peter_e@gmx.net>) |
Список | pgsql-hackers |
Given a HTTP formatted query: GET "http://localhost:8181/pgmuze?query=select+*+from+zsong+limit+2" The output is entered below. Questions: Is there a way, without spcifying a binary cursor, to get the data types associated with columns? Right now I am just using undefined, as the ODBC version works. Anyone see any basic improvements needed? <?xml version = "1.0"?> <soap:Envelope xmlns:MWSSQL="http://www.mohawksoft.com/MWSSQL/envelope"><soap:Header> <!-- Fields in set --> <Columns count="9"> <muzenbr>undefined</muzenbr> <disc>undefined</disc> <trk>undefined</trk> <song>undefined</song> <artistid>undefined</artistid> <acd>undefined</acd> <trackid>undefined</trackid> <datasrc>undefined</datasrc> <extid>undefined</extid></Columns></soap:Header><soap:Body> <ROWSET columns="9" rows="2"> <ROW ROWID="0"> <muzenbr>424965</muzenbr> <disc>1</disc> <trk>5</trk> <song>Write My Name In The Groove</song> <artistid>100021391</artistid> <acd>A</acd> <trackid>203429573</trackid> <datasrc>1</datasrc> <extid>203429573</extid> </ROW> <ROW ROWID="1"> <muzenbr>177516</muzenbr> <disc>1</disc> <trk>1</trk> <song>PapaWas A Rolling Stone</song> <artistid>100000411</artistid> <acd>P</acd> <trackid>200000000</trackid> <datasrc>1</datasrc> <extid>200000000</extid> </ROW> </ROWSET></soap:Body> </soap:Envelope> Steve Wampler wrote: >On Fri, 2003-03-28 at 14:39, mlw wrote: > > > >>I was thinking of using SOAP over HTTP as the protocol, and a >>minimalist version at best. If the people want "more" let them add it. >> >>I have an HTTP service class in my open source library. It would br >>trivial to accept a SQL query formatted as a GET request, and then >>execute the query and, using libpq, format the result as XML. It >>should be simple enough to do. >> >> > >It would be easy. I've done something similar (using ODBC to >get to PostgreSQL) - but using a language none of the rest of >you are likely to be interested in (Unicon). Works just fine, >though the implementation (deliberately, by personal preference) >avoids accepting arbitrary SQL statements from SOAP clients, >instead forcing the clients to use an RPC interface so I can >do sanity checking in the Unicon [which I know better than I know >PostgreSQL...] SOAP servers. > >I, too, opted for a 'minimal-SOAP' implementation. A 'real' >implementation boggles the mind. > > >
В списке pgsql-hackers по дате отправления: