From: thomas at tada.se (Thomas Hallgren)
Date: Thu, 01 Dec 2005 08:07:19 +0100
Subject: [Pljava-dev] select sqlj.install_jar error with Gentoo
In-Reply-To: <20051201015449.38676.qmail@web34715.mail.mud.yahoo.com>
References: <20051201015449.38676.qmail@web34715.mail.mud.yahoo.com>
Message-ID: <438EA127.2020500@tada.se>

Hi Yang,
No special vmoptions should need to be configured. Can you please tell me:
1. What OS are you on?
2. Are you using any special flags when you compile PL/Java or just 'make'?
3. Can you see some additional info in the backend log file?

Also, perhaps you can try and set "log_min_messages = debug1" in your 
postgresql.conf, restart and reproduce the error, and then again check 
the backend log. I'm interested in the messages that might precede your 
error in that log.

I'm concerned that you cannot get the libpljava.so to load without 
copying it. It should load just fine by just setting 
"dynamic_library_path = '$libdir:<your pljava root>/build/objs'" in 
postgresql.conf. Are you sure that's the setting you are using (and that 
you remove the leading # on that line)?

Regards,
Thomas Hallgren

yaer yang wrote:
> Dear Thomas,
> i 'm developing application with kompiere.all of thing had been 
> installed in the server Gentoo.
> when i run  SELECT sqlj.install_jar('file:///u01/app/sqlj/sqlj.jar', 
> 'sqlj', true);,the error is :
> INFO:  Exception
> INFO:  in thread "main"
> ERROR:  Java exit monitor failure (final).
> i use postgresql 8.0.3,what i have done is:
> 1.compile sqlj.jar with java version "1.5.0_05"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_05-b05)
> Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_05-b05, mixed mode).
> 2.compile pljava-1.2.0 source code with above java vms.
> 3.copy pljava-1.2.0/build/objs/libpl*  to /usr/lib64 and 
> /usr/lib64/postgresql(becauce i have get error cann't load 
> libpljava.so,then resolved the error with above method,not with your 
> advice in the maillist.i have tried the most advices)
> 4.then when i select in the database,i get the above error.
> can you g ive me some help?maybe i need to configure
> pljava.vmoptions = ...(postgresql.conf) with specicel ?
> regards,yang
>   
>
> ------------------------------------------------------------------------
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free. 
> <http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/> 
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>