Hi, needed one information @ a support for following SQL in HQL,

I am not able to get following HQL working , any clue whether following syntax is supported

select count(*) from (select * from table)

Above statement is a valid SQL, but when i translated it to HQL and try running it I am getting query syntax exception

FYI, I am using oracle9dialect

Any clue please

Thanks and Regards,

Sudhir

Could you explain a bit what you are trying to do ? Do you want to count the number of lines inside many tables ? This query seems a bit weird to me, maybe you're trying to write a dbms admin tool with Hibernate ?

Ok let me explain ones again

I have following sql

select count(*) from (
select id, name from usertable
)

this query runs absolutely fine on SQL

when i convert this SQL to HQL and execute as shown below, i get a error on "(" which is after keyword "from"

select count(*) from (
select intId, strName from usertableObj
)


therefore i asked whether same syntax is supported in HQL

Well, I don't think HQL is designed to do it. IMO, this is typically the kind of things that could be done with createSQLQuery() instead of createQuery().