I have the following query:
"SELECT g FROM ParameterDefinitionFull g " + 
        "WHERE g.pk.parameterName like :pk_parameterName and
g.expiryDateTime > current_timestamp"
The entity definition for g.expiryDateTime is like this:
        @Temporal(TemporalType.TIMESTAMP)
        @Column(name="EXP_TS")
        private Calendar expiryDateTime;

When I run the query I get the following error:
 Attempt to compare incompatible types "class java.util.Calendar" and "class
java.util.Date"

The timestamp looks like this :
2010-06-23 17:32:03.343

Can this comparison be done? Thanks for the help!!
-- 
View this message in context: 
http://openjpa.208410.n2.nabble.com/How-to-compare-Calendar-Entity-to-current-timestamp-tp5429576p5429576.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Reply via email to