Trying to get a remote connection set up to a database by using a
webservice, but not having much luck yet. Suggestions please!
1. Here's the component on siteA (remoteTEST.cfc):
<cfcomponent>
<cffunction name="getEMPLOYEES" access="remote" returntype="query">
<cfquery name="getSTAFF"
datasource="#dsource#"
username="#user#"
password="#passW#">
SELECT clientNAME FROM STAFF
</cfquery>
<cfreturn getSTAFF>
</cffunction>
</cfcomponent>
2. Here's the test page on siteB:
<cfobject
webservice="http://www.siteA.com/components/remoteTEST.cfc?wsdl";
name="ourSTAFF">
<cfinvoke webservice="#ourSTAFF#"
method="getEMPLOYEES"
returnvariable="getSTAFF" >
<!---TEST OUTPUT BLOCK--->
<cfoutput query="getSTAFF">
<p>#STAFF.clientNAME#</p>
</cfoutput>
Errors:
Could not perform web service invocation "getEMPLOYEES".
Here is the fault returned when invoking the web service operation:
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: org.xml.sax.SAXParseException: Premature end of file.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255060
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
