From: thhal at mailblocks.com (Thomas Hallgren) Date: Thu, 02 Dec 2004 11:09:30 +0100 Subject: [Pljava-dev] ERROR: Unable to find static method... In-Reply-To: <001101c4d817$1fdea970$dc8055aa@mlcamer> References: <001101c4d817$1fdea970$dc8055aa@mlcamer> Message-ID: <41AEE9DA.3040301@mailblocks.com> Morgan Cameron wrote: >I am trying to develop a view that calls a function that will ultimately >make a separate connection to a XML database and return attributes back into >the view, but for testing it simply returns dummy values. In selecting from >the view, I find that I'm getting "method not found" errors on the first and >second query attempts, but it succeeds on the third! > >PostgreSQL log file is attached. > >Would "preloading" the pljava library help? I used "preload_libraries = >'/pgsql/lib/libpljava'", but the system appears to hang after the point of >"Creating JavaVM" (no more messages appear in the log file after that point, >even at debug level 5). Eventually I would like to preload the java >libraries since the code will get used quite heavily. > > Intriguing bug indeed. I don't think that preloading will sovle this one. Thank you very much for an extensive and complete bug report. I'll look in to this ASAP. Regards, Thomas Hallgren