Hello, We are using the DB2iDialect to connect to an IBMi system (jdbc:as400) Since upgrading to Hibernate 6.6.36.Final - straight from 6.5 because we were waiting for a bug fix - we noticed that the following methods are failing and creating invalid SQL: EntityManager → merge JpaRepository → sa…

Can you please build this PR and tell us if that fixes your problem?

Hello, During an upgrade of Hibernate from 6.5.3.Final to 6.6.38.Final (and now try 6.6.41.Final), I found that bug on DB2. For the moment, I found this problem on select queries which used some field of composite primary key with annotation @EmbeddedId

I’m sorry, but I have no idea what you’re trying to say. The fix is included in 6.6.41.Final, so not sure why you’re trying to upgrade to an old fix version when there is a newer one available.

Sorry to disturb you. I used an old and deprecated dialect (DB2400Dialect). All works in 6.6.41.Final with the correct dialect (DB2iDialect).

Hello @beikov I’m really sorry that I missed your reply. We have been using 6.6.41 since last week and our problems are resolved, thank you!

DB2iDialect generates invalid SQL when calling merge on an entity

Hibernate ORM

beikov December 10, 2025, 12:48pm 2

Please see Db2 for i regression in 6.6.30+ (HHH-19768 / row-value IN) – SQL0216 and SQL0584 on basic loads where this problem was already reported.

Topic		Replies	Views
Hibernate v6 generates a query with IN clause upon EntityManager.merge() call. Is there a way to avoid IN clause in favor of equals+AND? Hibernate ORM	3	228	October 7, 2024
Db2 for i regression in 6.6.30+ (HHH-19768 / row-value IN) – SQL0216 and SQL0584 on basic loads Hibernate ORM	5	478	January 14, 2026
Merge fails with composite identifier containing association Hibernate ORM	8	12413	February 6, 2018
DB2 Named Queries different upon Hibernate 6 upgrade Hibernate ORM	1	107	September 11, 2025
Hibernate 5 and 6 differences @ManyToOne @JoinColumn Hibernate ORM	18	1202	November 22, 2024

DB2iDialect generates invalid SQL when calling merge on an entity

Related topics