HQL query required using START WITH and CONNECT BY PRIOR SQL keywords

[G. Raghavender Raju]

Team,

I've an SQL query with the combination of START WITH and CONNECT BY PRIOR keywords, for which I would like to convert the query into HQL, so please share me some example codes where in I can run the HQL and SQL statements with the same.

Looking forward for your valuable responses.

--
Thanks & Regards
G. Raghavender Raju

[Janmejay Singh]

> --
> You received this message because you are subscribed to the Google
> Groups "Bangalore Open Java Users Group- BOJUG" group.
> To post to this group, send email to bo...@googlegroups.com.
> To unsubscribe from this group, send email to bojug
> +unsub...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/bojug?hl=en.

AFAIR these are too oracle specific. I may be wrong, but i don't think
ORMs would support db specific queries to this extent.

BTW, check org.hibernate.dialect package. You want to look at
Oracle8iDilect, Oracle9iDilect and Oracle10gDilect(10g extends 9i and 9i
extends 8i).

--
Regards,
Janmejay
http://codehunk.wordpress.com

[Kamal]

You can use the createSqlQuery version to pass in the sql query
instead of HQL. Hibernate provides a mechanism to take the output
returned by the sql query and map it as hibernate managed objects.

Regards,
Kamal