When I upgrade Hibernate from 5 to 6, Numeric Overflow Exception occurs.

SQL:

Exception:

I found that the org.hibernate.OracleDialect always was set to default Dialect.

If I change org.hibernate.OracleDialect to org.hibernate.MariaDBDialect, it works.

I think there is a bug in org.hibernate.OracleDialect, but I can’t change it to older OracleDialect like Oracle10gDialect due to the reason in below alert

Also I try all the hibernate 6.x version, neither works.