RE: [xsl] extension to insert XML into a db

Subject: RE: [xsl] extension to insert XML into a db
From: Mario Madunic <hajduk@xxxxxxxx>
Date: Tue, 22 Jan 2008 09:46:51 -0800
Thanks everyone for your insight. When I have a moment in the next week or so
I'll give them each a try and if I remember post the results.

Thanks again,

Marijan (Mario) Madunic

Quoting W Charlton <XSLList@xxxxxxxxxx>:

> Mario,
> This is slightly off XSL but:
> If you are using Microsoft SQL then you might want to look at
> Or 
> using the SQL OPENXML command.
> A simple example would be something like:
> SELECT    *
> FROM       OPENXML (@idoc, '/ROOT/Customer',1)
>             WITH (CustomerID  varchar(10),
>                   ContactName varchar(20))
> You can then insert or update this virtual table. 
> We do quite a lot of this and it seems very efficient but when you hit a
> problem (say trying to insert an invalid date into a Date field it is not
> easy to spot the problem.
> To make this relevant to XSL we often use XSL prior to the SQL to get the
> XML in the right structure.
> William Charlton
> The yMonda team
> yMonda Limited
> w:
> -----Original Message-----
> From: Mario Madunic [mailto:hajduk@xxxxxxxx] 
> Sent: 2008 January 21 17:05
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: [xsl] extension to insert XML into a db
> I was wondering if there is an extension that can insert XML into a db. I
> know
> of the SQL extension that comes with Saxon but it only inserts strings and
> not
> the elements. I've been creating CSV's and then using ANT with BCP to get
> content that retains elements into SQLServer. It just seems to be the long
> route.
> Marijan (Mario) Madunic

Current Thread