Parsing XML out of a DB-blob-field

[Mathias Wiegard <wi...@ceronic.de>]

Hi,
I have to write a generator to convert data of an relational db to a special
xml-language. In the database are blob-fields that already contain correct
xml-code. Is there any helping component in cocoon, avalon, etc. which
accepts a String as source to generate SAX-Events to a XML-Consumer? I
additional need the possibility to add the same namespace to all these
elements...
Thanks in advance for every help,
Mat

Re: Parsing XML out of a DB-blob-field

[Torsten Curdt <tc...@vafer.org>]

Mathias Wiegard wrote:
> Hi,
> I have to write a generator to convert data of an relational db to a special
> xml-language. In the database are blob-fields that already contain correct
> xml-code. Is there any helping component in cocoon, avalon, etc. which
> accepts a String as source to generate SAX-Events to a XML-Consumer? I
> additional need the possibility to add the same namespace to all these
> elements...

Have a look into esql. esql:get-xml should be what you are looking for.

cheers
--
Torsten

Re: Parsing XML out of a DB-blob-field

[Sylvain Wallez <sy...@anyware-tech.com>]

Mathias Wiegard wrote:

>Hi,
>I have to write a generator to convert data of an relational db to a special
>xml-language. In the database are blob-fields that already contain correct
>xml-code. Is there any helping component in cocoon, avalon, etc. which
>accepts a String as source to generate SAX-Events to a XML-Consumer? I
>additional need the possibility to add the same namespace to all these
>elements...
>Thanks in advance for every help,
>Mat
>

You should take a look at the BlobSource in the database block : this 
may be just what you need.

Sylvain

-- 
Sylvain Wallez                                  Anyware Technologies
http://www.apache.org/~sylvain           http://www.anyware-tech.com
{ XML, Java, Cocoon, OpenSource }*{ Training, Consulting, Projects }
Orixo, the opensource XML business alliance  -  http://www.orixo.com