SOAP WSDL to Extract Data from MySQL

The Web Services Description Language (WSDL) code below gets data from a MySQL database using SOAP.

 <?xml version="1.0" encoding="UTF-8"?>
<wsdl:definitions targetNamespace="http://www.soasta.com/services/" xmlns:tns="http://www.soasta.com/services/" 
xmlns:wsdlsoap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope" 
xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc11="http://schemas.xmlsoap.org/soap/encoding/" 
xmlns:soapenc12="http://www.w3.org/2003/05/soap-encoding" 
xmlns:soap11="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
  <wsdl:types>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" attributeFormDefault="qualified" elementFormDefault="qualified" targetNamespace="http://www.soasta.com/services/">
<xsd:element name="executeUpdate">
<xsd:complexType>
<xsd:sequence>
<xsd:element maxOccurs="1" minOccurs="1" name="in0" nillable="true" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="executeUpdateResponse">
<xsd:complexType>
<xsd:sequence>
<xsd:element maxOccurs="1" minOccurs="1" name="out" type="xsd:int"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="executeQuery">
<xsd:complexType>
<xsd:sequence>
<xsd:element maxOccurs="1" minOccurs="1" name="in0" nillable="true" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:complexType name="RowSet">
<xsd:sequence>
<xsd:element name="rows" type="tns:ArrayOfRow"/>
</xsd:sequence>
<xsd:anyAttribute/>
</xsd:complexType>
<xsd:complexType name="ArrayOfRow">
<xsd:sequence>
<xsd:element maxOccurs="unbounded" minOccurs="0" name="Row" nillable="true" type="tns:Row"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="Row">
<xsd:sequence>
<xsd:element name="columns" type="tns:ArrayOfColumn"/>
</xsd:sequence>
<xsd:anyAttribute/>
</xsd:complexType>
<xsd:complexType name="ArrayOfColumn">
<xsd:sequence>
<xsd:element maxOccurs="unbounded" minOccurs="0" name="Column" nillable="true" type="tns:Column"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="Column">
<xsd:sequence>
<xsd:element name="name" type="xsd:string"/>
<xsd:element name="value" nillable="true" type="xsd:string"/>
</xsd:sequence>
<xsd:anyAttribute/>
</xsd:complexType>
<xsd:element name="executeQueryResponse">
<xsd:complexType>
<xsd:sequence>
<xsd:element maxOccurs="1" minOccurs="1" name="out" nillable="true" type="tns:RowSet"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
  </wsdl:types>
  <wsdl:message name="executeUpdateResponse">
    <wsdl:part name="parameters" element="tns:executeUpdateResponse">
    </wsdl:part>
  </wsdl:message>
  <wsdl:message name="executeQueryRequest">
    <wsdl:part name="parameters" element="tns:executeQuery">
    </wsdl:part>
  </wsdl:message>
  <wsdl:message name="executeQueryResponse">
    <wsdl:part name="parameters" element="tns:executeQueryResponse">
    </wsdl:part>
  </wsdl:message>
  <wsdl:message name="executeUpdateRequest">
    <wsdl:part name="parameters" element="tns:executeUpdate">
    </wsdl:part>
  </wsdl:message>
  <wsdl:portType name="SQLServicePortType">
    <wsdl:operation name="executeUpdate">
      <wsdl:input name="executeUpdateRequest" message="tns:executeUpdateRequest">
    </wsdl:input>
      <wsdl:output name="executeUpdateResponse" message="tns:executeUpdateResponse">
    </wsdl:output>
    </wsdl:operation>
    <wsdl:operation name="executeQuery">
      <wsdl:input name="executeQueryRequest" message="tns:executeQueryRequest">
    </wsdl:input>
      <wsdl:output name="executeQueryResponse" message="tns:executeQueryResponse">
    </wsdl:output>
    </wsdl:operation>
  </wsdl:portType>
  <wsdl:binding name="SQLServiceHttpBinding" type="tns:SQLServicePortType">
    <wsdlsoap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http"/>
    <wsdl:operation name="executeUpdate">
      <wsdlsoap:operation soapAction=""/>
      <wsdl:input name="executeUpdateRequest">
        <wsdlsoap:body use="literal"/>
      </wsdl:input>
      <wsdl:output name="executeUpdateResponse">
        <wsdlsoap:body use="literal"/>
      </wsdl:output>
    </wsdl:operation>
    <wsdl:operation name="executeQuery">
      <wsdlsoap:operation soapAction=""/>
      <wsdl:input name="executeQueryRequest">
        <wsdlsoap:body use="literal"/>
      </wsdl:input>
      <wsdl:output name="executeQueryResponse">
        <wsdlsoap:body use="literal"/>
      </wsdl:output>
    </wsdl:operation>
  </wsdl:binding>
  <wsdl:service name="SQLService">
    <wsdl:port name="SQLServiceHttpPort" binding="tns:SQLServiceHttpBinding">
      <wsdlsoap:address location="https://soasta_server/soap-sql-demo/services/SQLService"/>
    </wsdl:port>
  </wsdl:service>
</wsdl:definitions>