We have upgraded some of our apps to Spring Boot 3, which also brings Hibernate 6. Since the upgrade we have noticed that the
hibernate.jdbc.fetch_size property is not being respected. After some debugging I can see that the
jdbcFetchSize field in
SessionFactoryOptionsBuilder is being set properly but it looks like it’s not being read. Compared it with Hibernate 5 and I can see it being read as expected. Before creating a ticket for this I thought I would check it here, maybe someone has a solution.
There is a Spring issue that was closed: spring.jpa.properties.hibernate.jdbc.fetch_size not working Spring 3.X and Oracle · Issue #2835 · spring-projects/spring-data-jpa · GitHub
and a Stack Overflow post as well: java - spring.jpa.properties.hibernate.jdbc.fetch_size not working for Spring Framework 6.x and Oracle? - Stack Overflow