Is it posible to start a hql query with a WITH clause of oracle.

If a oracle query which is starting with WITH clause need to be converted in hql then how it can be done?

Thanks in advance

Here is what you can do with HQL: http://www.hibernate.org/hib_docs/refer ... ryhql.html
You can't do much else with it.

Hi,
You cannot start an HQL query with 'WITH'.
Here is an extract from HQL grammar,

queryRule
: selectFrom
(whereClause)?
(groupByClause)?
(orderByClause)?
;
selectFrom!
: (s:selectClause)? (f:fromClause)? {
// If there was no FROM clause and this is a filter query, create a from clause. Otherwise, throw
// an exception because non-filter queries must have a FROM clause.
if (#f == null) {
if (filter) {
#f = #([FROM,"{filter-implied FROM}"]);
}
else
throw new SemanticException("FROM expected (non-filter queries must contain a FROM clause)")
;
}
// Create an artificial token so the 'FROM' can be placed
// before the SELECT in the tree to make tree processing
// simpler.
#selectFrom = #([SELECT_FROM,"SELECT_FROM"],f,s);
}
;
>>>If a oracle query which is starting with WITH clause need to be converted in hql then how it can be done?
As far as I know, you can't rewrite it 'as-is' in HQL.

However, you can do the following.
i) Map an entity to query names created using 'WITH'. From here on, it is plain HQL.
ii) Use createSQLQuery() and then addEntity() to it so as to work with objects.

------------------------------------------
Rate the reply if you find it helpful

hi

thanx for the reply.i will try it.is it posible to write an inline view in HQL??

Hi,
>>> is it posible to write an inline view in HQL??
NO.
HQL subqueries may occur only in the select or where clauses.
So, we cannot have inline views in HQL.

----------------------------------------------
Rate the reply if you find it helpful

thanx a lot.how to call a oracle function from hibernate hql query??thanks in advance