Elia Morling <eli..amiljen.se> wrote:
> > > 3. Do I need to Generate Database Schema after adding new tables to my
> > > database or is the generation
> > > only needed once?
> >
> > Generally ongoing schema synchronization is a pretty complex task.
[snip]
> > So you would have to manually change the DB, and then use the modeler to
add/remove
> > mapping objects one by one. We may better automate the last step at
> > some point...
>
> This scares me quite abit. ;) I'll be going through many changes in my DB
before I'm done...
Your two choices are almost always to either destroy and recreate tables
(optionally backing up the data between times), or manually tinker with the
database schema using the proprietary database tools. I think this
conversation came up in the last month or two, and the thought at the time
was that there would be an extreme amount of work to try to come up with
support for this for each and every database. Of course, that doesn't mean
it won't happen if someone is sufficiently motivated to implement it ... :)
> I have lots of data stored in XML that I would like to import into the
database.
> I guess I could write it myself. Just seeing if it was a feature. I think
you'll find a
> feature like that in Hibernate and Castor.
Depending on the format, you may be better off using something like DBUnit
to load your XML into your database.
While loading data from xml sometimes useful, I don't see it as part of a
database layer framework. It could possibly be an example application
using cayenne, but it seems outside of the scope of Cayenne.
This archive was generated by hypermail 2.0.0 : Sat Jun 05 2004 - 17:38:04 EDT