This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Expose DB as a webservie

 
Alex Shpurov
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic