Convert HQL to SQL

kesavramesh · **Posted:** Mon Sep 21, 2009 12:56 pm

Hi all,
I have a HQL which joins 2 tables Table A and Table B. Each have a column say id
I need the results of (A minus B ) something of the following sort
select from A where A.id = B.id and A.id not in (select id from B).

I am using HQL for this.

But the result is coming back to me as an Object[]. Is there a way that I can convert the HQL into a SQL so that I can use sqlQuery.addEntity(theClass);

Regards
Ramesh Kesavanarayanan

Froestel · **Posted:** Mon Sep 21, 2009 5:16 pm

Hi kesavramesh,

I guess there is - just write an SQL query that retrieves the same result as the HQL query.

Or what do you mean? Automated conversion from HQL > SQL?

CU
Froestel

Urmech · **Joined:** Thu Apr 14, 2005 10:39 am **Posts:** 115

Quote:

select from A where A.id = B.id and A.id not in (select id from B).

Is always empty! If A.id matches B.id; A.id will be in the B-table. So the second expression is always false if first is true and vice versa.

Otherwise you can get the SQL from the log file with debug level. Or wit the "show sql" property.

Even I can't image what you want to do with "addEnity"?
What's wrong with Object[]?

Greetings Michael