473,659 Members | 2,872 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Tool to insert from xslt to db

kk
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!
Jul 20 '05 #1
3 1720


kk wrote:
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?


I think Saxon from http://www.saxonica.com/ has an SQL extension, it for
instance documents an insert extension here:
http://www.saxonica.com/documentatio...on/insert.html
so you maybe able to use Saxon to solve that but I have never used that
extension myself.
--

Martin Honnen
http://JavaScript.FAQTs.com/
Jul 20 '05 #2
"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.

Jul 20 '05 #3
"kk" <kk***@hotmail. com> wrote in message
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!

Check the Examples link in http://servingxml.sourceforge.net/.

Regards,
Daniel Parker
Jul 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
1756
by: M Jared Finder | last post by:
I'm confused. XML looks to be extremely simple to read and write (so simple that I feel confidant I could program serialization and deserailization from a DOM document in an about an hour), yet I see many serializing tools available (Xerces and .NET's System.Xml appear to be the most popular). What functionality do these tools provide that makes them useful over rolling my own parser? -- MJF
8
2356
by: Sebastian Kerekes | last post by:
Greetings, I'm developing an application that supports multiple languages. In my XSL I use variables to place the text where it belongs to. At the top of the document I include those variables - the included file depends on the language. Atm I'm editing those file manually. Luckily atm it's only two languages I have to work with, but even in this case I forget to add a variable that I added in the other file, forget to use entities .....
2
2360
by: jkflens | last post by:
Hello, i convert one XML-document by using XSLT into another XML-document. First change all attributes to elements is no problem. Then i try to insert a new element into the new document by XSLT, but it doesn't work correctly :-( Example:
3
1738
by: Navneet Gupta | last post by:
Hi, I am a novoice developer for XML and XSLT. I need a tool which generates XSLT files. The UI should be similar to the transformation maps we create in BizTalk; it would be greate if I can host the UI in my .Net application. Or can I host BizTalks map designer in my .Net application?
3
18556
by: Mark | last post by:
I'd like an inexpensive tool that can create moderately complex XSLT files based on the mappings from one XML schema to another. I would hope that the user could click and drag attributes from one schema to the next, resulting in an XSLT document that can be manually modified as well. No additional bells and whistles are necessary. Suggestings on a tool? Thanks in advance. Mark
6
6814
by: Armel Asselin | last post by:
Hello, I'm searching for a simple command line tool to manipulate XML files. The idea would be commands such as that: xmanip-tool set /document/xpath/@name="value" remove //wrong-nodes add /document/node=\<hello\ < in.xml out.xml so, it would simple add/remove/change commands (either as arguments or input script file), a bit of xpath and the usual Unix parameters (-o output,-f
2
2931
by: Zhang Weiwu | last post by:
Hello. I am looking for a commandline tool to take an html document (or html document segment, a.k.a. without beginign "<html><head>..</head><body>") and process it by removing all css style settings and javascripts, and output a clean html/xhtml. Optionally, it would be nice if this tool can take an acceptable tag list and remove all tags not in this list. I need such a tool to process a lot of static html document I am working on....
0
1093
by: janise | last post by:
HI to all, I am a novoice developer for XML and XSLT. I need to know how to develop a tool which generates XSLT files. These tool must contain following forms in it... 1.It must contain two drop down list.In first one we have to insert all the database present in the sql server.In the second dropdown list ,suppose if the user select pubs database means we have to display all the table in the pubs database in that particular dropdown...
1
1598
by: Michael | last post by:
It seems that the xml application which is part of XMLStarlet 1.0.1 is unable to process transformations which require the id function in combination with an XSD scheme file. In my test example, id never returns anything, and the referenced node uses xs:ID for the referenced ID value and xs:IDREF for the attribute which references. Can anyone confirm the problem? Can you recommend a free Windows tool which will let me test referencing...
0
8332
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8851
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8746
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7356
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6179
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4175
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2750
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1975
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.