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
