[PATCH] Fixed open cursor leaks in Oracle by closing all ResultSets and PreparedStatements

Michael Jaszczyk <[email protected]>
Newsgroups gmane.comp.java.openjms.devel
Message-ID <[email protected]>
-- 
PIRONET NDH
Michael Jaszczyk - Director Software
Maarweg 149 - 161, 50825 Cologne - Germany 
Phone: +49 (0)221 770 1720 - Fax: +49 (0)221 770 1005 
<mailto:[email protected]> - <http://www.pironet-ndh.com/>
Messages.patch (text/plain, 625 B)
Index: Messages.java
===================================================================
RCS file: /cvsroot/openjms/openjms/src/main/org/exolab/jms/persistence/Messages.java,v
retrieving revision 1.23
diff -u -w -i -b -r1.23 Messages.java
--- Messages.java	9 Oct 2003 12:31:25 -0000	1.23
+++ Messages.java	5 Jan 2004 08:57:58 -0000
@@ -579,6 +579,7 @@
                 "delete from messages where expiryTime > 0 and expiryTime < ?");
             delete.setLong(1, time);
             delete.executeUpdate();
+			delete.close();
 
             // delete the message handles
             delete = connection.prepareStatement(
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.