agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] is it a bug? passing recordset into java procedure
Date: Sun, 12 Aug 2007 13:40:51 +1200
Message-ID: <1639850306.20070812134051@ruban.biz> (raw)

Hello pljava-dev,

I'm running postgres 8.2.4 on windows xp. I installed pljava which is
included into win distributive. It works fine except only one thing.

I created simple function in java:

public static String testRS(ResultSet rs) throws SQLException {
       String result = "test";
       //rs.close();
       return result;
}

this function is supposed to read data from recordset and transform it
into a string.

When i try to call this simple function from postgres by executing
following query:

SELECT sp_testrs(t.*) FROM table t WHERE t.id = [some id of existing
record];

I get the expected "test" result, but i also get following message:

WARNING:  TupleDesc reference leak: TupleDesc 07ACE448 (59891,-1) still referenced

I tried to close record set inside my java procedure but i still get
this warning.

Any ideas what could cause this? Thanks.

-- 
Best regards,
 Dmitry                          mailto:dmitry at ruban.biz

Message-ID: <1639850306.20070812134051@ruban.biz>
Permalink:  ../1639850306.20070812134051@ruban.biz/
Also on:    postgresql.org/message-id/1639850306.20070812134051@ruban.biz

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] is it a bug? passing recordset into java procedure
  In-Reply-To: <1639850306.20070812134051@ruban.biz>

* 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