[Pljava-dev] ResultSetHandle and TupleDesc reference leak?

[Kris Jurka]

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