Meyer-Willner, Bernhard
2002-11-14 15:39:06 UTC
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:***@allegiancetelecom.com]
Gesendet: Donnerstag, 14. November 2002 18:31
An: middlegen-***@lists.sourceforge.net
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
middlegen-***@lists.sourceforge.net
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.
to be a CMP and a CMR field at the same time.
Cheers,
Bernie
-----Ursprüngliche Nachricht-----
Von: Thompson, Darryl [mailto:***@allegiancetelecom.com]
Gesendet: Donnerstag, 14. November 2002 18:31
An: middlegen-***@lists.sourceforge.net
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
middlegen-***@lists.sourceforge.net
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.