-I want to know if below is true in case of Postgres ? Then it’s a problem as all coding needs to be done manually and not by JPA.
By default in Java Spring boot autocommit set to true. It means all the SQL statements consider as a transactions (include Select statement).
Automatically Begin and commit will execute only successful execution of each statement.
Well, was it "idle in transaction"? If so, the either the query came in through something other than Spring Boot, or someone overrode the default. There is no grand answer here, you have to figure out what actually happened.