From: <glassfish_at_javadesktop.org>
Date: Tue, 26 Jun 2007 01:10:55 PDT

Hi, I will like to request for your help on the above problem. Can anyone tell me what is this exception is about?

Thank you very much

Clement


Here is the message that I get:
Exception Description: Unknown state or association field [projectNoSub] of class [database.SfcWip].

Here is the entity class generated by NetBean:

@Entity
@Table(name = "SFC_WIP")
@NamedQueries( {
        @NamedQuery(name = "SfcWip.findByProjectNoSub", query = "SELECT s FROM SfcWip s WHERE s.sfcWipPK.projectNoSub = :projectNoSub"),
        @NamedQuery(name = "SfcWip.findByPcbPartNo", query = "SELECT s FROM SfcWip s WHERE s.sfcWipPK.pcbPartNo = :pcbPartNo"),
        @NamedQuery(name = "SfcWip.findByPcbQty", query = "SELECT s FROM SfcWip s WHERE s.pcbQty = :pcbQty"),
        @NamedQuery(name = "SfcWip.findByFlowId", query = "SELECT s FROM SfcWip s WHERE s.flowId = :flowId"),
        @NamedQuery(name = "SfcWip.findByStatus", query = "SELECT s FROM SfcWip s WHERE s.status = :status"),
        @NamedQuery(name = "SfcWip.findByRemarks", query = "SELECT s FROM SfcWip s WHERE s.remarks = :remarks")
    })
public class SfcWip implements Serializable {

    /**
     * EmbeddedId primary key field
     */
    @EmbeddedId
    protected SfcWipPK sfcWipPK;

    @Column(name = "PCB_QTY")
    private BigDecimal pcbQty;

    @Column(name = "FLOW_ID")
    private String flowId;

    @Column(name = "STATUS")
    private String status;

    @Column(name = "REMARKS")
    private String remarks;

    @OneToMany(cascade = CascadeType.ALL, mappedBy = "sfcWip")
    private Collection<SfcWiptran> sfcWiptranCollection;
    
    /** Creates a new instance of SfcWip */
    public SfcWip() {
    }

    public SfcWip(SfcWipPK sfcWipPK) {
        this.sfcWipPK = sfcWipPK;
    }

    public SfcWip(String pcbPartNo, String projectNoSub) {
        this.sfcWipPK = new SfcWipPK(pcbPartNo, projectNoSub);
    }

    public SfcWipPK getSfcWipPK() {
        return this.sfcWipPK;
    }

    public void setSfcWipPK(SfcWipPK sfcWipPK) {
        this.sfcWipPK = sfcWipPK;
    }

    public BigDecimal getPcbQty() {
        return this.pcbQty;
    }

    public void setPcbQty(BigDecimal pcbQty) {
        this.pcbQty = pcbQty;
    }

    public String getFlowId() {
        return this.flowId;
    }

    public void setFlowId(String flowId) {
        this.flowId = flowId;
    }

    public String getStatus() {
        return this.status;
    }

    public void setStatus(String status) {
        this.status = status;
    }

    public String getRemarks() {
        return this.remarks;
    }

    public void setRemarks(String remarks) {
        this.remarks = remarks;
    }

    public Collection<SfcWiptran> getSfcWiptranCollection() {
        return this.sfcWiptranCollection;
    }

    public void setSfcWiptranCollection(Collection<SfcWiptran> sfcWiptranCollection) {
        this.sfcWiptranCollection = sfcWiptranCollection;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (this.sfcWipPK != null ? this.sfcWipPK.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof SfcWip)) {
            return false;
        }
        SfcWip other = (SfcWip)object;
        if (this.sfcWipPK != other.sfcWipPK && (this.sfcWipPK == null || !this.sfcWipPK.equals(other.sfcWipPK))) return false;
        return true;
    }

     @Override
    public String toString() {
        return "database.SfcWip[sfcWipPK=" + sfcWipPK + "]";
    }
    
}


@Embeddable
public class SfcWipPK implements Serializable {

    @Column(name = "PROJECT_NO_SUB", nullable = false)
    private String projectNoSub;

    @Column(name = "PCB_PART_NO", nullable = false)
    private String pcbPartNo;
    
    /** Creates a new instance of SfcWipPK */
    public SfcWipPK() {
    }

    public SfcWipPK(String pcbPartNo, String projectNoSub) {
        this.pcbPartNo = pcbPartNo;
        this.projectNoSub = projectNoSub;
    }

    public String getProjectNoSub() {
        return this.projectNoSub;
    }

    public void setProjectNoSub(String projectNoSub) {
        this.projectNoSub = projectNoSub;
    }

    public String getPcbPartNo() {
        return this.pcbPartNo;
    }

    public void setPcbPartNo(String pcbPartNo) {
        this.pcbPartNo = pcbPartNo;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (this.pcbPartNo != null ? this.pcbPartNo.hashCode() : 0);
        hash += (this.projectNoSub != null ? this.projectNoSub.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof SfcWipPK)) {
            return false;
        }
        SfcWipPK other = (SfcWipPK)object;
        if (this.pcbPartNo != other.pcbPartNo && (this.pcbPartNo == null || !this.pcbPartNo.equals(other.pcbPartNo))) return false;
        if (this.projectNoSub != other.projectNoSub && (this.projectNoSub == null || !this.projectNoSub.equals(other.projectNoSub))) return false;
        return true;
    }

    @Override
    public String toString() {
        return "database.SfcWipPK[pcbPartNo=" + pcbPartNo + ", projectNoSub=" + projectNoSub + "]";
    }
    
}
[Message sent by forum member 'sunright' (sunright)]

http://forums.java.net/jive/thread.jspa?messageID=223908