Have you tried using the fkcmp attribute in the cmp20 plugin? Look here for documentation:
http://boss.bekk.no/boss/middlegen/plugins/cmp20.html .eivind On Thu, 14 Nov 2002, Meyer-Willner, Bernhard wrote: > What I can tell you is that JBoss currently doesn't allow one field/column > to be a CMP and a CMR field at the same time. > > Cheers, > Bernie > > -----Ursprüngliche Nachricht----- > Von: Thompson, Darryl [mailto:Darryl.Thompson@;allegiancetelecom.com] > Gesendet: Donnerstag, 14. November 2002 18:31 > An: [EMAIL PROTECTED] > Betreff: [Middlegen-user] Duplicate columns generated with foreign key > relationships > > > > Hello, > I am using Middlegen with Oracle8 and jdk 1.4.1 EJB 2.0 CMP/CMR with > JBoss 3.0.4. When attempting to create a new entity that has oracle foreign > key columns embedded in it I get a JDBC exception stating that there are > duplicate columns present. I turned on the Log4j debugger and discovered > that for every foreign key present in the o/r mapping I have two columns > with the same name. It seems that there is one entry for the foreign key > relationship and one for the actual field being mapped (if I said that > right). Below is the run-time generated sql from the jboss/log4j debug > statement, does anyone know what should be done to correct this issue? I > could not find a match in the middlegen archive, is this a new issue? > > Thanks, > Darryl > > > INSERT INTO > COEADMIN.SALESORDER (ORDERID, > SERVICELOCATIONID, > ORDERSTATUSID, > CONTRACTDATE, > PROCESSDATE, > SALESREPID, > SALESTEAMID, > WAVEINSTALLFEE, > ICBNUMBER, > SERVICELOCATIONID, > ORDERSTATUSID, > SALESTEAMID, > SALESREPID) VALUES (?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > > > ------------------------------------------------------- > This sf.net email is sponsored by: To learn the basics of securing > your web site with SSL, click here to get a FREE TRIAL of a Thawte > Server Certificate: http://www.gothawte.com/rd524.html > _______________________________________________ > middlegen-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/middlegen-user > > This e-mail and any attachment is for authorised use by the intended recipient(s) >only. It may contain proprietary material, confidential information and/or be >subject to legal privilege. It should not be copied, disclosed to, retained or used >by, any other party. If you are not an intended recipient then please promptly >delete this e-mail and any attachment and all copies and inform the sender. Thank >you. > > > ------------------------------------------------------- > This sf.net email is sponsored by: To learn the basics of securing > your web site with SSL, click here to get a FREE TRIAL of a Thawte > Server Certificate: http://www.gothawte.com/rd524.html > _______________________________________________ > middlegen-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/middlegen-user > ------------------------------------------------------- This sf.net email is sponsored by: To learn the basics of securing your web site with SSL, click here to get a FREE TRIAL of a Thawte Server Certificate: http://www.gothawte.com/rd524.html _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user
