[Pljava-dev] Java VM stalls during

Hi,

On Mon, Dec 6, 2010 at 5:58 AM, Anantha <chantanand at gmail.com> wrote:
>
>>>> PS:
>
>>>> ? ? ?Before moving to FreeBSD OS, i have tested the same in UBUNTU OS
>>>> (2.6.31-
>
>>>> ?14-server #48-Ubuntu SMP). I could install jar, could create pljava
>>>> function
>
>>>> and execute through "psql".)
>
> One more additional information is, in UBUNTU testing i have used JDK
> pre-built release from Oracle jun Java website. Whereas in FreeBSD, i find
> diablo-jdk1.5 amd64 pre-built package did not ?work (in libjvm.so has
> reference to "pthread_create" function, but "ldd" showed no dependancy
> libpthread.so library). Due to this pljava install failed. So i have
> download jdk sources using FreeBSD ports and built JDK1.5. In this version,
> i could install pljava, but install_jar fails.
> I am blocked due to this bug. Any help on this issue is grealy appreciated!

Please provide all relevant errors from the log, if any.

Does

CREATE FUNCTION getsysprop(VARCHAR)
RETURNS VARCHAR
AS 'java.lang.System.getProperty'
LANGUAGE java;

SELECT getsysprop('user.home');

work?

Johann