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-u...@lists.sourceforge.net/msg114824.html
Is it possible to avoid rownumber in the sql query?
Appreciate all the help.
Thanks.
_______________________________________________
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev
