File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to Convert HQL to SQL Query

 
vijay sachin
Greenhorn
Posts: 23
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All

I need to convert HQL to SQl Query is there any why I can do it.



I want to convert the above HQL Query to SQL query, Please help me how can I do it.


 
Tim McGuire
Ranch Hand
Posts: 820
IntelliJ IDE Tomcat Server VI Editor
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
vijay sachin wrote:Hi All

I need to convert HQL to SQl Query is there any why I can do it.



I want to convert the above HQL Query to SQL query, Please help me how can I do it.




the true SQL will depend on how entities are mapped.
look for a property


if you set that to "true", the true SQL of those hibernate queries will show up in your logs.
 
vijay sachin
Greenhorn
Posts: 23
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Tim,

In Hibernate.cfg.xml file I already added this property

But in log its not coming as SQL query..




HBM File



Please help me in this...



 
Tim McGuire
Ranch Hand
Posts: 820
IntelliJ IDE Tomcat Server VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes. In your log, this is the SQL that hibernate causes to run. Copy and paste it into a SQL tool and run it:

 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic