Hibernate 5 change not to use fetch first rows only

Question

I'm using Hibernate 5.2 with oracle 11 which does not support fetch first rows only and I need to get back to old style hibernate. is there any hibernate configuration to do that ?

score 5 · Accepted Answer · answered May 02 '18 at 20:56

5

You can force Hibernate to use the Oracle 10g dialect, this way you will get the old limit rule with rownum instead of fetch first.

Looking at the official documentation, you can force the dialect with this property:

hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

Or, if you are using Spring Boot 2 with JPA, you can set this way:

spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

Best regards.

answered May 02 '18 at 20:56

Rafael Renan Pacheco

2,138
21
22

After more than 3 hours of researches, you are the only one who gave the correct answer. Thanks ! – 0ddlyoko Feb 21 '19 at 13:19

Hibernate 5 change not to use fetch first rows only

1 Answers1

Linked