Hi Jasha, Thanks for the information. In my application, xml could be 20 level in depth. The database has many-to-many relations. I wonder whether this reaches the limitation of SQLTransformer.
I understand the licenses of JPOX and Hibernate are different. Besides that, what is their strength and weakness? Thanks, Tak On Wed, Jan 7, 2009 at 3:19 AM, Jasha Joachimsthal < [email protected]> wrote: > 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 > 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] >> > >
