There is a WSDL for the AXL interface, it is available for download from the administrative web pages/UI of the UCM server itself - under Applications/Plugins, as AXL SQL Toolkit. The Toolkit includes a small Java sample with actually performs an executeSqlRequest.
A limitation of the WSDL concept itself however is that requests/responses are supposed to be fully defined. In the case of an AXL request that submits custom SQL statements, the data returned - while tabular - can have any number of fields in the result, and so cannot be parsed by code created by WSDL consumer/compilers. For executeSqlQuery requests, it's generally just easier to set up an HTTP POST with some string/concatenated XML (only the SQL text needs to change between requests), and then use an XML parser to access the results.
Example of full request/response:
POST https://10.88.131.141:8443/axl/ HTTP/1.1
Accept-Encoding: gzip,deflate
Content-Type: text/xml;charset=UTF-8
SOAPAction: "CUCM
B ver=8.5 executeSQLQuery"
Authorization: Basic QWRtaW5pc3RyYXRvcjpjaXNjbyExMjM=
Content-Length: 312
Host: 10.88.131.141:8443
Connection: Keep-Alive
User-Agent: Apache-HttpClient/4.1.1 (java 1.5)
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.5">
<soapenv:Header/>
<soapenv:Body>
<ns:executeSQLQuery sequence="1">
<sql>select * from processnode</sql>
</ns:executeSQLQuery>
</soapenv:Body>
</soapenv:Envelope>
----------------------------
HTTP/1.1 200 OK
Set-Cookie: JSESSIONIDSSO=AD4AB341D0D439A467D55B328693C035; Path=/; Secure
Set-Cookie: JSESSIONID=B96E4958B5D31504ED0F367A2CE935FE; Path=/axl; Secure
Content-Type: text/xml;charset=UTF-8
Content-Length: 957
Date: Wed, 13 Mar 2013 06:13:26 GMT
Server:
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<ns:executeSQLQueryResponse xmlns:ns="http://www.cisco.com/AXL/API/8.5">
<return>
<row>
<pkid>00000000-1111-0000-0000-000000000000</pkid>
<name>EnterpriseWideData</name>
<mac/>
<systemnode>t</systemnode>
<description/>
<isactive>t</isactive>
<nodeid>1</nodeid>
<tknodeusage>1</tknodeusage>
<ipv6name/>
</row>
<row>
<pkid>854a8c28-dae6-42fd-93fb-46edc2b5f2aa</pkid>
<name>10.88.131.141</name>
<mac/>
<systemnode>f</systemnode>
<description/>
<isactive>t</isactive>
<nodeid>2</nodeid>
<tknodeusage>0</tknodeusage>
<ipv6name/>
</row>
<row>
<pkid>b534935e-d765-c25e-096c-509eb9b96b37</pkid>
<name>10.88.131.146</name>
<mac>000c292b3ba2</mac>
<systemnode>f</systemnode>
<description>UCM851sub</description>
<isactive>t</isactive>
<nodeid>3</nodeid>
<tknodeusage>1</tknodeusage>
<ipv6name/>
</row>
</return>
</ns:executeSQLQueryResponse>
</soapenv:Body>
</soapenv:Envelope>
