import org.apache.axiom.om.OMAbstractFactory;
import org.apache.axiom.om.OMElement;
import org.apache.axiom.om.OMFactory;
import org.apache.axiom.om.OMNamespace;
import org.apache.axis2.AxisFault;
import org.apache.axis2.addressing.EndpointReference;
import org.apache.axis2.client.Options;
import org.apache.axis2.client.ServiceClient;
import org.apache.axis2.transport.http.HTTPConstants;


public class StoreProcedureClient {
    public static void main(String args[]){
    	EndpointReference targetEPR = new EndpointReference(
    			"http://127.0.0.1:9762/services/StoredProcedureSampleService");
        try {
            OMElement payload = getPayload();
            Options options = new Options();
            options.setTo(targetEPR);
            options.setAction("urn:getEmployee");
            options.setProperty(HTTPConstants.CONNECTION_TIMEOUT, 10000);
            ServiceClient sender = new ServiceClient();
            
            sender.setOptions(options);
            System.out.println("Request : "+payload);
            OMElement result = sender.sendReceive(payload);
            System.out.println("Response : "+result);
        } catch (AxisFault axisFault) {
            axisFault.printStackTrace();
        }        
    }
    
    private static OMElement getPayload() {
        OMFactory fac = OMAbstractFactory.getOMFactory();
        OMNamespace omNs = fac.createOMNamespace(
                "http://ws.apache.org/axis2/xsd", "ns1");
        OMElement method = fac.createOMElement("getEmployee", omNs);
        OMElement employeeNo = fac.createOMElement("employeeNo", omNs);
        employeeNo.setText("1165");
        
        method.addChild(employeeNo);
        return method;
    }
}