[jdom-interest] SQL join -> Structured XML

Nott, Matthias mnott at vignette.com
Thu Apr 25 03:26:44 PDT 2002

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.


-----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


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?



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



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

Philippe Lang
Attik System
To control your jdom-interest membership:

More information about the jdom-interest mailing list