Thread: sqlj.install_jar stalls

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..

Thanks in Advance
P V Sagar





--
View this message in context: http://postgresql.1045698.n5.nabble.com/sqlj-install-jar-stalls-tp5748119.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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.klaver@gmail.com