From: chantanand at gmail.com (Anantha)
Date: Tue, 7 Dec 2010 20:52:22 -0800 (PST)
Subject: [Pljava-dev] Java VM stalls during
In-Reply-To: <AANLkTi=yWfCoownj+R8GLgmZp0X8xwF2yDNhhYg0wQs1@mail.gmail.com>
References: <AANLkTim7a8zeXKQb35bFdSGuGj2WD2x4ZPP9i_Tr+xcy@mail.gmail.com>
	<1291615093757-3293612.post@n5.nabble.com>
	<AANLkTi=yWfCoownj+R8GLgmZp0X8xwF2yDNhhYg0wQs1@mail.gmail.com>
Message-ID: <1291783942566-3296921.post@n5.nabble.com>


>>> Please provide all relevant errors from the log, if any
--------------------------------------------------
DEBUG:  00000: find_in_dynamic_libpath: trying
"/usr/local/pljava/lib/pljava.so"
LOCATION:  find_in_dynamic_libpath, dfmgr.c:642
STATEMENT:  select
sqlj.install_jar('file:///data1/home/bakumar/Work/Java/classes/Haribol.jar','test_jar',false)
    ;
DEBUG:  00000: Using integer_datetimes
LOCATION:  checkIntTimeType,
/usr/local/src/PLJava/org.postgresql.pljava/src/C/pljava/Backend.c:543
STATEMENT:  select
sqlj.install_jar('file:///data1/home/bakumar/Work/Java/classes/Haribol.jar','test_jar',false)
    ;
DEBUG:  00000: Added JVM option string "-XX:+UseAltSigs"
LOCATION:  JVMOptList_add,
/usr/local/src/PLJava/org.postgresql.pljava/src/C/pljava/Backend.c:436
STATEMENT:  select
sqlj.install_jar('file:///data1/home/bakumar/Work/Java/classes/Haribol.jar','test_jar',false)
    ;
DEBUG:  00000: Added JVM option string
"-Djava.class.path=/usr/local/pljava/pljava.jar"
LOCATION:  JVMOptList_add,
/usr/local/src/PLJava/org.postgresql.pljava/src/C/pljava/Backend.c:436
STATEMENT:  select
sqlj.install_jar('file:///data1/home/bakumar/Work/Java/classes/Haribol.jar','test_jar',false)
    ;
DEBUG:  00000: Added JVM option string
"-Dsqlj.defaultconnection=jdbc:default:connection"
LOCATION:  JVMOptList_add,
/usr/local/src/PLJava/org.postgresql.pljava/src/C/pljava/Backend.c:436
STATEMENT:  select
sqlj.install_jar('file:///data1/home/bakumar/Work/Java/classes/Haribol.jar','test_jar',false)
    ;
DEBUG:  00000: Added JVM option string "vfprintf"
LOCATION:  JVMOptList_add,
/usr/local/src/PLJava/org.postgresql.pljava/src/C/pljava/Backend.c:436
STATEMENT:  select
sqlj.install_jar('file:///data1/home/bakumar/Work/Java/classes/Haribol.jar','test_jar',false)
    ;
DEBUG:  00000: Added JVM option string "-Xrs"
LOCATION:  JVMOptList_add,
/usr/local/src/PLJava/org.postgresql.pljava/src/C/pljava/Backend.c:436
STATEMENT:  select
sqlj.install_jar('file:///data1/home/bakumar/Work/Java/classes/Haribol.jar','test_jar',false)
    ;
DEBUG:  00000: Creating JavaVM
LOCATION:  initializeJavaVM,
/usr/local/src/PLJava/org.postgresql.pljava/src/C/pljava/Backend.c:675
STATEMENT:  select
sqlj.install_jar('file:///data1/home/bakumar/Work/Java/classes/Haribol.jar','test_jar',false)
    ;
DEBUG:  00000: my backend id is 5
LOCATION:  SharedInvalBackendInit, sinvaladt.c:316
DEBUG:  00000: StartTransaction
--------------------------------------------------


>>> CREATE FUNCTION getsysprop(VARCHAR) 
>>>   RETURNS VARCHAR 
>>>   AS 'java.lang.System.getProperty' 
>>>   LANGUAGE java; 
I could create function.

>>> SELECT getsysprop('user.home'); 

>>> work? 
No it did not work. When i send SELECT query, "psql" hangs. Please refer
below:
-----------------------------------------
=# SELECT getsysprop('user.home');
^CCancel request sent
^CCancel request sent



-- 
View this message in context: http://postgresql.1045698.n5.nabble.com/Java-VM-stalls-during-install-jar-tp3290754p3296921.html
Sent from the PL/Java mailing list archive at Nabble.com.