This is a multi-part message in MIME format.
------_=_NextPart_001_01C8A1B1.9AC8BFC8
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I'm running into a problem where an "AccessShareLock" is not being
released after a select statement unless a connection is closed. This
is leading me to a deadlock issue with deletes. I'm using JDBC to
interact with the database. I'm using postgresQL 8.0. I was under
the impression that resources (does this include locks) are released
when the prepared statement is closed. The code snippet looks like the
following (though it does more prosessing then in this example. Is
there something that I'm missing to release the locks?
=20
String sql =3D "select * from testtable";
PreparedStatement prest =3D con.prepareStatement(sql); =
=20
ResultSet rs =3D prest.executeQuery();
rs.next();
rs.close();
prest.close();
con.close();
=20
=20
------_=_NextPart_001_01C8A1B1.9AC8BFC8
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"
=
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@[EMAIL PROTECTED]
15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
..MsoChpDefault
{mso-style-type:ex****t-only;}
@[EMAIL PROTECTED]
Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal>I’m running into a problem where an =
"AccessShareLock"
is not being released after a select statement unless a connection is =
closed.
This is leading me to a deadlock issue with deletes. I’m =
using JDBC
to interact with the database. I’m using postgresQL =
8.0.
I was under the impression that resources (does this include =
locks) are
released when the prepared statement is closed. The code snippet =
looks
like the following (though it does more prosessing then in this
example. Is there something that I’m missing to =
release the
locks?<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p =
class=3DMsoNormal> =
String
<b>sql</b> =3D "select * from testtable";<o:p></o:p></p>
<p =
class=3DMsoNormal> =
PreparedStatement
<b>prest</b> =3D =
con.prepareStatement(sql);  =
;
<o:p></o:p></p>
<p =
class=3DMsoNormal> =
ResultSet
<b>rs</b> =3D prest.executeQuery();<o:p></o:p></p>
<p =
class=3DMsoNormal> =
rs.next();<o:p></o:p></p>
<p =
class=3DMsoNormal> =
rs.close();<o:p></o:p></p>
<p =
class=3DMsoNormal> =
prest.close();<o:p></o:p></p>
<p =
class=3DMsoNormal> =
con.close();<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
</div>
</body>
</html>
------_=_NextPart_001_01C8A1B1.9AC8BFC8--
