Can't extract a master key exception

2011-10-12 Thread Joseph Senecal
I'm getting a strange exception when adding a detail record in the same commit as the master record. Both the master and detail records are defined in Oracle as having a primary key consisting of the surrogate key plus “SUBMITDATE”. The Cayenne map shows the primary key is just the surrogate ke

Re: Unique Index Constraints in Cayenne Modeler

2011-10-12 Thread Mike Kienenberger
On Wed, Oct 12, 2011 at 4:13 AM, Durchholz, Joachim wrote: > 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

RE: Unique Index Constraints in Cayenne Modeler

2011-10-12 Thread Durchholz, Joachim
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 th