agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] ResultSetHandle and TupleDesc reference leak?
Date: Sat, 5 Jan 2008 01:57:44 -0800
Message-ID: <E7B8DAEA-F046-4272-9C84-BBCB05BE373F@mcsnw.com> (raw)

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

To be sure this wasn't my code, I used the exact example code shown in http://wiki.tada.se/display/pljava/Functions+returning+sets 
.

# select * from javatest.listNonSupers();
WARNING:  TupleDesc reference leak: TupleDesc 0x57aba8 (10307,-1)  
still referenced
  usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd   
| valuntil | useconfig
----------+----------+-------------+----------+-----------+---------- 
+----------+-----------
  xxxxxxxx |    24576 | f           | f        | f         | ********  
|          |
  xxxxxxxx |    32768 | f           | f        | f         | ********  
|          |

Everything seems to work properly, but the warning is somewhat  
disconcerting.

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.

Thanks,
Lucas Madar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20080105/97f1ab87/attachment.html;

view thread (3+ messages)  latest in thread

Message-ID: <E7B8DAEA-F046-4272-9C84-BBCB05BE373F@mcsnw.com>
Permalink:  ../E7B8DAEA-F046-4272-9C84-BBCB05BE373F@mcsnw.com/
Also on:    postgresql.org/message-id/E7B8DAEA-F046-4272-9C84-BBCB05BE373F@mcsnw.com

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] ResultSetHandle and TupleDesc reference leak?
  In-Reply-To: <E7B8DAEA-F046-4272-9C84-BBCB05BE373F@mcsnw.com>

* 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