I need to create a web service which can connect to database to retrieve a result-set and respond back in
Which is the best way in terms of scalability & speed of development to achieve the above?
And also i should be able to generate client code without
Axis automatically in
Eclipse by using the
WSDL of the web-service I create.
Please point me to some good, complete tutorials.
First, do you need SOAP, is it in your requirements? If not, consider using REST via JAX-RX (Jersey), JAXB, and JPA for the database; I've had phenomenal results.
A tutoiral for the XML part (Jaxb)
Another tutorial for more details.
a quick overview about jax ws
In general you load your data as beans with jpa/hibernate but add xml annotations for the automatic marshelling/unmarshelling to build the response xml.
The rest is done (the transmission and the incoming call) with jax ws. Normally you only have to implement the endpoint, the rest can be generated by the wsdl.
Step by step: