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
