Hi Tak, it depends on your project. The SQLTransformer is the easiest to use but you're bound to the specific SQL dialect of the query you're writing and you have to think more about stuff like SQL injection. You can use Hibernate or JPOX to make your queries work on multiple database flavours and get safer querying but that takes more time for the setup of your project. Regards,
Jasha Joachimsthal [email protected] - [email protected] www.onehippo.com <http://www.onehippo.com/> Amsterdam - Hippo B.V. Oosteinde 11 1017 WT Amsterdam +31(0)20-5224466 San Francisco - Hippo USA Inc. 101 H Street, suite Q Petaluma CA 94952-5100 +1 (707) 773-4646 ________________________________ From: Tak-po Li [mailto:[email protected]] Sent: woensdag 7 januari 2009 3:44 To: [email protected] Subject: Re: Using cocoon pipeline for import Hi Jasha, If I am interested in xml-relational mapping only, should I use SQLtransformer or Hibernate? Thanks, Tak On Tue, Jan 6, 2009 at 9:12 AM, Jasha Joachimsthal <[email protected]> wrote: Mathias, you won't have to write your own serializer but you can use the SQLtransformer [1]. [1] http://cocoon.apache.org/2.1/userdocs/sql-transformer.html Jasha -----Oorspronkelijk bericht----- Van: Mathias Reem [mailto:[email protected]] Verzonden: di 6-1-2009 14:42 Aan: [email protected] Onderwerp: Using cocoon pipeline for import Hi I've got to fetch some XML data from an external webserver, preprocess it - using XSLT - and store the result in our database. At the moment this is done by a shellscript. As this shall now be integrated to our application, I was wandering if using a cocoon pipeline for this task would be feasible, or a really bad idea? As far as I can see. I would only have to write my own Serializer, which instead of writing stuff to an OutputStream would commit the data to the database. Any comment is welcome. Mathias --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
