How to Convert HQL to SQL Query

[vijay sachin]

Hi All

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

String HQL_QUERY = "from SubsUsage where IMSI = :IMSI AND serviceID = :ServiceID1";
query = mysql_session.createQuery(HQL_QUERY);
query.setParameter("IMSI", cgrMsg.getCgrIMSI());

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

[Tim McGuire]

vijay sachin wrote:Hi All

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

String HQL_QUERY = "from SubsUsage where IMSI = :IMSI AND serviceID = :ServiceID1";
query = mysql_session.createQuery(HQL_QUERY);
query.setParameter("IMSI", cgrMsg.getCgrIMSI());

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

<property name="hibernate.show_sql" value="false"/>

if you set that to "true", the true SQL of those hibernate queries will show up in your logs.

[vijay sachin]

Hi Tim,

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

 <property name="hibernate.show_sql" value="false"/>  

But in log its not coming as SQL query..

HQL QUERY
-------------
String HQL_QUERY = "select usage, serviceID from SubsUsage user WHERE IMSI = :IMSI";

IN LOG
---------
select subsusage0_.UsageA as col_0_0_, subsusage0_.ServiceID as col_1_0_ from m_sdp_subsusage subsusage0_ where subsusage0_.IMSI=?

HBM File

<hibernate-mapping package="com.aricent">
<class 
    name="com.aricent.SubsUsage" 
    table="m_sdp_subsusage"
>
	<composite-id>
		<key-property name="IMSI" column="IMSI"/>	
		<key-property name="serviceID" column="ServiceID"/>		
	</composite-id>   
       <property
        name="usage"
        type="java.lang.Double"
        column="UsageA"
        not-null="true"
        length="50"        
    />    
    <property
        name="startDate"
        type="java.util.Date"
        column="StartDate"
        not-null="false"
        length="50"
    />
        <property
        name="endDate"
        type="java.util.Date"
        column="EndDate"
        not-null="false"
        length="50"
    />
        <property
        name="sessionState"
        type="java.lang.Double"
        column="SessionState"
        not-null="true"
        length="50"
    /> 
    </class>
</hibernate-mapping>

Please help me in this...

[Tim McGuire]

Yes. In your log, this is the SQL that hibernate causes to run. Copy and paste it into a SQL tool and run it:

select subsusage0_.UsageA as col_0_0_, subsusage0_.ServiceID as col_1_0_ from m_sdp_subsusage subsusage0_ where subsusage0_.IMSI=?