Hello,

My HQL:

select full_name from person
or
select pp.full_name as FullNameStr from person pp

Hibernate generate the SQL:

select person0_.full_name as col_0_0_ from person person0_

In other words, it ignores my alias...

How could I force my own alias??

Or, is there any mechanics to force always the same alias? Sometimes, hibernate change the alias for the same query.

Thanks,

That's a logical alias. Behind the scenes, Hibernate must ensure that all SQL-level aliases are unique, so it replaces the logical alias with a physical one.

Why do you want to change it?

Because, for the same query, sometimes, hibernate changes the name of alias.

This is a problem, because DBA built a plan specific execution plan for this query, but when hibernates change the alias, Oracle doesn't find this execution plan, and the performance goes down again.

So, If there isn't any chance to force the alias, I would like to, at least, guarantee that hibernates never changes the alias.

Got it ?


Thanks

But then the issue is that Hibernate changes the alias. Can you provide a test case for it?

Well I don't have any test case to show to you, I just know that DBA reported that, after he had built a especial execution plan for the query, the performance had be improved, but, the next day, for the same query, the performance was decreased. When he investigate, he saw that the alias of columns and\or tables were changed, for the same query

I did on more attempting, using named query, but even so, I can't use my alias

So, I getting the conclusion that, the only way to guarantee that the query will be always the same query, is using the native query.

Unfortunately, this is the unique answer.

If you have any idea, I will appreciate.

Thank

I don't think you can fix that. What I need is the exact SQL queries that have been generated differently, so that we have something to start from.