I am investigating upgrading our system from 1.0.2 to 2.0.1. I
have come across the whole getResultList as List<Object[]> instead
of the old List<List<Object>> deal. The issue I now have is where
named queries are failing, for example:
@NamedQuery(name = "Recording.findById", query = "SELECT r FROM
Recording r WHERE r.id = :id")
/Target Invocation Exception: Exception [EclipseLink-8030]
(Eclipse Persistence Services - 2.0.1.v20100213-r6600):
org.eclipse.persistence.exceptions.JPQLException
Exception Description: Error compiling the query
[Recording.findById: SELECT r FROM Recording r WHERE r.id = :id],
line 1, column 37: unknown state or association field [id] of
class [xxx.entities.Recording].
Descriptor: RelationalDescriptor(xxx.entities.Recording -->
[DatabaseTable(recordings)])
/
This is the most basic of my named queries and it still happens.
Again, this all worked fine in 1.0.2.
I don't get problems if I pare it back to:
[Recording.findAll: SELECT r FROM Recording r]
But do with:
[Recording.findAll: SELECT r FROM Recording r ORDER BY r.id]
It seems it doesn't want to recognise my fields. Interestingly it
doesn't seem to be happening with any of my other entities. This
one is defined about the middle of my persistence.xml file, so
it's not the first one hit. Here's relevant sections of the
Recording class, also showing most of the NamedQueries commented
out as I try to sort this out:
@Entity
@Table(name = "recordings")
@NamedQueries( { @NamedQuery(name = "Recording.findAll", query =
"SELECT r FROM Recording r ORDER BY r.id")
// @NamedQuery(name = "Recording.findById", query =
// "SELECT r FROM Recording r WHERE r.id = :id"),
// @NamedQuery(name = "Recording.findByListened", query =
// "SELECT r FROM Recording r WHERE r.listened = :listened ORDER
BY r.date, r.time"),
// @NamedQuery(name = "Recording.findForDate", query =
// "SELECT r FROM Recording r WHERE r.date = :date ORDER BY
r.date, r.time"),
// @NamedQuery(name = "Recording.findForDateRange", query =
// "SELECT r FROM Recording r WHERE r.date BETWEEN :date AND
:toDate ORDER BY r.date, r.time"),
// @NamedQuery(name = "Recording.findForDateWhereUnlistened", query =
// "SELECT r FROM Recording r WHERE r.date = :date and r.listened
= false ORDER BY r.date, r.time"),
// @NamedQuery(name = "Recording.findForDateRangeWhereUnlistened",
query =
// "SELECT r FROM Recording r WHERE r.'date BETWEEN :date AND
:toDate and r.listened = false ORDER BY r.date, r.time"),
// @NamedQuery(name = "Recording.findForDateWithEvent", query =
// "SELECT r FROM Recording r WHERE r.date = :date and r.event is
not null ORDER BY r.date, r.time"),
// @NamedQuery(name = "Recording.findUnlistened", query =
// "SELECT r FROM Recording r WHERE r.listened = false ORDER BY
r.date, r.time"),
// @NamedQuery(name = "Recording.findOldestUnlistenedDate", query =
// "SELECT r.date FROM Recording r WHERE r.listened = false ORDER
BY r.date, r.time")
})
public class Recording implements Serializable {
private static final DateFormat TIME_FORMAT = new
SimpleDateFormat("HH:mm:ss");
private static final DateFormat DATE_FORMAT =
DateFormat.getDateInstance(DateFormat.SHORT);
public enum RecordingFilter {
ALL, UNLISTENED, WITH_EVENT;
}
private static DayNightDecider dayNightDecider;
@Transient
private final PropertyChangeSupport changeSupport = new
PropertyChangeSupport(this);
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Basic(optional = false)
@Column(name = "id", updatable = false)
private Integer id;
@Basic(optional = false)
@Column(name = "time", updatable = false)
@Temporal(TemporalType.TIME)
private Date time;
@Basic(optional = false)
@Column(name = "date", updatable = false)
@Temporal(TemporalType.DATE)
private Date date;
@Lob
@Basic(fetch = FetchType.LAZY)
@Column(name = "recording", updatable = false)
private byte[] recording;
@Basic(optional = false)
@Column(name = "listened")
private boolean listened;
@Basic(optional = false)
@Column(name = "format_id", updatable = false)
private int formatId;
@Basic
@Column(name = "comment")
private String comment;
@OneToOne(mappedBy = "recording", cascade = CascadeType.ALL)
private Event event;
@Transient
private Boolean night;
Thanks in advance
Brad
------------------------------------------------------------------------
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
