Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

[b]Hibernate version:[/b]
Hibernate 2.1.6
[b]Name and version of the database you are using:[/b]
Oracle9i

I wanted to know whether HIbernate's HQL supports CONNECT BY clause or not. I have the following SQL query which I want to write through hibernate

SELECT node_id, level
FROM t_tknd_node
WHERE level <=
(
SELECT level
FROM t_tknd_node
WHERE node_id = ?
START WITH ltrim(rtrim(PRNT_NODE_ID)) is null
CONNECT BY prnt_node_id = PRIOR node_id
)
START WITH ltrim(rtrim(PRNT_NODE_ID)) is null
CONNECT BY prnt_node_id = PRIOR node_id
ORDER BY level


Any pointer will be higly appreciated.

Use a native sql query. http://www.hibernate.org/hib_docs/reference/en/html/querysql.html

Hi,
I think y question was not very clear. the question has 2 parts:
1. Does HQL supports CONNET BY clause
2. If yes then how to use that.


I will add a third question:
3. If have to use the native sql then how would I use it for the query stated. I looked up at the hibernate documentation and found it pretty cumbersome and thus would appreciate a example in thuis case.

My preference is to use HQL and thus would give approach for usage of HQL as the first priority.

Satish

Please have a look at:
https://www.hibernate.org/117.html

Currently HQL Does not support hierarchical queries.

Regards
Satyendra Patel