RE: [Babeldoc-devel] SqlWriter stage

[Leech, J. <jl...@vi...>]

I didn't notice that you can control transaction rollback - that's a great
feature to have.  I'll also take a look at the batch capability.  I'll let
you know if I have any ideas.

-Jonathan

-----Original Message-----
From: Dejan Krsmanovic [mailto:dej...@ya...]
Sent: Sunday, August 03, 2003 11:03 AM
To: bab...@li...
Subject: [Babeldoc-devel] SqlWriter stage



--- "Leech, Jonathan" <jl...@vi...> wrote:
> Incidentally, I modified my pipeline configuration
> from this:
> XPathSplitter->XPathExtractor->SqlWriter
> to this:
> XslTransform->SqlWriter
> and it really flies.  So I used to split up the XML,
> extract values from it,
> then write each row to the database.  Now I just
> transform the XML into a
> bunch of SQL statements and run them.  Its much
> faster and it might be a
> good pattern in general.
> 
> -Jonathan

I did the same thing in pipeline configuration for one
of projects I have been working on. In fact I wrote
SqlWriter stage for that purpose. Since I had to
manage few other problems I have introduced few
properties that might be confusing at first. For
example, you can define messages that should be
returned in case of error instead of returning
database error message. I guess you have noticed that
you can control wether transaciton should be rolled
back on first error or after all statements are
executed. This was important for my project. You can
also use batch statements altough I haven't noticed
some improvements in my project when using batch
statements with different batch sizes (I am using
Oracle database).

If you have some other ideas how to improve or
simplify this class I would be glad to hear. 

Dejan



__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com


-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
Babeldoc-devel mailing list
Bab...@li...
https://lists.sourceforge.net/lists/listinfo/babeldoc-devel