users@jersey.java.net

Re: Does CRUD Web-Service for RDBMS can be created easily?

From: Paul Sandoz <Paul.Sandoz_at_Sun.COM>
Date: Thu, 24 Apr 2008 09:15:40 +0200

On Apr 23, 2008, at 9:57 PM, Andrey Siver wrote:

> Hello,
>
> I'm newbie in Jersey and Web-Services...
>

Welcome to the list.


> As I could see, with help of RESTful one can easily create a Web-
> Service, which will be show the content of RDBMS (such as MySQL or
> Oracle).
>

Yes.


> But is it possible to do inserts or update to DB via this Web-Service?
>

I guess it depends on what exactly you want to insert or update. You
may want to take a look a the NetBeans RESTful Web services plugin
that directly exposes DB tables/rows as read/write resources. It uses
Jersey and generates resource classes that know how to perform
queries, using JPA, and map entity beans to JAXB beans (with links)
to other resources.


> I'm thinking about the possibility of using XQuery language for
> processing data in Oracle DB via Web-Service ...
>

I don't know much about XQuery, but it potentially could ease the XML
translation step of creating a XML representation, but i would
presume guess you would still need to translate some information in
the XQuery result from identifiers to URIs.

You may be able to experiment without using a database using Nux [1].

Paul.

[1] http://dsd.lbl.gov/nux/

>
> Regards,
>
> -Andrey