From: <forums_at_java.net>
Date: Wed, 29 Feb 2012 15:32:53 -0600 (CST)

 

Here the vars:

private Integer Voucher;

private Date Date_;

private long   RecID;

The JPQL:

@NamedQuery(name = "LedTrans.findByVoucherDate",
    query = "SELECT l FROM LedTrans l WHERE l.Voucher = :Voucher"
    + " AND l.Date_ = :Date_ "
    + " AND l.RecId = :RecId")

 

The Error in Glassfish errorlog:

Caused by: Exception [EclipseLink-8030] (Eclipse Persistence Services -
2.3.0.v20110604-r9504): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Error compiling the query [LedTrans.findByVoucherDate:
SELECT l FROM LedTrans l WHERE l.Voucher = :Voucher AND l.Date_ = :Date_ 
AND l.RecId = :RecId], line 1, column 33: unknown state or association field
[Voucher] of class ....

 

 

--
[Message sent by forum member 'snotty77']
View Post: http://forums.java.net/node/883884