Open-in-view turn off issue

[BooAndBoCai]

when i want to try close spring.jpa.open-in-view=false , i found my save method can't work .

Spring data-jpa version:
spring-boot-start-data-jpa:3.3.5

application.yaml config

jpa: show-sql: true open-in-view: false

two different in picutre
when close open in view config ,no log output

when open 'open in view config' , execute sql

[schauder]

Please provide code and error messages always as properly formatted text, when posting on issue trackers, StackOverflow or similar.

I'm not sure what the exact problem is you are referring to, but the error message I found in the second image says, that there is a table missing. This could be due to an in memory database shutting down, when the connection gets closed.

Either way this does not seem to be a Spring Data or even Spring issue, but a configuration or usage issue on your side. That JPA changes its behaviour when sessions get closed is to be expected. Please consult JPA/Hibernate documentation or resources like StackOverflow how to work with JPA.