Hi there :)
I'm trying to make a client-server system, SOAP based. Both client and server modules are written in Python.
I'm using ZSI libraries, abd Python version is 2.5.
In my WSDL File I wrote my methods. The first one to write in my DB, the second one to get a single data from the same db, and the third to get instead a whole resultSet/array/table.
Here is a part of my WSDL Code.
<!-- CODE -->
<!-- Query per scrivere i dati: -->
<message name="getExecuteScalarRequest">
<part name="query" type="xsd:string"/>
</message>
<message name="getExecuteScalarResponse">
<part name="return" type="xsd:string"/>
</message>
<!-- Query per scrivere i dati e ricevere come ritorno una Tabella/Array/resultSet: -->
<message name="getExecuteQueryRequest">
<part name="query" type="xsd:string"/>
</message>
<message name="getExecuteQueryResponse">
<part name="return" type="xsd:string"/>
</message>
<!-- END CODE -->
In the second message I cannot return a string-type data like in the first one, it would be a suicide whenever I have to manipulate the result, especially if my query returns a lot of records.
Thus, I have to find the right way to return datas organized in Array/Table/resultSet. However, I cannot write type="xsd:array", because it does not seem to be a basic data-type in WSDL files.
Therefore, here is my question. How can I return a resultSet/Table/Array to my client? What are WSDL settings I must set? What should i return from my server method?
I hope I explained it quite clear :)
Thanks anyway.