thanks Bruce for your reply - agree but JDOM seems more of a standard way of doing this right now
Thomas -----Original Message----- From: Bruce Snyder [mailto:[EMAIL PROTECTED]] Sent: 25 April 2002 14:12 To: [EMAIL PROTECTED] Subject: Re: [castor-dev] XML feed to RDBMS This one time, at band camp, Curley, Thomas said: CT>Hi all - Keith suggested I post this msg as its a common business requirment :- CT> CT>I am wondering if anyone has ideas about or ideally experience with loading XML data to an Oracle 9i DB. CT> CT>The data structure I wish to populate conists of about 10 tables with the usual constraints and relationships. I would hope to model this in an XML schema and then receive valid XML files based on this. CT> CT>I then wish to load this XML to the DB - populating the right tables. I would like the XML to look as business like as possible. CT> CT>Does anyone know of a tool or API I can use to help with this - I appreciate that its possible to write a java process with wraps JDOM calls. Any other ideas please ? Curley, Take a look at Castor itself. Castor JDO uses XML files on the file system and marshalls them into Java objects to make use of the data. This all happens by way of Castor XML. There's no reason you couldn't use a similar process. Accept XML files that are marshalled into Java objects whose data is used to populate the database. Bruce -- perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");' ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
