Hibernate Community • View topic - SQL name alias in a clustered environment

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

SQL name alias in a clustered environment

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

dcabasson

Post subject: SQL name alias in a clustered environment

Posted: Thu Jan 20, 2011 11:20 pm

Newbie

Joined: Mon May 11, 2009 5:06 pm
Posts: 2

Hi,

We are using hibernate on a application that is running on a clustered environment, and I was wondering if there was a way to get hibernate to always use the same SQL alias in its query.
The issue right now is that Hibernate on different member of the cluster will generate different alias, which is according to our database different queries. For example :
select casestatus0_.STATUS_CODE_ID as STATUS1_29_ ...
select casestatus0_.STATUS_CODE_ID as STATUS1_49_ ...

Even though the queries are the same, they are using different alias, which throws a little bit off guard the database, with 2 issues :
* The database has to re-compile the statement
* The reporting off the database is hard to read as some queries are spread on many different forms which makes it harder to trace performance bottlenecks.

Thanks!

Top

dcabasson

Post subject: Re: SQL name alias in a clustered environment

Posted: Fri Jan 21, 2011 11:32 pm