Table Aliases

KK · **Joined:** Wed Sep 17, 2003 9:02 pm **Posts:** 13

Hibernate version:2.1.6

Hi All.

For example for the name query:

select client from
package.Client as client
where client.id = :clientID

the SQL that is generated contains alias like client1_.field name.

Is there a way, we can specify the alias that has to be generated in the SQL.

Thank you for your help.

max · **Posted:** Fri Dec 03, 2004 3:42 am

no.

May I ask why you need that ?

KK · **Joined:** Wed Sep 17, 2003 9:02 pm **Posts:** 13

The query generated is doing a full table scan. After discussing with our DBA's, we came to the conclusion only way to make it use the index is to use Oracle hints. The hint we have to use id /* use_nl (alias name) */.

Since the alias is generated by Hibernate, I am not sure what to give in the "alias name". So, if I can instruct Hibernate to use the alias I mention, I thought I can use it in the hint.

Please let me know in case you need additional clarification. Thank you for your help to solve my problem.

max · **Posted:** Fri Dec 03, 2004 2:14 pm

that is not possible in HQL.

May i suggest that you try to use createSQLQuery which allows you to do this stuff in a native way.
(just remember that createSQLQuery for the moment only support returning entities - not scalar values)