Cocoon's capabilities - XML to PostgreSQL ?

["Jim C." <jl...@gmail.com>]

I've got a large XML file, say 15 Mb and I need to get it into a
PostgreSQL database. Can Cocoon do this? If so, I could sure use some tips.

RTFM'ers Note: I am reading the docs now. Perhaps you could direct me to
relevant sections? :-)


Jim C.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

Re: Cocoon's capabilities - XML to PostgreSQL ?

[Bertrand Delacretaz <bd...@apache.org>]

On 1/25/07, Jim C. <jl...@gmail.com> wrote:
> I've got a large XML file, say 15 Mb and I need to get it into a
> PostgreSQL database. Can Cocoon do this?...

It could, but if it's a one-time job, I'd go for generating SQL
statements by transforming your XML with XSLT:

  XML file -> XSLT transform -> SQL statements file -> execute SQL in DB

Or use any other XML transformation method that you're familiar with
instead of XSLT.

In Cocoon, you could do the same but generate SQLTransformer
statements instead of a plain SQL statements file:

  XML file -> XSLT transform using SQLTransformer syntax -> SQLTransformer

HTH,
-Bertrand

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org