Re: sqlj.install_jar stalls

On 03/11/2013 05:23 AM, vidya.sagar wrote:
> Hi,
>
> I am stuck with this problem since morning... Kindly help
> Postgre stalls ones i run
>
> SELECT
> sqlj.install_jar('file:///full/path/to/mypackage.jar','MyPackage',true);
>
> My Environment is as below:
> Windows7
> postgresql-8.4.12-1-windows
> jdk-1_5_0_06-windows-i586-p
>
>
> PS: SELECT getsysprop('user.home'); stalls when i execute..

Really not enough information to work with.

What is sqlj?
install_jar() is installing a jar to where?
What is getsysprop() supposed to do?
What do the Postgres and system logs show?
Define stall, the procedures stall or the whole database stalls?

>
> Thanks in Advance
> P V Sagar

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com