[Pljava-dev] ResultSetHandle problem

From: lifenggod at 263(dot)net (lifeng)
To:
Subject: [Pljava-dev] ResultSetHandle problem
Date: 2006-01-21 11:19:43
Message-ID: 20060121111950.70420890F7@smtp.263.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

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

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Thomas Hallgren 2006-01-21 12:01:05 [Pljava-dev] ResultSetHandle problem
Previous Message Thomas Hallgren 2006-01-12 18:34:55 [Pljava-dev] pljava on x86_64