"kk" <kk***@hotmail.com> wrote in news:30*************@uni-berlin.de:
I have an xml file and write an xslt. Now I want to insert related
elements from xslt to db directly for various data types. How can I do?
Is there any existing tool for this? Thanks!
The uPortal project (
www.uportal.org) uses a tool called DbLoader which
reads a tables.xml for creating the database tables and data.xml for
inserting records. It's written in java and has several hooks into the
uPortal code (basically for logging and obtaining database connections) but
you could probably learn something from it. If I recall there was also an
open source product called Torque that did database loads from xml files.
The jakarta Ant build tool also has a "sql" task that will create and
populate a database from an xml file.