public inbox for [email protected]  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Using JDBC in PL/Java 1.4.0: Statement.executeQuery() automatically closes the statement?
Date: Wed, 04 Jun 2008 09:34:16 -0600
Message-ID: <[email protected]> (raw)
In-Reply-To: <5D63919D95F87E4D9D34FF7748CE2C2A0127B52F@ARVMAIL1.mra.roland-man.biz>
References: <5D63919D95F87E4D9D34FF7748CE2C2A0127B52F@ARVMAIL1.mra.roland-man.biz>

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

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Subject: Re: [Pljava-dev] Using JDBC in PL/Java 1.4.0: Statement.executeQuery() automatically closes the statement?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox