Hi,
I think the issue is that t_umgrevision is the name of the table the entity class MailRevisionPersistence is mapped to. But the FROM clause of a Java Persistence query uses the entity class names instead of table names. So the query should look like:
SELECT o FROM MailRevisionPersistence o WHERE o.time_stamp BETWEEN :dateStart AND :dateEnd
The abstract schema type of an entity class is specified in the name element of the Entity annotation and defaults to the unqualified name of the entity class, in your case MailRevisionPersistence.
Regards Michael
[Message sent by forum member 'mb124283' (mb124283)]
http://forums.java.net/jive/thread.jspa?messageID=239293