Hello Michael, Hello Stephan,
I went through that link before posting this question because no where I could
find that "SELECT E1 FROM au.com.righttime.unity.odata.service.model.Test E1
WHERE E1.tradingDate = {ts '2009-12-26 21:23:38.000'}" is a wrong HQL statement.
But now I would like to raise one wish. Should we start supporting HQL along
with JPQL in our Olingo JPA. WDYT?
Thanks,
Kind Regards
Chandan VA
-----Original Message-----
From: Bolz, Michael [mailto:[email protected]]
Sent: Tuesday, April 22, 2014 3:07 PM
To: [email protected]
Subject: Re: Help on Hibernate based JPA providers
* PGP Signature not checked
Hi,
I admit to Stephan and quote from here:
http://docs.jboss.org/hibernate/orm/4.2/devguide/en-US/html/ch11.html
> The Hibernate Query Language (HQL) and Java Persistence Query Language (JPQL)
> are both object model focused query languages similar in nature to SQL. JPQL
> is a heavily-inspired-by subset of HQL. A JPQL query is always a valid HQL
> query, the reverse is not true however.
So IMHO the JPQL syntax should also be supported bei HQL.
Kind regards,
Michael
On 22.04.2014, at 10:02, Klevenz, Stephan <[email protected]> wrote:
> Hi Chandan,
>
> Well, I would say that JPQL [1] and HQL [2] are two different things. I
> think the query is not correct for Hibernate.
>
> -- Stephan
>
>
> [1] http://www.objectdb.com/java/jpa/query
> [2] http://docs.jboss.org/hibernate/orm/3.3/reference/en/html/queryhql.html
>
> On 20.04.14 16:29, "V.A, Chandan" <[email protected]> wrote:
>
>> Hello Team,
>>
>> I would like to discuss the issue -
>> https://issues.apache.org/jira/browse/OLINGO-240 in the forum.
>>
>> I would like to check whether the JPQL syntax for date literals are
>> supported in Hibernate. Can someone tell is this a valid Query syntax for
>> Hibernate based JPA providers, because it works with Eclipse Link based
>> JPA providers.
>>
>>
>>
>> SELECT E1 FROM au.com.righttime.unity.odata.service.model.Test E1 WHERE
>> E1.tradingDate = {ts '2009-12-26 21:23:38.000'}
>>
>>
>>
>> Thanks,
>>
>> Kind Regards
>>
>> Chandan VA
>>
>>
>>
>
* Signature checking is off by policy