Re: Database Locks , Performance Issues and How to Resolve?

On Thu, Jan 2, 2020 at 5:35 AM <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:

> - *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.

Cheers,

Jeff

>