At the beginning

Let's create an application that performs SOAP communication in C # and outputs the value obtained from the server to the console.

Outline of the module to be implemented

client

Let's make a simple application in C # that outputs the value obtained from the web server to the console

Web application

GlassFish on application server, application created with Java 1.8 Also, set the data source for DB connection in GlassFish.

DB server

I'm using Oracle 12c

Details of the module to be implemented

Server app implementation

`SimpleWeb.java`


package simple;

import javax.jws.WebMethod;
import javax.jws.WebService;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.ArrayListHandler;
@WebService
public class SimpleWeb {
	   
	  @WebMethod
	  public String sayHello(String name) throws Exception{
          return _sayHello(name);
	  }
	  
	  private String _sayHello(String name)throws Exception{
		  try{
			  Context ctx = new InitialContext();
	          DataSource ds = (DataSource)ctx.lookup("jdbc/oracle12c");

	          return ((new QueryRunner())
	          .query(ds.getConnection(), //Get a connection
	          		"select EMP_ID,EMP_NAME from EMP",                 //SQL zzzz to execute
	          		new ArrayListHandler())
	          .stream()
	          .filter(array->array[0].equals("001"))
	          .map(array -> String.format("Employee ID:%s:Employee name:%s",array[0],array[1]))
	          .collect(StringBuilder::new, StringBuilder::append, StringBuilder::append)
	          .toString());
		  }catch(Exception e){
			  e.printStackTrace();
			  return name;
		  }
		  
	  }
}

How to add a client (C #) service reference

1. Select Service Reference from the Visual Studio Solution Explorer and select Add Service Reference
Specify the URL of the reference destination in "Address" and press the move button.
1. Confirm that the desired Web service is displayed in the "Service" column. If you want to change the service name, change the value of "namespace",

Client implementation

`ConsoleApplication4.cs`


using System;

namespace ConsoleApplication4
{
    class Program
    {
        static void Main(string[] args)
        {
            MyWebService.SimpleWebClient client = new MyWebService.SimpleWebClient();
            Console.WriteLine(client.sayHello("test"));

        }
    }
}

Make a SOAP call in C #