Also, here is the code on their end. They're using a vector of hashmaps which translates to an array of structures in cf which is what I'm passing:


protected static void doCC3DataOp(AMMOService port) throws
RemoteException {
     Vector list = new Vector();
     HashMap map = new HashMap();
     map.put("p_process_id", new Integer(12345));
     map.put("p_mailing_cd", "cc3");
     map.put("p_mailing_stat", "C");
     map.put("p_sch_vendor_id", new Integer(102536));
     map.put("p_mail_vendor_nm", "CC3");
     map.put("p_mail_system", "AMMO");
     map.put("p_single_pln_id", new Integer(900001201));
     map.put("p_multi_pln_id_1", null);
     map.put("p_multi_pln_id_2", null);
     map.put("p_multi_pln_id_3", null);
     map.put("p_plan_year", new Integer(2003));
     map.put("p_template_cd", new Integer(3));
     map.put("p_delivery_pop", "undergrad");
     map.put("p_shipment_meth_cd", "Ground");
     map.put("p_mail_type", "UPS");
     map.put("p_addr_file_id", new Integer(121212));
     map.put("p_logo_id", new Integer(11111));
     map.put("p_signature_id", null);
     map.put("p_corner_card_id", new Integer(326476));
     map.put("p_qty_mailed", new Integer(1000));
     map.put("p_ship_to_title", null);
     map.put("p_ship_to_nm", "Columbia U");
     map.put("p_ship_to_addr1", "1 AMS Pl");
     map.put("p_ship_to_addr2", null);
     map.put("p_ship_to_addr3", null);
     map.put("p_ship_to_city", "Swansea");
     map.put("p_ship_to_state", "MA");
     map.put("p_ship_to_postal_cd", "02777");
     map.put("p_batch_num", new Integer(1234));
     map.put("p_print_date", "21-OCT-03");
     map.put("p_in_hand_date", "01-NOV-03");
     map.put("p_mail_date", "21-OCT-03");


     list.add(map);
     String response = port.dataFromCC3(list);
     System.out.println(response);
     map = null;
     list = null;
     }


Here is the cfm page that calls the web service:


<cfset processedOrdersArray = arrayNew(1)>
   
      <cfset processedOrdersArray[1] = structNew()>
      <cfset processedOrdersArray[1].p_process_id = "1234">
      <cfset processedOrdersArray[1].p_mailing_cd = "CC3">
      <cfset processedOrdersArray[1].p_mailing_stat = "C">
      <cfset processedOrdersArray[1].p_sch_vendor_id = "88888">
      <cfset processedOrdersArray[1].p_mail_vendor_nm = "CC3">
      <cfset processedOrdersArray[1].p_mail_system = "AMMO">
      <cfset processedOrdersArray[1].p_single_pln_id = 0>
      <cfset processedOrdersArray[1].p_multi_pln_id_1 = "800012345">
      <cfset processedOrdersArray[1].p_multi_pln_id_2 = "800012345">
      <cfset processedOrdersArray[1].p_multi_pln_id_3 = "800012345">
      <cfset processedOrdersArray[1].p_plan_year = "2005">
      <cfset processedOrdersArray[1].p_template_cd = "27">
      <cfset processedOrdersArray[1].p_delivery_pop = "Students">
      <cfset processedOrdersArray[1].p_shipment_meth_cd = "Ground">
      <cfset processedOrdersArray[1].p_mail_type = "Financial Aid">
      <cfset processedOrdersArray[1].p_addr_file_id = "900030972">
      <cfset processedOrdersArray[1].p_logo_id = "12345">
      <cfset processedOrdersArray[1].p_signature_id = "12345">
      <cfset processedOrdersArray[1].p_corner_card_id = "12345">
      <cfset processedOrdersArray[1].p_qty_mailed = "1000">
      <cfset processedOrdersArray[1].p_ship_to_title = "Programmer">
      <cfset processedOrdersArray[1].p_ship_to_nm = "Mark Stewart">
      <cfset processedOrdersArray[1].p_ship_to_addr1 = "1044 Pulinski Rd.">
      <cfset processedOrdersArray[1].p_ship_to_addr2 = "">
      <cfset processedOrdersArray[1].p_ship_to_addr3 = "">
      <cfset processedOrdersArray[1].p_ship_to_city = "Ivyland">
      <cfset processedOrdersArray[1].p_ship_to_state = "PA">
      <cfset processedOrdersArray[1].p_ship_to_postal_cd = "18974">
      <cfset processedOrdersArray[1].p_batch_num = "320">
      <cfset processedOrdersArray[1].p_print_date = "13-NOV-03">
      <cfset processedOrdersArray[1].p_in_hand_date = "01-DEC-03">
      <cfset processedOrdersArray[1].p_mail_date = "14-NOV-03">
      
      <cfdump var="#processedOrdersArray#">


<cfinvoke webservice=" http://xxx.xxx.com/xxx?wsdl" method="dataFromCC3" returnvariable="aString">
     <cfinvokeargument name="in0" value="#processedOrdersArray#"/>
    </cfinvoke>
   
<cfoutput>Result: #aString#</cfoutput>
-----Original Message-----
From: Mark Stewart
Sent: Friday, November 21, 2003 9:44 AM
To: CF-Talk
Subject: Web Service Error

I'm getting the following error when I try to call a web service from a client of ours:

Could not perform web service invocation "dataFromCC3" because AxisFault faultCode: {http://xml.apache.org/axis/}Server.userException faultSubcode: faultString: java.lang.Exception: 0: An Error occured attempting to call procedure -- Unknown error occured in applyValuesToStatement: null faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace: java.lang.Exception: 0: An Error occured attempting to call procedure -- Unknown error occured in applyValuesToStatement: null at com.xxx.xxx.services.AMMOService.dataFromCC3(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:372) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:292) at org.apache.axis.providers.java.JavaProvid...

I have no idea what this means. There are several other services that we call from our client, but all of them pass information back to us. The error above is for a service where we pass data to them. They're using Java and, of course, we're using cf.

Any insight would be greatly appreciated.

Mark

  _____  


[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to