[Pljava-dev] help :pljava sqlj.install_jar('path', 'jarname', true) running infinitely

Did you build these binaries or pull them. I'm not as up on pljava internals as I should be, but it looks like you're running Postgres 8.4. Any reason for that? Can you move to at least 9.1? Might be worth a try.

Sent from my Tricorder

On Oct 23, 2012, at 5:08 AM, "Nalamothu, Bhaskar" <bhaskar_nalamothu at pro-hemns.com> wrote:

> Thanks for the qucik replies. It still returning me the same error even with jdk 1.5.
>
> was there anything wrong with environment variables setting.I have configured env variables in system variables as follows
>
> path:C:\Program Files (x86)\Java\jdk1.5.0_22\jre\bin;C:\Program Files (x86)\PostgreSQL\8.4\bin;C:\Program Files (x86)\PostgreSQL\8.4\lib;C:\Program Files (x86)\Java\jre1.5.0_22\bin\client
>
> CLASSPATH:C:\Program Files (x86)\PostgreSQL\8.4\lib;C:\Program Files (x86)\PostgreSQL\8.4\lib\pljava.jar;C:\Program Files (x86)\Java\jdk1.5.0_22\jre\lib\rt.jar
>
> please find the below error with jdk 1.5
>
> #
> # An unexpected error has been detected by HotSpot Virtual Machine:
> #
> # EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x0041384c, pid=3736, tid=1612
> #
> # Java VM: Java HotSpot(TM) Client VM (1.5.0_22-b03 mixed mode, sharing)
> # Problematic frame:
> # C [postgres.exe+0x1384c]
> #
>
> --------------- T H R E A D ---------------
>
> Current thread (0x04b61768): JavaThread "main" [_thread_in_native, id=1612]
>
> siginfo: ExceptionCode=0xc0000005, reading address 0x000002bd
>
> Registers:
> EAX=0x00000001, EBX=0x00000000, ECX=0x0000001a, EDX=0x015164e0
> ESP=0x00cbef34, EBP=0x048e40d0, ESI=0x000002bd, EDI=0x048e40f0
> EIP=0x0041384c, EFLAGS=0x00010202
>
> Top of Stack: (sp=0x00cbef34)
> 0x00cbef34: 00000000 00000000 00cbef60 048d9458
> 0x00cbef44: 67d11b21 015159d0 04b61828 00cbef70
> 0x00cbef54: 67d062ec 04b61828 6d64b174 00cbef70
> 0x00cbef64: 67d11b77 015159d0 01525190 00cbef90
> 0x00cbef74: 67d0f36a 015159d0 6d6c3908 04b61768
> 0x00cbef84: 28079528 28079520 04b61768 00cbefc4
> 0x00cbef94: 04c582ff 04b61828 00cbefcc 01525190
> 0x00cbefa4: 00000000 00cbefa8 28079520 00cbefd8
>
> Instructions: (pc=0x0041384c)
> 0x0041383c: 7d 04 8b 34 82 8b 3c 87 b9 1a 00 00 00 83 c0 01
> 0x0041384c: f3 a5 3b 45 00 7c e1 85 db 0f 84 14 01 00 00 a1
>
>
> Stack: [0x008c0000,0x00cc0000), sp=0x00cbef34, free space=4091k
> Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code)
> C [postgres.exe+0x1384c]
>
> Java frames: (J=compiled Java code, j=interpreted, Vv=VM code)
> j org.postgresql.pljava.internal.Portal._getTupleDesc(J)Lorg/postgresql/pljava/internal/TupleDesc;+0
> j org.postgresql.pljava.internal.Portal.getTupleDesc()Lorg/postgresql/pljava/internal/TupleDesc;+10
> j org.postgresql.pljava.jdbc.SPIResultSet.<init>(Lorg/postgresql/pljava/jdbc/SPIStatement;Lorg/postgresql/pljava/internal/Portal;I)V+25
> j org.postgresql.pljava.jdbc.SPIStatement.executePlan(Lorg/postgresql/pljava/internal/ExecutionPlan;[Ljava/lang/Object;)Z+42
> j org.postgresql.pljava.jdbc.SPIPreparedStatement.execute()Z+62
> j org.postgresql.pljava.jdbc.SPIPreparedStatement.executeQuery()Ljava/sql/ResultSet;+1
> j org.postgresql.pljava.sqlj.Loader.getSchemaLoader(Ljava/lang/String;)Ljava/lang/ClassLoader;+90
> j org.postgresql.pljava.sqlj.Loader.getTypeMap(Ljava/lang/String;)Ljava/util/Map;+54
> v ~StubRoutines::call_stub
>
> --------------- P R O C E S S ---------------
>
> Java Threads: ( => current thread )
> 0x04bdda30 JavaThread "Low Memory Detector" daemon [_thread_blocked, id=2692]
> 0x04c0b948 JavaThread "CompilerThread0" daemon [_thread_blocked, id=3772]
> 0x04bdbbc0 JavaThread "Finalizer" daemon [_thread_blocked, id=2996]
> 0x04bdadf8 JavaThread "Reference Handler" daemon [_thread_blocked, id=3528]
> =>0x04b61768 JavaThread "main" [_thread_in_native, id=1612]
>
> Other Threads:
> 0x04bd9988 VMThread [id=3592]
> 0x04bc9df8 WatcherThread [id=3960]
>
> VM state:not at safepoint (normal execution)
>
> VM Mutex/Monitor currently owned by a thread: None
>
> Heap
> def new generation total 576K, used 523K [0x24040000, 0x240e0000, 0x24520000)
> eden space 512K, 99% used [0x24040000, 0x240bfc10, 0x240c0000)
> from space 64K, 19% used [0x240c0000, 0x240c3228, 0x240d0000)
> to space 64K, 0% used [0x240d0000, 0x240d0000, 0x240e0000)
> tenured generation total 1408K, used 144K [0x24520000, 0x24680000, 0x28040000)
> the space 1408K, 10% used [0x24520000, 0x24544070, 0x24544200, 0x24680000)
> compacting perm gen total 8192K, used 457K [0x28040000, 0x28840000, 0x2c040000)
> the space 8192K, 5% used [0x28040000, 0x280b2638, 0x280b2800, 0x28840000)
> ro space 8192K, 63% used [0x2c040000, 0x2c553e78, 0x2c554000, 0x2c840000)
> rw space 12288K, 47% used [0x2c840000, 0x2cde8b00, 0x2cde8c00, 0x2d440000)
>
> Dynamic libraries:
> 0x00400000 - 0x008b5000 C:\Program Files (x86)\PostgreSQL\8.4\bin\postgres.exe
> 0x77af0000 - 0x77c70000 C:\Windows\SysWOW64\ntdll.dll
> 0x76dd0000 - 0x76ed0000 C:\Windows\syswow64\kernel32.dll
> 0x77370000 - 0x773b6000 C:\Windows\syswow64\KERNELBASE.dll
> 0x10000000 - 0x10034000 C:\Program Files (x86)\PostgreSQL\8.4\bin\SSLEAY32.dll
> 0x00130000 - 0x0022f000 C:\Program Files (x86)\PostgreSQL\8.4\bin\LIBEAY32.dll
> 0x74f20000 - 0x74f27000 C:\Windows\system32\WSOCK32.dll
> 0x76ac0000 - 0x76af5000 C:\Windows\syswow64\WS2_32.dll
> 0x774b0000 - 0x7755c000 C:\Windows\syswow64\msvcrt.dll
> 0x76880000 - 0x76970000 C:\Windows\syswow64\RPCRT4.dll
> 0x75660000 - 0x756c0000 C:\Windows\syswow64\SspiCli.dll
> 0x75650000 - 0x7565c000 C:\Windows\syswow64\CRYPTBASE.dll
> 0x76330000 - 0x76349000 C:\Windows\SysWOW64\sechost.dll
> 0x76b00000 - 0x76b06000 C:\Windows\syswow64\NSI.dll
> 0x76450000 - 0x764e0000 C:\Windows\syswow64\GDI32.dll
> 0x76350000 - 0x76450000 C:\Windows\syswow64\USER32.dll
> 0x77280000 - 0x77320000 C:\Windows\syswow64\ADVAPI32.dll
> 0x76310000 - 0x7631a000 C:\Windows\syswow64\LPK.dll
> 0x767e0000 - 0x7687d000 C:\Windows\syswow64\USP10.dll
> 0x74e80000 - 0x74f1b000 C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4927_none_d08a205e442db5b5\MSVCR80.dll
> 0x61cc0000 - 0x61cd3000 C:\Program Files (x86)\PostgreSQL\8.4\bin\libintl-8.dll
> 0x66000000 - 0x660e7000 C:\Program Files (x86)\PostgreSQL\8.4\bin\libiconv-2.dll
> 0x1c000000 - 0x1c09b000 C:\Program Files (x86)\PostgreSQL\8.4\bin\krb5_32.dll
> 0x00240000 - 0x00247000 C:\Program Files (x86)\PostgreSQL\8.4\bin\comerr32.dll
> 0x00250000 - 0x00258000 C:\Program Files (x86)\PostgreSQL\8.4\bin\k5sprt32.dll
> 0x7c340000 - 0x7c396000 C:\Program Files (x86)\PostgreSQL\8.4\bin\MSVCR71.dll
> 0x002e0000 - 0x00301000 C:\Program Files (x86)\PostgreSQL\8.4\bin\gssapi32.dll
> 0x00cc0000 - 0x00db1000 C:\Program Files (x86)\PostgreSQL\8.4\bin\libxml2.dll
> 0x00310000 - 0x003e9000 C:\Program Files (x86)\PostgreSQL\8.4\bin\iconv.dll
> 0x00dc0000 - 0x00dd3000 C:\Program Files (x86)\PostgreSQL\8.4\bin\zlib1.dll
> 0x750c0000 - 0x750c8000 C:\Windows\system32\Secur32.dll
> 0x77320000 - 0x77365000 C:\Windows\syswow64\WLDAP32.dll
> 0x773c0000 - 0x77420000 C:\Windows\system32\IMM32.DLL
> 0x769d0000 - 0x76a9c000 C:\Windows\syswow64\MSCTF.dll
> 0x74d50000 - 0x74d8c000 C:\Windows\system32\mswsock.dll
> 0x74d40000 - 0x74d45000 C:\Windows\System32\wshtcpip.dll
> 0x74d30000 - 0x74d36000 C:\Windows\System32\wship6.dll
> 0x67d00000 - 0x67d2a000 C:\Program Files (x86)\PostgreSQL\8.4\lib\pljava.dll
> 0x6d640000 - 0x6d7de000 C:\Program Files (x86)\Java\jre1.5.0_22\bin\client\jvm.dll
> 0x74c00000 - 0x74c32000 C:\Windows\system32\WINMM.dll
> 0x74e30000 - 0x74e7b000 C:\Windows\system32\apphelp.dll
> 0x6d290000 - 0x6d298000 C:\Program Files (x86)\Java\jre1.5.0_22\bin\hpi.dll
> 0x76320000 - 0x76325000 C:\Windows\syswow64\PSAPI.DLL
> 0x6d610000 - 0x6d61c000 C:\Program Files (x86)\Java\jre1.5.0_22\bin\verify.dll
> 0x6d310000 - 0x6d32d000 C:\Program Files (x86)\Java\jre1.5.0_22\bin\java.dll
> 0x6d630000 - 0x6d63f000 C:\Program Files (x86)\Java\jre1.5.0_22\bin\zip.dll
> 0x756c0000 - 0x76309000 C:\Windows\syswow64\SHELL32.DLL
> 0x76c60000 - 0x76cb7000 C:\Windows\syswow64\SHLWAPI.dll
> 0x77590000 - 0x776ec000 C:\Windows\syswow64\ole32.dll
> 0x72db0000 - 0x72f4e000 C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16385_none_421189da2b7fabfc\comctl32.dll
> 0x76f30000 - 0x76fbf000 C:\Windows\syswow64\OLEAUT32.dll
> 0x76fc0000 - 0x7715d000 C:\Windows\syswow64\SETUPAPI.dll
> 0x76970000 - 0x76997000 C:\Windows\syswow64\CFGMGR32.dll
> 0x76aa0000 - 0x76ab2000 C:\Windows\syswow64\DEVOBJ.dll
> 0x76d40000 - 0x76dc3000 C:\Windows\syswow64\CLBCatQ.DLL
> 0x74280000 - 0x74375000 C:\Windows\system32\propsys.dll
>
> VM Arguments:
> jvm_args: -Dsqlj.defaultconnection=jdbc:default:connection vfprintf -Xrs
> java_command: <unknown>
> Launcher Type: generic
>
> Environment Variables:
> CLASSPATH=C:\Program Files (x86)\PostgreSQL\8.4\lib;C:\Program Files (x86)\PostgreSQL\8.4\lib\pljava.jar;C:\Program Files (x86)\Java\jdk1.5.0_22\jre\lib\rt.jar
> PATH=C:\Program Files (x86)\Java\jdk1.5.0_22\jre\bin;C:\Program Files (x86)\PostgreSQL\8.4\bin;C:\Program Files (x86)\PostgreSQL\8.4\lib;C:\Program Files (x86)\Java\jre1.5.0_22\bin\client
> USERNAME=postgres
> OS=Windows_NT
> PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 15 Stepping 13, GenuineIntel
>
>
>
> --------------- S Y S T E M ---------------
>
> OS: Windows 7 , 64 bit Build 7600
>
> CPU:total 2 (cores per cpu 2, threads per core 1) family 6 model 15 stepping 13, cmov, cx8, fxsr, mmx, sse, sse2
>
> Memory: 4k page, physical 1013736k(222956k free), swap 2062312k(996460k free)
>
> vm_info: Java HotSpot(TM) Client VM (1.5.0_22-b03) for windows-x86, built on Oct 9 2009 01:15:45 by "java_re" with MS VC++ 6.0
>
> time: Tue Oct 23 17:31:51 2012
> elapsed time: 3 seconds
>
>
> --
> Sudha Bhaskar N
> Procreate Techno Systems pvt ltd
> +91-9948-678-222
>
>
>
> On Tue, Oct 23, 2012 at 5:21 PM, Hal Hildebrand <hal.hildebrand at me.com> wrote:
>> I successfully use 1.6, but only on Linux.
>>
>> Also, I should point out that 1.6 has been eol'd by oracle. Has pl/java stalled or....?
>>
>> Sent from my Tricorder
>>
>> On Oct 23, 2012, at 1:50 AM, John R Pierce <pierce at hogranch.com> wrote:
>>
>> > On 10/22/12 9:43 PM, Nalamothu, Bhaskar wrote:
>> >> # JRE version: 6.0_14-b08
>> >> # Java VM: Java HotSpot(TM) Client VM (14.0-b16 mixed mode, sharing windows-x86 )
>> >> # Problematic frame:
>> >> # C [postgres.exe+0x1384c]
>> >
>> > last I heard, pljava only supports JRE 1.4 or 5, not 6.
>> >
>> >
>> >
>> > --
>> > john r pierce N 37, W 122
>> > santa cruz ca mid-left coast
>> >
>> > _______________________________________________
>> > Pljava-dev mailing list
>> > Pljava-dev at pgfoundry.org
>> > http://pgfoundry.org/mailman/listinfo/pljava-dev
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20121023/46beee95/attachment.html>