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

Reply via email to