[hibernate-dev] Issue with rownumber in db2

[charly prabakar]

Hi,


I’m trying to connect to DB2 using Hibernate through Grails framework.
 
I have specified the table and column names in hibernate mapping file. 
Hibernate internally generate the queries to connect to the db and return results.
 
Below is the query generated by Hibernate to return results from MYSCHEMA.INQ_TYP table.
 
select * from
        ( select rownumber() over() as rownumber_,
            this_.INQ_TYP_CDE as INQ1_20_0_,
            this_.CRAT_USER_ID as CRAT2_20_0_,
            this_.INQ_TYP_NME as INQ3_20_0_
        from
            MYSCHEMA.INQ_TYP this_ ) as temp_
    where
        rownumber_ <= 2
 
This returns error as there is no rownumber in db2 zOs.


When I searched the forums, I found similar questions but there was no answers.


One of the links I saw
http://www.mail-archive.com/jboss-user@lists.sourceforge.net/msg114824.html


Is it possible to avoid rownumber in the sql query?


Appreciate all the help.


Thanks.