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

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