Supraja Kannaiyan wrote:I would like to develop a webservice in Java.
So you have chosen the implementation platform for your service (but not: (1) the version of Java (which may limit the web service platform that you can use), (2) the web service technology (
SOAP, XML(or JSON) over HTTP, XML-RPC, RESTful etc.) or even (3) the web service platform (Axis, Axis2, Apache CXF, JAX-WS RI, Jersey, Restlet, etc.).
It Should access the data from the SQL Server database and return the data based on the parameter passed by the client.
That is what you want to do inside the service and hopefully want to "hide" from the service consumer.
What about the "requirements" of the service consumer? The service has no reason for existing without its service consumers. Is there only one single consumer? Are there many consumers? Are there many consumer types? Are the consumers accessing the service across an intranet, across firewalls, across the internet? What data format (or media types) can the service consumers "consume" (text, XML, JSON, SOAP (rpc/encoded, rpc/literal, document/literal), etc.). What kind of security is needed (user authentication, transport level security, message level security, etc.) ?
Are there any other constraints that you are working against?