File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Expose DB as a webservie

Alex Shpurov

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?

I agree. Here's the link:
subject: Expose DB as a webservie
jQuery in Action, 3rd edition