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

Reply via email to