[Pljava-dev] Using JDBC in PL/Java 1.4.0: Statement.executeQuery() automatically closes the statement?

Kris Jurka books at ejurka.com
Wed Jun 4 15:34:16 UTC 2008


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 : http://pgfoundry.org/pipermail/pljava-dev/attachments/20080604/a9b9dd08/attachment.bin 


More information about the Pljava-dev mailing list