From: books at ejurka.com (Kris Jurka) Date: Wed, 04 Jun 2008 09:34:16 -0600 Subject: [Pljava-dev] Using JDBC in PL/Java 1.4.0: Statement.executeQuery() automatically closes the statement? In-Reply-To: <5D63919D95F87E4D9D34FF7748CE2C2A0127B52F@ARVMAIL1.mra.roland-man.biz> References: <5D63919D95F87E4D9D34FF7748CE2C2A0127B52F@ARVMAIL1.mra.roland-man.biz> Message-ID: <4846B5F8.4040609@ejurka.com> holger.fleischmann at manroland.com wrote: > > When executing SQL queries inside PL/Java functions it seems that the > java.sql.Statement now gets automatically closed by > Statement.executeQuery(). This leads to a SQLException: "statement is > closed" when calling Statement.getWarnings() afterwards. I've applied the attached patch to CVS to fix this problem. Thanks for the complete report and test case. Kris Jurka -------------- next part -------------- A non-text attachment was scrubbed... Name: dont-close-statement.patch Type: text/x-patch Size: 2721 bytes Desc: not available URL: