Valid HQL but generated SQL is invalid

[Vikas Kapoor]

I wrote one error free HQL. Tomcat is up and running without compilation error. but when it got converted into SQL, it gave me some SQL grammar exception. I just changed the order of one join or fields and the problem disappear. I think (I am sure) that HQL was correct.

Did anyone face this kind of issue before? I think this has to do something with the algorithm which converts HQL to SQL. I have faced this issue couple of time in past. Can someone provide me link to that algorithm?

[Leonardo Carreira]

Hi Vikas Kapoor..

As far as i know the correct HQL would be converted to SQL correct too.., because Hibernate uses/provides Dialects of each Database vendor-specific..
may i know the Database that you use and your HQL?..

please correct me if i'm wrong..

Thanks..

[David Newton]

It'd probably be quicker to post your HQL--I haven't seen very many instances of invalid SQL coming from valid HQL, and certainly not lately.

[Vikas Kapoor]

Actually, I have already corrected the HQL and it was a month ago issue.

If I find that issue again I will post the HQL.

Apart from that can someone point to the link about the algorithm which converts HQL to SQL? Any idea?