<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [jdom-interest] SQL join -> Structured XML</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Transforming XML to db might follow the standard</FONT>
<BR><FONT SIZE=2>object model to ER conversion. so by establishing</FONT>
<BR><FONT SIZE=2>a schema which has one to one relationship with</FONT>
<BR><FONT SIZE=2>ER tables, we might able to convert from db to</FONT>
<BR><FONT SIZE=2>xml and from xml to db back. What Phillippe has done</FONT>
<BR><FONT SIZE=2>might be useful in search. it would be great if he </FONT>
<BR><FONT SIZE=2>can share the code.</FONT>
</P>
<P><FONT SIZE=2>mani</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Nott, Matthias [<A HREF="mailto:mnott@vignette.com">mailto:mnott@vignette.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, April 25, 2002 3:57 PM</FONT>
<BR><FONT SIZE=2>To: Philippe Lang; jdom-interest@jdom.org</FONT>
<BR><FONT SIZE=2>Subject: RE: [jdom-interest] SQL join -> Structured XML</FONT>
</P>
<BR>
<P><FONT SIZE=2>goes sort of the direction of program generators,</FONT>
<BR><FONT SIZE=2>if you want to reimport xml into the db by transforming</FONT>
<BR><FONT SIZE=2>your xml into e.g. stored proc calls. There's quite a lot</FONT>
<BR><FONT SIZE=2>of material around on that.</FONT>
</P>
<P><FONT SIZE=2>M</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Philippe Lang [<A HREF="mailto:philippe.lang@attiksystem.ch">mailto:philippe.lang@attiksystem.ch</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, April 25, 2002 8:18 AM</FONT>
<BR><FONT SIZE=2>To: jdom-interest@jdom.org</FONT>
<BR><FONT SIZE=2>Subject: [jdom-interest] SQL join -> Structured XML</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi,</FONT>
</P>
<P><FONT SIZE=2>I have written a set of classes that take as input the result of an SQL</FONT>
<BR><FONT SIZE=2>query, with joined tables. Given some parameters you give to the classes</FONT>
<BR><FONT SIZE=2>(groups, sort order...), very similar to what you can configure in</FONT>
<BR><FONT SIZE=2>Access or Crystal Reports, it outputs an XML file, with the same data,</FONT>
<BR><FONT SIZE=2>but in a structured way. It works with any number of joins.</FONT>
</P>
<P><FONT SIZE=2>I wonder if it would be a good idea to incorporate these classes in</FONT>
<BR><FONT SIZE=2>JDOM? Or does that go beyond the scope of JDOM?</FONT>
</P>
<BR>
<P><FONT SIZE=2>Example:</FONT>
<BR><FONT SIZE=2>--------</FONT>
</P>
<P><FONT SIZE=2>(CachedRowSet)</FONT>
</P>
<P><FONT SIZE=2>A P1 P2</FONT>
<BR><FONT SIZE=2>A P3 P4</FONT>
<BR><FONT SIZE=2>A P5 P6</FONT>
<BR><FONT SIZE=2>B P7 P8</FONT>
<BR><FONT SIZE=2>B P9 P10</FONT>
<BR><FONT SIZE=2>A P11 P12</FONT>
<BR><FONT SIZE=2>C P13 P14</FONT>
</P>
<P><FONT SIZE=2>gives...</FONT>
</P>
<BR>
<P><FONT SIZE=2>(XML)</FONT>
</P>
<P><FONT SIZE=2>----- A ----- P1 P2</FONT>
<BR><FONT SIZE=2> | |-- P3 P4</FONT>
<BR><FONT SIZE=2> | |-- P5 P6</FONT>
<BR><FONT SIZE=2> | |-- P11 P12</FONT>
<BR><FONT SIZE=2> |</FONT>
<BR><FONT SIZE=2> |- B ----- P7 P8</FONT>
<BR><FONT SIZE=2> | |-- P9 P10</FONT>
<BR><FONT SIZE=2> |</FONT>
<BR><FONT SIZE=2> |- C ----- P13 P14</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>-------------------------</FONT>
<BR><FONT SIZE=2>Philippe Lang</FONT>
<BR><FONT SIZE=2>Attik System</FONT>
<BR><FONT SIZE=2><A HREF="http://www.attiksystem.ch" TARGET="_blank">http://www.attiksystem.ch</A> </FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>To control your jdom-interest membership:</FONT>
<BR><FONT SIZE=2><A HREF="http://lists.denveronline.net/mailman/options/jdom-interest/youraddr@yourhos" TARGET="_blank">http://lists.denveronline.net/mailman/options/jdom-interest/youraddr@yourhos</A></FONT>
<BR><FONT SIZE=2>t.com</FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>To control your jdom-interest membership:</FONT>
<BR><FONT SIZE=2><A HREF="http://lists.denveronline.net/mailman/options/jdom-interest/youraddr@yourhost.com" TARGET="_blank">http://lists.denveronline.net/mailman/options/jdom-interest/youraddr@yourhost.com</A></FONT>
</P>
</BODY>
</HTML>