John Huss wrote: > I'd say it not essential. If a N:1 relationship is based on a UK that's not known to Cayenne, Cayenne will be forced to assume an N:M relationship. This means that on the N side, the Java object will have a Set instead of a simple reference.
I'd consider stuff that affects the Java classes quite essential. > In any project of decent size you're likely to have SOME > additional sql to execute to set up your database, be it > creating views or functions or triggers or indexes. Setting up a new database actually is not relevant in the vast majority of projects. See, there's a HUGE number of programmers who do in-house development. The typical scenario for them is "the" database, which is updated with triggers and views and indexes as the need arises. Maintaining a set of scripts so that it remains consistent with the database would be just a waste of effort. It is unlikely that they'd ever need such scripts anyway: the ability to create an empty database would be worthless to the company, it needs the data. Regards, Jo
