jQuery in Action, 2nd edition*
The moose likes Web Services and the fly likes Expose DB as a webservie Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Web Services
Bookmark "Expose DB as a webservie" Watch "Expose DB as a webservie" New topic
Author

Expose DB as a webservie

Alex Shpurov
Greenhorn

Joined: Mar 29, 2005
Posts: 3
Hi guys,

Very ofter web service works as an interface (limited or full) to DB, and basically the goal of web service is to update the db from request and/or send the response from DB as well.
The purpose of WS in this situation is to map incoming XML to SQL statment(e.g using XSLT).
One of the solution I know is Sonic Integration workbench but it's too expensive and very heavy.

I would see it as a simple Axis or Xfire application having XSD for SQL resultset and some mapping between incoming and outgoing XML and DB resultset's XML

I wounder if somebody uses any solution like this?

Thanks
 
GeeCON Prague 2014
 
subject: Expose DB as a webservie