persistence@glassfish.java.net

Re: Problem comparing dates in JPS QL

From: Michael Bouschen <mbo.tech_at_spree.de>
Date: Tue, 08 Dec 2009 16:49:11 +0100

Hi Ignacio,

please try qualifying the date field in the order by clause:
  ... order by o.date asc

Regards Michael

> Hi there,
> i am trying to migrate from JBoss 5.1 to Glassfish v3 and get the following
> error in my queries:
>
> Exception Description: Syntax error parsing the query
> [NMEASentence.findFromDate: select o from NMEASentence o where o.date >
> :date order by date asc].
>
> This query work OK with Hibernate and i don't get the point on where it is
> not compatible with QJBQL 3.1 (JPA QL?)
>
> I just need to do the typical "after" date query.
>
> Thanks for any help,
> Ignacio
>


-- 
*Michael Bouschen*
*Prokurist*
akquinet tech_at_spree GmbH
Bülowstr. 66, D-10783 Berlin
Fon:   +49 30 235 520-33
Fax:   +49 30 217 520-12
Email: michael.bouschen_at_akquinet.de
Url:    www.akquinet.de <http://www.akquinet.de>
akquinet tech_at_spree GmbH, Berlin
Geschäftsführung: Martin Weber, Prof. Dr. Christian Roth
Amtsgericht Berlin-Charlottenburg HRB 86780 B
USt.-Id. Nr.: DE 225 964 680