aspose file tools*
The moose likes Object Relational Mapping and the fly likes How to Convert HQL to SQL Query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "How to Convert HQL to SQL Query" Watch "How to Convert HQL to SQL Query" New topic
Author

How to Convert HQL to SQL Query

vijay sachin
Greenhorn

Joined: Jan 18, 2011
Posts: 23
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

Joined: Apr 30, 2003
Posts: 820

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

Joined: Jan 18, 2011
Posts: 23
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

Joined: Apr 30, 2003
Posts: 820

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.
 
subject: How to Convert HQL to SQL Query