# Regression with DB2

**URL:** <https://discourse.hibernate.org/t/regression-with-db2/7040>\
**Category:** Hibernate ORM\
**Created:** [December 20, 2022, 12:26am UTC](https://discourse.hibernate.org/t/regression-with-db2/7040 "2022-12-20T00:26:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![fabienseznec](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/fabienseznec/32/2173_2.png) [@fabienseznec](https://discourse.hibernate.org/u/fabienseznec)\
**Post date:** [December 20, 2022, 12:26am UTC](https://discourse.hibernate.org/t/regression-with-db2/7040/1 "2022-12-20T00:26:44Z")

</div>

Hello,

I have a project using spring-boot and a DB2 database.  
I am migrating from spring-boot 2.7.0 / hibernate 5.6.9.Final to spring-boot 3.0.0 / hibernate 6.1.5.Final.

When doing so, the following error occurs :  
`[...] org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select * from (select e1_0.empno c0,row_number() over() rn from employee e1_0) r_0_ where order by r_0_.rn]; SQL [n/a]`

I have isolated the issue in a minimal sample and raised the bug here and here:

- [[HHH-15890] - Hibernate JIRA](https://hibernate.atlassian.net/browse/HHH-15890)
- [springboot 3.0.0 + db2 error after migrating from springboot 2.7.0 · Issue #2732 · spring-projects/spring-data-jpa · GitHub](https://github.com/spring-projects/spring-data-jpa/issues/2732)

But I am unsure that it is the right hibernate project to raise this bug.  
I am not even sure to have posted on the right category …

Could someone take a look and redirect me please ?  
Thanks !

---

<div class="post-metadata">

**Author:** ![beikov](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/beikov/32/258_2.png) [@beikov](https://discourse.hibernate.org/u/beikov)\
**Post date:** [December 21, 2022, 12:19pm UTC](https://discourse.hibernate.org/t/regression-with-db2/7040/2 "2022-12-21T12:19:24Z")

</div>

Let’s continue the discussion on the JIRA issue