I connect to both MySQL and an IBM i and recently upgraded to org.hibernate.orm:hibernate-core:6.1.5.Final. Queries that were working fine in the earlier release started generating malformed SQL statements resulting in a plethora of …
“Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL0199] Keyword BY not expected. Valid tokens: FOR USE SKIP WAIT WITH FETCH LIMIT ORDER UNION EXCEPT OFFSET.”
Since I’m on a deadline I’m going to revert all of these statements back to createNativeQuery() statements from createQuery() statements, but I was wondering if anyone knows about this issue and can share a quick solution with me.
I did switch to the DB2iDialect.