<< I am working for transforming XML data to relational database. But there is some difficulty. Here anyone who is working or know about the matter? May any one give me some suggestion or resource? Oracle, Informix, and IBM DB2 include XML "plug-ins" that add types and behavior for operating with XML. When integrating XML with any SQL database, you must make a fundamental decision whether so store a document in its entirety in a column, or shred it and store the data in multiple columns. For an example of Java code that reads an XML file and does an SQL INSERT into a column, read "Oracle 8: Powered by Java and XML". A second example is code that shows how to SELECT a column containing an XML document, and write it out as an XML file. http://www.xmlmag.com/upload/free/features/xml/1999/01win99/knwin99/knwin99. asp The code works for Oracle, but it uses JDBC, so it will require only minor modifications to work with another DBMS (modify the connection string, and modify the column types for the INSERT). ========== Ken North ====================== See you at XML DevCon 2001 London (February 21-23) New York (April 8-11) http://www.xmldevcon2001.com ======================================= ------ XML/edi Group Discussion List ------ Homepage = http://www.XMLedi-Group.org Unsubscribe = send email to: [EMAIL PROTECTED] Leave the subject and body of the message blank Questions/requests: [EMAIL PROTECTED] To receive only one message per day (digest format) send the following message to [EMAIL PROTECTED], (leave the subject line blank) digest xmledi-group your-email-address To join the XML/edi Group complete the form located at: http://www.xmledi-group.org/xmledigroup/mail1.htm --------------------------------------------------------------------- Plan on attending the upcoming meeting during DISA's conference: http://www.disa.org/conference/annual_conf/index.htm
