I am using hibernate with oracle databases.
My HBM file has many to one mapping defined.
For pagination i am setting the setMaxResults(Integer i)
query generated by Hibernate is in following format:
Select * from (select ...) where rownum <= i;
select query genrated has duplicate column names
and gives the error
Column ambiguously defined.

Check column names case.

You may call:
select x as 'x', X as 'x' from table;
But you cannot (in oracle):
select count(*) from (select x as 'x', x as 'X' from table);

Here is JIRA issue:
http://opensource2.atlassian.com/projec ... e/HHH-1110

Check your hbm files, probably you have somthing like this:

<property name="phoneId" column="PHONE_ID" type="integer" not-null="false" />
<many-to-one name="phone" class="my.domain.Phone" column="phone_id" />

Hamster,

Hello,

My hbm files have entry like this

<class name="com.tfsm.oas.data.Location" table="Location">
<property name="siteKey" column="SiteKey" type="int" />
<many-to-one name="site" class="com.tfsm.oas.data.Site" column="SiteKey" insert="false" update="false" lazy="false"/>
</class>

And the query generated is as follows:

select * from ( select location0_.SiteKey as SiteKey86_, location0_.SiteKey as siteKey86_ from Location location0_, Site site1_ where site1_.SiteKey=location0_.SiteKey and location0_.AccountKey=1 order by location0_.LocationKey asc ) where rownum <= 4

In the inner select query there are 2 location0_.SiteKey columns selected which gives error.
To solve this either
1) The second column selected should be site1_.SiteKey.
or
2) I should be able to give a different alias name for the second sitekey selected.

Could anyone pls tell me how get these 2 ponts done in hibernate?