Re: JPA genereates non-exist id column in the select statement

2010-07-14 Thread llchen
well. Thanks for your suggestions. Lule -- View this message in context: http://openjpa.208410.n2.nabble.com/JPA-genereates-non-exist-id-column-in-the-select-statement-tp5282960p5293877.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: JPA genereates non-exist id column in the select statement

2010-07-13 Thread Fay Wang
You can try @PersistentCollection - Original Message From: llchen To: users@openjpa.apache.org Sent: Tue, July 13, 2010 10:22:57 AM Subject: Re: JPA genereates non-exist id column in the select statement Sorry I forgot to mention that I am using JPA 1.0 and therefore I can'

Re: JPA genereates non-exist id column in the select statement

2010-07-13 Thread Fay Wang
: http://openjpa.208410.n2.nabble.com/JPA-genereates-non-exist-id-column-in-the-select-statement-tp5282960p5286901.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: JPA genereates non-exist id column in the select statement

2010-07-13 Thread llchen
Sorry I forgot to mention that I am using JPA 1.0 and therefore I can't use @ElementCollection tag. Lule -- View this message in context: http://openjpa.208410.n2.nabble.com/JPA-genereates-non-exist-id-column-in-the-select-statement-tp5282960p5288555.html Sent from the OpenJPA Users ma

Re: JPA genereates non-exist id column in the select statement

2010-07-13 Thread llchen
://openjpa.208410.n2.nabble.com/JPA-genereates-non-exist-id-column-in-the-select-statement-tp5282960p5286901.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: JPA genereates non-exist id column in the select statement

2010-07-12 Thread Fay Wang
n(name="PARA_ID", referencedColumnName="DTG_OBJ_ID"), @JoinColumn(name="PARA_VNBR", referencedColumnName="DTG_OBJ_VNBR") } ) protected Collection paraObjects; ----- Original Message ---- From: llchen To: users@openjpa.apache.

Re: JPA genereates non-exist id column in the select statement

2010-07-12 Thread Fay Wang
@JoinColumn(name="PARA_VNBR", referencedColumnName="DTG_OBJ_VNBR") } ) protected Collection paraObjects; - Original Message From: llchen To: users@openjpa.apache.org Sent: Mon, July 12, 2010 3:51:45 PM Subject: RE: JPA genereates non-exist id colum

RE: JPA genereates non-exist id column in the select statement

2010-07-12 Thread llchen
: Monday, July 12, 2010 10:53 AM To: llchen Subject: Re: JPA genereates non-exist id column in the select statement Section 2.4 of the 2.0 spec states "Every entity must have a primary key." I seem to remember that OpenJPA will do some magic when we enhance your Entities if we don

Re: JPA genereates non-exist id column in the select statement

2010-07-12 Thread Rick Curtis
Section 2.4 of the 2.0 spec states "Every entity must have a primary key." I seem to remember that OpenJPA will do some magic when we enhance your Entities if we don't find an @Id column... I don't have time to try this am, but I'd be willing to bet that is what's going on. tht, Rick

JPA genereates non-exist id column in the select statement

2010-07-12 Thread llchen
ID = t1.DTG_OBJ_ID AND t0.PARA_VNBR = t1.DTG_OBJ_VNBR WHERE t1.DTG_OBJ_ID = ? [params=(int) 3009]} [code=-206, state=42703]SQLCA OUTPUT[Errp=DSNXORSO, Errd=-600, 0, 0, -1, 0, 0] There is no ID column in any of the tables and I just can't figure out why the JPA genereates that in its SQL select