JPA genereates non-exist id column in the select statement

[llchen]

I have the following entities:

@Entity
@Table(name="TDTGO")
@SecondaryTable(name="TDTGOR",
                pkjoincolumn...@primarykeyjoincolumn(name="DTG_OBJ_ID")})
public class VoDocumentTemplateGroupObjectData implements Serializable {
          @Id
          @Column(name="DTG_OBJ_ID")
          protected int documentTemplateGroupObjectIdentifier;
          @Column(name="DTG_OBJ_VNBR")
          protected int documentTemplateGroupObjectVersionNumber;
          @Column(name="DTG_OBJ_TCD", length=4)
          protected String documentTemplateGroupObjectTypeCode;
           ...
          @OneToMany 
          @ElementForeignKey
          @ElementJoinColumns({...@elementjoincolumn(name="DTG_OBJ_TCD"),
                                                        
@ElementJoinColumn(name="PARA_ID",
referencedColumnName="DTG_OBJ_ID"),
                                                        
@ElementJoinColumn(name="PARA_VNBR",
referencedColumnName="DTG_OBJ_VNBR")})
          protected Collection<VoParagraphData> paraObjects;
          ...
}


@Entity
@Table(name="TPARA")
public class VoParagraphData implements Serializable {

  @Column(name="PARA_ID")
  protected int paragraphIdentifier;
  @Column(name="PARA_VNBR")
  protected int paragraphVersionNumber;
  @Column(name="DTG_OBJ_TCD", length=4)
  ...
}

I always got the following SQL error:
        <openjpa-1.1.0-r422266:657916 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: DB2 SQL error: SQLCODE:
-206, SQLSTATE: 42703, SQLERRMC: T0.ID {prepstmnt 31 SELECT t0.id, 
t0.DTG_OBJ_TCD, t0.PARA_ID,  t0.PARA_TCD, t0.PARA_VNBR FROM LLLTUO#2.TPARA
t0 INNER JOIN LLLTUO#2.TDTGO t1 ON t0.DTG_OBJ_TCD = t1.DTG_OBJ_TCD AND
t0.PARA_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 statement. I badly need your help.

Thanks,

Lule
-- 
View this message in context: 
http://openjpa.208410.n2.nabble.com/JPA-genereates-non-exist-id-column-in-the-select-statement-tp5282960p5282960.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.