Hibernate version:
3.0.5
Name and version of the database you are using:
Oracle 9

The SQL statements generated by Hibernate contain alias names for the columns consisting of some letters from the column name and three numbers. The second number differs under certain circumstances. If I change the JVM or if the generation is done inside or outside an application server, the second number changes. It also changes after some evolution on the software.

How does this alias generation work?
Is it possible to influence it, so that the generated names are always the same?

My problem is, that I have to use stored outlines within an oracle database. For these stored outlines it is necessary that the statement keeps the same, otherwise the outline is not used. I.e. if the alias name of the statement used during stored outline generation differs from the alias name during the run of the application, the stored outline is not used.

Is there a way to use Hibernate in conjunction with the stored outlines of oracle?

Does somebody get an answer for this ? The same is happening on our environment as well where it becomes difficult to stabilize the outlines as the queries keeps changing because of different aliases.