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

--000000000000c8cad6059b2d5343
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Jan 2, 2020 at 5:35 AM <[email protected]> wrote:

> -                      *I want to know if below is true in case of
> Postgres ? Then it=E2=80=99s a problem as all coding needs to be done man=
ually 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

>

--000000000000c8cad6059b2d5343
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Jan 2, 2020 at 5:35 AM &lt;<a hre=
f=3D"mailto:[email protected]">[email protected]</a>&=
gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex">





<div lang=3D"NL">
<div class=3D"gmail-m_7061130543023440370WordSection1">
<p class=3D"MsoNormal"><span lang=3D"EN-GB" style=3D"text-indent:0cm;font-s=
ize:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">-<span style=
=3D"font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch=
:normal;font-size:7pt;line-height:normal;font-family:&quot;Times New Roman&=
quot;">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
</span></span><u style=3D"text-indent:0cm"></u><b style=3D"text-indent:0cm"=
><span lang=3D"EN-GB" style=3D"font-size:11pt;font-family:Calibri,sans-seri=
f;color:rgb(31,73,125)">I want to know if below is true in case of Postgres=
 ? Then it=E2=80=99s a problem as all coding needs to be done manually and =
not by JPA.</span></b><br></p><div><div><div>
<p class=3D"MsoNormal"><span lang=3D"EN-GB" style=3D"font-size:11pt;font-fa=
mily:Calibri,sans-serif;color:rgb(31,73,125)"><u></u>=C2=A0<u></u></span></=
p>
<p class=3D"MsoNormal"><b><span lang=3D"EN-GB" style=3D"font-size:11pt;font=
-family:Calibri,sans-serif;color:rgb(31,73,125)">By default in Java Spring =
boot autocommit set to true. It means all the SQL statements consider as a =
transactions (include Select statement).<u></u><u></u></span></b></p>
<p class=3D"MsoNormal"><b><span lang=3D"EN-GB" style=3D"font-size:11pt;font=
-family:Calibri,sans-serif;color:rgb(31,73,125)">Automatically Begin and co=
mmit will execute only successful execution of each statement.</span></b></=
p></div></div></div></div></div></blockquote><div><br></div><div>Well, was =
it &quot;idle in transaction&quot;?=C2=A0 If so, the either the query came =
in through something other than Spring Boot, or someone overrode the defaul=
t.=C2=A0 There is no grand answer here, you have to figure out what actuall=
y happened.</div><div>=C2=A0</div><div>Cheers,</div><div><br></div><div>Jef=
f</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;=
border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang=3D"NL"><=
div class=3D"gmail-m_7061130543023440370WordSection1"><div><div><div>
</div>
</div>
</div>
</div>
</div>

</blockquote></div></div>

--000000000000c8cad6059b2d5343--