aspose file tools*
The moose likes Web Services and the fly likes New records in Database table to be send to Web Service Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Web Services
Bookmark "New records in Database table to be send to Web Service" Watch "New records in Database table to be send to Web Service" New topic
Author

New records in Database table to be send to Web Service

thomas jacob
Ranch Hand

Joined: May 19, 2005
Posts: 91
I have a requirement to send any new records created in database table in XML message format to be send to a webservice. How should I go about doing this. The WS messaging mode is Document/Literal. Please help me get started.

Thanks
Ivan Krizsan
Ranch Hand

Joined: Oct 04, 2006
Posts: 2198
    
    1
Hi!
First of all, you have to decide on how to detect changes in the database. Either you have some kind of trigger in the database that invokes your program or you periodically checks for the table(s) in question modifications.
Then you need to retrieve data from the database and create XML representation of the data. Depending on what kind of web service you are going to send the data to, there are different alternatives available regarding how to create the XML.
Finally you send the data to the web service, which again is dependent on the kind of web service that is to receive the data.
Best wishes!


My free books and tutorials: http://www.slideshare.net/krizsan
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: New records in Database table to be send to Web Service
 
Similar Threads
Determined identity key value
displaying database records rowwise in the table
How to Pass a List/Map Through the iBatis to the Database?
Removing duplicate records
Doubt on Servlet having database connection?