This week's book giveaway is in the Android forum.
We're giving away four copies of Android Programming: The Big Nerd Ranch Guide and have Bill Phillips & Chris Stewart on-line!
See this thread for details.
Win a copy of Android Programming: The Big Nerd Ranch Guide this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to Convert HQL to SQL Query  RSS feed

 
vijay sachin
Greenhorn
Posts: 23
  • 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
  • Likes 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
  • 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
  • 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:

 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!