Hi all,
I have already posted this message in the "No deserializer for
{http://www.w3.org/2001/XMLSchema}anyType"; thread. I suppose that since it
was a reply to this thread no body has noticed it.
I reposted it in new thread because the answers I found in previous
threads dose not help me to solve my problem. I suppose that my case is
slightly different.
Here is my case:
First of all I am new in using SOAP and AXIS.
I am writing a soap client for a third party server. I tried to generate
the stubs using AXIS 1.4 WSDL2Java. The WSDL structure that corresponds to
my problem is listed below.
But when I execute my test program that call executeSQLQuery I got an
exception with "No deserializer for
{http://www.w3.org/2001/XMLSchema}anyType"; message. The SOP query succeeded
and the client application got the right answer but the answer is not
correctly parsed. It seems like the AXIS generated stubs can't deserialize
the xsd:anyType type.
I am not sure that I understand correctly what would represent such a type.
I suppose tha it should be interpreted as block of character or something
like the SQL blob type. In my case the <row> element whose type is anyType
should contain the rows returned by the sql query and may have any number of
columns depending on the SQL request itself. For example the answer may be:
<return>
<row>
<name>SEP000000000001</name>
<pkid>{49465272-5C37-41F8-BD0D-01BAB52D5770}</pkid>
<description>Auto 1001</description>
</row>
<row>
<name>SEP000000000002</name>
<pkid>{1E96EEB5-66F2-4766-A6B7-07D0337A8591}</pkid>
<description>Auto 1002</description>
</row>
</return>
Can any body help me get this work?
The WSDL structure is:
<xsd:complexType name="ExecuteSQLQueryReq">
<xsd:complexContent>
<xsd:extension base="axlapi:APIRequest">
<xsd:sequence>
<xsd:element name="sql" type="xsd:string" nillable="false">
<xsd:annotation>
<xsd:documentation>WARNING: SQL Large Text and BLOB columns
cannot be fetched along with other columns. A Large Text or BLOB column
must be selected in its own SQL query.</xsd:documentation>
</xsd:annotation>
</xsd:element>
</xsd:sequence>
</xsd:extension>
</xsd:complexContent>
</xsd:complexType>
<xsd:element name="executeSQLQuery" type="axlapi:ExecuteSQLQueryReq"
nillable="false">
<xsd:annotation>
<xsd:documentation>This API call is used to execute a Structured Query
Language query against the database. The sql element would contain the SQL
statement. If special characters are required, wrap the SQL command inside
a CDATA element.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:complexType name="ExecuteSQLQueryRes">
<xsd:complexContent>
<xsd:extension base="axlapi:APIResponse">
<xsd:sequence>
<xsd:element name="return">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="row" type="xsd:anyType" minOccurs="0"
maxOccurs="unbounded">
<xsd:annotation>
<xsd:documentation>Each row element can contain any number
of sub-elements, each sub-element is a column from that row in the result
set.</xsd:documentation>
</xsd:annotation>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:extension>
</xsd:complexContent>
</xsd:complexType>
<xsd:element name="executeSQLQueryResponse"
type="axlapi:ExecuteSQLQueryRes">
<xsd:annotation>
<xsd:documentation>The response message to executeSQLQuery. The return
element represents the result set, which can contain 0 or more rows of data.
Each row can have any number of elements as defined by columns specified in
the SQL Query. The name of each sub-element of the row element represents
the column name, the value of each sub-element of the row element is the
corresponding value of that column in the database.</xsd:documentation>
</xsd:annotation>
</xsd:element>
--
View this message in context:
http://www.nabble.com/-Axis+1.4-+No+deserializer+for+anyType-t1698308.html#a4608778
Sent from the Axis - User forum at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
