Well, I'm not very familiar with the airline example, but consider this: say that you have a M:N relation between flight and passenger that make up reservations. Some reservations are VIP reservations, and therefore take part in another relationship with some VIP information table (e.g. preferred color of window curtains adjacent to the reserved seat) I imagine this may cause problems, as the only (and hence primary) key to the reservations table is the compound flight/passenger combination, which is also expected to take part in another relationship.
Introducing a (logically redundant) primary key column to the reservation table makes it possible to isolate the relationships from one another. Does this make any sense? Kristoffer > Do you recall any of the details? I am getting nowhere. It seems that > every fix introduces new errors. If I make any changes to the airline > table definition, I get an error during the struts compiliation. After > I comment out the > struts items, I get errors about my beans being incomplete. > > Even if the airline sample does not work, does anyone have an example > that does compile and deploy on JBoss (preferably backed with MySQL) ? > I don't mind tweaking files or extra steps if someone knows what they > are. > > Am I beating a dead horse here trying to use middlegen with JBoss at > this time? Are efforts under way to support JBoss with MySQL? It seems > to be a common configuration. > > Thanks, > > Steve > > ----- Original Message ----- > From: "Kristoffer Moe" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, March 12, 2003 9:31 AM > Subject: Re: [Middlegen-user] cmp/cmr with jboss > > >> I've also struggled with a similar problem some time ago, and as far >> as I can remember, I introduced a workaround by adding a new PK >> column, which simply was an numeric id. This, of cource, is only >> possible if you have control over the database schema. >> >> >> Kristoffer >> >> > Hi, >> > >> > I've read in the archives someone saying to use fkcmp="false" in the >> > cmp20 plugin to go around the jboss limitation that doesn't accept a >> > field to be both CMP and CMR. (which then results in duplicate >> > column names in the create table statements) >> > Although, that doesn't work for me, since this removes attributes >> > from my beans which are both primary key for that bean and a foreign >> > key. >> > >> > Is there any other work-around for this? >> >> Mvh/regards, >> >> >> Kristoffer Moe >> Senior Consultant >> Elan It ReSource >> >> >> >> Mvh/regards, Kristoffer Moe Senior Consultant Elan It ReSource ------------------------------------------------------- This SF.net email is sponsored by:Crypto Challenge is now open! Get cracking and register here for some mind boggling fun and the chance of winning an Apple iPod: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user
