From: thomas at tada.se (Thomas Hallgren)
Date: Mon, 23 Jan 2006 12:51:02 +0100
Subject: [Pljava-dev] ResultSetHandle problem
In-Reply-To: <43D22281.60303@tada.se>
References: <20060121111950.70420890F7@smtp.263.net> <43D22281.60303@tada.se>
Message-ID: <43D4C326.2020908@tada.se>

Hi,
The bug concerning different return types for methods using SETOF RECORD
(http://gborg.postgresql.org/project/pljava/bugs/bugupdate.php?1440) is
resolved and new source is available in CVS HEAD. You're welcome to try
it out. If you don't have access to CVS you may use a temporary source
bundle (http://www.tada.se/pub/pljava-src-1.2.dev.tar.gz).

Please let me know how if you have further problems.

Regards,
Thomas Hallgren

Thomas Hallgren wrote:
> Lifeng,
> This is a known bug
> (http://gborg.postgresql.org/project/pljava/bugs/bugupdate.php?1440).
> The only way to solve it properly is to fix that bug. I haven't got
> around to it just yet.
>
> Kind regards,
> Thomas Hallgren
>
>
> lifeng wrote:
>   
>> 	I have a function returning set of "record", i.e. there is no information about the target structure to return until it is actually called. If I call such a function several times with different target structures within one session, I got one of two following errors:
>>
>> 1)
>> ERROR:  query-specified return row and actual function return row do not match   
>> 2)
>> ERROR:  java.lang.ArrayIndexOutOfBoundsException: 2
>>
>> 	If I call such a function several times with different target structures within different sessions, I can got correct result. I guess that pljava caches the first target structure, though I think that it should be replaced by a new target structure when  I called it with different target structure. When I test the function with 'sql' language , it is correct. There should be erro in pljava, not in PostgreSQL.
>>
>>     How can I solve the problem?
>>
>>  	Regards
>>   		lifeng
>> 		
>> ????????lifenggod at 263.net
>> ??????????2006-01-21
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>   
>>     
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>