Thanks a lot Michael... 2 minutes ago I figured out... "Oh no... it can't be
that!". Hibernate compiles queries fine without qualifying that order by
clause. It would so great that all these persistence flavours make an effort
to make standard these little differences that don't really add anything
useful but just make you mad when trying to migrate an app from one
persistence engine to another one.
Thanks again,
Ignacio
Michael Bouschen-2 wrote:
>
> 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
>
>
--
View this message in context: http://old.nabble.com/Problem-comparing-dates-in-JPS-QL-tp26695692p26696125.html
Sent from the java.net - glassfish persistence mailing list archive at Nabble.com.