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

Reply via email to