agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] retaining prepared statements across stored procedure calls
Date: Mon, 11 Apr 2011 20:01:10 +0000
Message-ID: <DUB103-w4058D109F7165ACBB748BCBEA80@phx.gbl> (raw)
Hi,
I have a stored procedure class that looks like this:
class TestSP{ public static TestSP testSP = null; // singleton instance public PreparedStatement stmt; // member variable
TestSP() throws SQLException { Connection conn = DriverManager.getConnection("jdbc:default:connection"); this.stmt = conn.prepareStatement("select 1"); conn.close(); }
// stored procedure public static int callProc () throws SQLException { if (testSP == null) testSP = new TestSP();
ResultSet rs = testSP.testStmt.executeQuery();
rs.next(); return(rs.getInt(1)); }}
When I call callProc in psql, I get a warning about closing 1 forgotten statement. Does that mean I cannot have prepared statements lingering around after each store procedure invocation?
Thanks,Alvin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110411/bc9548d7/attachment.html;
view thread (4+ messages) latest in thread
Message-ID: <DUB103-w4058D109F7165ACBB748BCBEA80@phx.gbl>
Permalink: ../DUB103-w4058D109F7165ACBB748BCBEA80@phx.gbl/
Also on: postgresql.org/message-id/DUB103-w4058D109F7165ACBB748BCBEA80@phx.gbl
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: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] retaining prepared statements across stored procedure calls
In-Reply-To: <DUB103-w4058D109F7165ACBB748BCBEA80@phx.gbl>
* 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