[jdom-interest] SQL join -> Structured XML

[Mani Doraisamy]

Transforming XML to db might follow the standard
object model to ER conversion. so by establishing
a schema which has one to one relationship with
ER tables, we might able to convert from db to
xml and from xml to db back. What Phillippe has done
might be useful in search. it would be great if he 
can share the code.

mani

-----Original Message-----
From: Nott, Matthias [mailto:mnott at vignette.com]
Sent: Thursday, April 25, 2002 3:57 PM
To: Philippe Lang; jdom-interest at jdom.org
Subject: RE: [jdom-interest] SQL join -> Structured XML


goes sort of the direction of program generators,
if you want to reimport xml into the db by transforming
your xml into e.g. stored proc calls. There's quite a lot
of material around on that.

M

-----Original Message-----
From: Philippe Lang [mailto:philippe.lang at attiksystem.ch]
Sent: Thursday, April 25, 2002 8:18 AM
To: jdom-interest at jdom.org
Subject: [jdom-interest] SQL join -> Structured XML


Hi,

I have written a set of classes that take as input the result of an SQL
query, with joined tables. Given some parameters you give to the classes
(groups, sort order...), very similar to what you can configure in
Access or Crystal Reports, it outputs an XML file, with the same data,
but in a structured way. It works with any number of joins.

I wonder if it would be a good idea to incorporate these classes in
JDOM? Or does that go beyond the scope of JDOM?


Example:
--------

(CachedRowSet)

A        P1   P2
A        P3   P4
A        P5   P6
B        P7   P8
B        P9   P10
A        P11  P12
C        P13  P14

gives...


(XML)

----- A ----- P1   P2
   |      |-- P3   P4
   |      |-- P5   P6
   |      |-- P11  P12
   |
   |- B ----- P7   P8
   |      |-- P9   P10
   |
   |- C ----- P13  P14



-------------------------
Philippe Lang
Attik System
http://www.attiksystem.ch 
_______________________________________________
To control your jdom-interest membership:
http://lists.denveronline.net/mailman/options/jdom-interest/youraddr@yourhos
t.com
_______________________________________________
To control your jdom-interest membership:
http://lists.denveronline.net/mailman/options/jdom-interest/youraddr@yourhos
t.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://jdom.org/pipermail/jdom-interest/attachments/20020425/7cfb3f14/attachment.htm