Re: [eclipselink-users] unknown state or association field since upgradi

[khaskett <khaskett@xxxxxxxxxxx>]

I changed the lineofBusiness to lineOfBusiness and I am still getting an
error - 
Caused by: Exception [EclipseLink-8030] (Eclipse Persistence Services -
1.1.0.r3634): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Error compiling the query [SELECT model FROM
Zdk01cntlf AS model WHERE model.lineOfBusiness = :lineOfBusiness AND
model.state = :state AND model.type = :type AND model.reasonCode =
:reasonCode ORDER BY model.effectiveDate ASC ], line 1, column 50: unknown
state or association field [lineOfBusiness] of class
[com.xxx.jpa.domain.Zdk01cntlf].

query code -
final String queryString = "SELECT model FROM Zdk01cntlf AS model WHERE
model.lineOfBusiness = 
    :lineOfBusiness AND model.state = :state AND model.type = :type AND
model.reasonCode =  
    :reasonCode ORDER BY model.effectiveDate ASC ";
final Query query = getEntityManager().createQuery(queryString);

EmbeddedId -
public class Zdk01cntlfId implements Serializable {

    private String lineOfBusiness; 
...
    @Column(name = "CNT_REF_FILE_LINE")
    public String getLineOfBusiness() {
        return this.lineOfBusiness;
    }

    public void setLineOfBusiness(String lineOfBusiness) {
        this.lineOfBusiness = lineOfBusiness;
    }

Entity didnt change.

Looks like the case is matching right now, am I missing something else?


Gordon Yorke-2 wrote:
> 
> The JPA specification requires that the access type of the Embeddable is 
> interpreted to be the access type of the owner.  In this case the owner 
> uses property access and so EclipseLink must process the Embeddable 
> using property access.  The case of the property "lineOfBusiness" is not 
> the same as the JPQL property name you are using "lineofBusiness".  You 
> can change your JPQL or change the access type of the parent.
> --Gordon
> 
> khaskett wrote:
>> Currently getting this message in my server logs when try to run a JPQL
>> query- 
>> Caused by: Exception [EclipseLink-8030] (Eclipse Persistence Services -
>> 1.1.0.r3634): org.eclipse.persistence.exceptions.JPQLException
>> Exception Description: Error compiling the query [SELECT model FROM
>> Zdk01cntlf AS model WHERE model.lineofBusiness = :lineofBusiness AND
>> model.state = :state AND model.type = :type AND model.reasonCode =
>> :reasonCode ORDER BY model.effectiveDate ASC ], line 1, column 50:
>> unknown
>> state or association field [lineofBusiness] of class
>> [com.xxx.jpa.domain.Zdk01cntlf].
>>
>> Here is the code I am executing - 
>>
>>  final String queryString = "SELECT model FROM Zdk01cntlf AS model WHERE
>> model.lineofBusiness =  
>>    :lineofBusiness AND model.state = :state AND model.type = :type AND
>> model.reasonCode = :reasonCode   
>>    ORDER BY model.effectiveDate ASC ";
>>
>> final Query query = getEntityManager().createQuery(queryString);
>>
>> The entity looks like this - 
>> @Entity
>> @Table(name = "ZDK01CNTLF", schema = "GNDATA")
>> public class Zdk01cntlf implements Serializable {
>>
>>    private Zdk01cntlfId id;
>>    private String effectiveDate; 
>>    private String numberofDays;
>> 	
>>    public Zdk01cntlf() {
>>      super();
>>    } 
>> 	   
>>     @EmbeddedId
>>     public Zdk01cntlfId getId() {
>>         return id;
>>     }
>>
>>     public void setId(Zdk01cntlfId id) {
>>         this.id = id;
>>     }
>>
>>     @Column(name = "CNT_REF_FILE_EFF_DT")
>>     public String getEffectiveDate() {
>> 	return this.effectiveDate;
>>     }
>>     
>>     public void setEffectiveDate(String effectiveDate) {
>> 	this.effectiveDate = effectiveDate;
>>     }
>> 	   
>>     @Column(name = "CNT_REF_FILE_DAYS_NOT")
>>     public String getNumberOfDays() {
>>  	return this.numberofDays;
>>     }
>> }
>>
>> And the EmbeddedId looks like -
>> @Embeddable
>> public class Zdk01cntlfId implements Serializable {
>>
>>     private String lineofBusiness; 
>>     private String state; 
>>     private String type; 
>>     private String reasonCode; 
>>
>>     /** default constructor */
>>     public Zdk01cntlfId() {
>>     }
>>
>>     public Zdk01cntlfId(String lineofBusiness, String state, String type,
>> String reasonCode) {
>>         super();
>>        ....
>>     }
>>
>>     // Property accessors
>>
>>     @Column(name = "CNT_REF_FILE_LINE")
>>     public String getLineOfBusiness() {
>>         return this.lineofBusiness;
>>     }
>>
>>     public void setLineOfBusiness(String lineofBusiness) {
>>         this.lineofBusiness = lineofBusiness;
>>     }
>>        
>>     @Column(name = "CNT_REF_FILE_STATE")
>>     public String getState() {
>>         return this.state;
>>     }
>>
>>     public void setState(String state) {
>>         this.state = state;
>>     }
>>        
>>     @Column(name = "CNT_REF_FILE_CAN_TYPE")
>>     public String getType() {
>>         return this.type;
>>     }
>>
>>     public void setType(String type) {
>>         this.type = type;
>>     }
>>        
>>     @Column(name = "CNT_REF_FILE_CAN_REASON")
>>     public String getReasonCode() {
>>         return this.reasonCode;
>>     }
>>
>>     public void setReasonCode(String reasonCode) {
>>         this.reasonCode = reasonCode;
>>     }
>>
>>    .... hashCode and Equals ommitted
>>
>> This has just started showing up since we moved from 1.0.2 to 1.1 
>>
>>   
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> 
> 

-- 
View this message in context: http://www.nabble.com/unknown-state-or-association-field-since-upgrading-to-1.1-tp22563222p22564851.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.