[Pljava-dev] ResultSetHandle and TupleDesc reference leak?

From: books at ejurka(dot)com (Kris Jurka)
To:
Subject: [Pljava-dev] ResultSetHandle and TupleDesc reference leak?
Date: 2008-02-01 07:27:26
Message-ID: Pine.BSO.4.64.0802010201430.26244@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

On Sat, 5 Jan 2008, Lucas Madar wrote:

> I have a program using ResultSetHandle and the first time a new session uses
> the function, a warning pops up:
>
> WARNING: TupleDesc reference leak: TupleDesc 0x750bcb0 (10307,-1) still
> referenced
>

I've applied your fix for this.

> Also, I've run into an issue using setSavePoint()... after the function
> ends and the savepoint has been released, the results returned in the
> resultsethandle cannot be used in anything except a simple select. Using
> them as a select into or inside another function fails, saying 'ERROR:
> buffer xxx is not owned by resource owner TopTransaction.' If I don't
> use savepoints, I don't run into this issue. My workaround has been to
> wrap the java function in a plsql function and use commit/rollback
> there.
>

I'm not so sure about this fix and I've left some further comments in the
tracker. I'll try and take a look at this next week, but with the 8.3
server release coming out this weekend we've got to push the 1.4 pljava
release out now.

Kris Jurka

In response to

Browse pljava-dev by date

  From Date Subject
Next Message James Calfee 2008-02-01 20:06:33 [Pljava-dev] pljava.dll - bogus error
Previous Message Kris Jurka 2008-02-01 05:09:25 [Pljava-dev] R: select CURRENT_TIMESTAMP is wrong