I am using hibernate with Oracle
My HBM file contains
<many-to-one column="SectionKey" insert="false" update ="false"/>
While creating query , i am setting setMaxResult(Integer i) for the pagination purpose.
Hibernate generate the query in following format
select * from (select ....) where rownum <= i;
The select statement has duplicate column names which further gives the error "column ambiguously defined"
need help on this.