From: lifenggod at 263.net (lifeng) Date: Wed, 25 Jan 2006 09:27:01 +0800 Subject: [Pljava-dev] ResultSetHandle problem Message-ID: <20060125012712.22AC08C7BE@smtp.263.net> Thomas Hallgren,??? I have tested it ,it's ok. I think the problem is eventually solved.But i wanted to know where the bug was in the source code .Can you tell me how modified the bug in the source code? Thanks. ======= 2006-01-23 19:51:02 ????????======= >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 >> > > >. = = = = = = = = = = = = = = = = = = = = ????????? ?? ????????lifeng ????????lifenggod at 263.net ??????????2006-01-25