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

From: bhaskar_nalamothu at pro-hemns(dot)com (Nalamothu, Bhaskar)
To:
Subject: [Pljava-dev] help :pljava sqlj.install_jar('path', 'jarname', true) running infinitely
Date: 2012-10-23 12:08:36
Message-ID: CAOxerh6MGG6FXRVXWMt6Bii1UWqOme1dDU-qYwhYwEKv3Pknpw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

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/00f52cb9/attachment.html>

In response to

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Hal Hildebrand 2012-10-23 14:16:44 [Pljava-dev] help :pljava sqlj.install_jar('path', 'jarname', true) running infinitely
Previous Message Hal Hildebrand 2012-10-23 11:51:18 [Pljava-dev] help :pljava sqlj.install_jar('path', 'jarname', true) running infinitely