Thanks guys I will make the recommended change. Regards, Darryl --- Pierre CARION <[EMAIL PROTECTED]> wrote: > I had the same problem in my project : > > Just set the attribute fkcmp="false" in your cmp20 > plugin and > you will get rind of the duupliacte column error > > --- Eivind Waaler <[EMAIL PROTECTED]> wrote: > > 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 > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Web Hosting - Let the expert host your site > http://webhosting.yahoo.com > > > ------------------------------------------------------- > 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
__________________________________________________ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com ------------------------------------------------------- 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