I have to built a client, that is going to invoke a web service in order to get data from a database using a date arg. The communication is going to be async (fire and forget). The issue is that web services communicate using SOAP messages, but I have DB data. So I thought that I have to take those steps:
1. When the client is calling the web service, the DB table's data will be parsed to an XML -SOAP message file.
2. Then the service will "take" the SOAP file and "fetch" it to the client.
My problem is that I don't know if what I thought is correct. If it is correct, Sun's XML API for Java will be good enought to help me "transform" the database data to SOAP message, or there is another API that could probably help me more?