From: joves.luo at gmail.com (Joves Luo) Date: Tue, 29 Mar 2005 10:52:20 -0500 Subject: [Pljava-dev] java.lang.SecurityException Message-ID: I had to change my e-mail. My work e-mail wasn't receiveing the messages (reason why I had to start a new thread everytime). Thanks Filip for your help. I've gotten one step closer to finishing this up. But now when I start postgresql and run the function I get this: LOG: LOG: An unexpected exception has been detected in native code outside the VM. LOG: Unexpected Signal : 4 occurred at PC=0x4915444C LOG: Function= LOG: [Unknown. LOG: ] LOG: Library=(N/A) LOG: LOG: NOTE: We are unable to locate the function name symbol for the error LOG: just occurred. Please refer to release documentation for possible LOG: reason and solutions. LOG: LOG: LOG: Current Java thread: LOG: LOG: Dynamic libraries: LOG: 08048000-08282000 r-xp 00000000 03:05 362139 /usr/bin/postgres LOG: 08282000-0828c000 rw-p 00239000 03:05 362139 /usr/bin/postgres LOG: 40000000-40012000 r-xp 00000000 03:05 3759355 /lib/ld-2.3.2.so LOG: 40012000-40013000 rw-p 00011000 03:05 3759355 /lib/ld-2.3.2.so LOG: 40013000-40017000 rw-s 00000000 03:05 8667673 /tmp/hsperfdata_postgres/2317 LOG: 40017000-4001a000 r--s 00000000 03:05 7452900 /usr/lib/jre/lib/ext/dnsns.jar LOG: 4001c000-40023000 r-xp 00000000 03:05 3759347 /lib/libpam.so.0.75 LOG: 40023000-40024000 rw-p 00006000 03:05 3759347 /lib/libpam.so.0.75 LOG: 40024000-4004e000 r-xp 00000000 03:05 3759341 /lib/libssl.so.0.9.6b LOG: 4004e000-40051000 rw-p 00029000 03:05 3759341 /lib/libssl.so.0.9.6b LOG: 40051000-40108000 r-xp 00000000 03:05 3759340 /lib/libcrypto.so.0.9.6b LOG: 40108000-40113000 rw-p 000b7000 03:05 3759340 /lib/libcrypto.so.0.9.6b LOG: 40117000-40123000 r-xp 00000000 03:05 377925 /usr/lib/libz.so.1.1.3 LOG: 40123000-40125000 rw-p 0000b000 03:05 377925 /usr/lib/libz.so.1.1.3 LOG: 40125000-40146000 r-xp 00000000 03:05 377832 /usr/lib/libreadline.so.4.2 LOG: 40146000-4014a000 rw-p 00021000 03:05 377832 /usr/lib/libreadline.so.4.2 LOG: 4014b000-4014e000 r-xp 00000000 03:05 3759337 /lib/libtermcap.so.2.0.8 LOG: 4014e000-4014f000 rw-p 00002000 03:05 3759337 /lib/libtermcap.so.2.0.8 LOG: 40150000-40154000 r-xp 00000000 03:05 3759276 /lib/libcrypt-2.3.2.so LOG: 40154000-40155000 rw-p 00003000 03:05 3759276 /lib/libcrypt-2.3.2.so LOG: 4017c000-40189000 r-xp 00000000 03:05 3759310 /lib/libresolv-2.3.2.so LOG: 40189000-4018a000 rw-p 0000d000 03:05 3759310 /lib/libresolv-2.3.2.so LOG: 4018c000-4019c000 r-xp 00000000 03:05 3759282 /lib/libnsl-2.3.2.so LOG: 4019c000-4019d000 rw-p 00010000 03:05 3759282 /lib/libnsl-2.3.2.so LOG: 4019f000-401a1000 r-xp 00000000 03:05 3759278 /lib/libdl-2.3.2.so LOG: 401a1000-401a2000 rw-p 00001000 03:05 3759278 /lib/libdl-2.3.2.so LOG: 401a2000-401c2000 r-xp 00000000 03:05 3759280 /lib/libm-2.3.2.so LOG: 401c2000-401c3000 rw-p 00020000 03:05 3759280 /lib/libm-2.3.2.so LOG: 401c3000-402e2000 r-xp 00000000 03:05 3759274 /lib/libc-2.3.2.so LOG: 402e2000-402e6000 rw-p 0011e000 03:05 3759274 /lib/libc-2.3.2.so LOG: 402e9000-402f3000 r-xp 00000000 03:05 3759298 /lib/libnss_files-2.3.2.so LOG: 402f3000-402f4000 rw-p 00009000 03:05 3759298 /lib/libnss_files-2.3.2.so LOG: 402f4000-40cd6000 rw-s 00000000 00:04 393218 /SYSV0052e2c1 (deleted) LOG: 40cf7000-40d11000 r-xp 00000000 03:02 409682 /var/lib/pgsql/pljava/libpljava.so LOG: 40d11000-40d13000 rw-p 00019000 03:02 409682 /var/lib/pgsql/pljava/libpljava.so LOG: 40d13000-4110f000 r-xp 00000000 03:05 8634864 /usr/lib/jre/lib/i386/client/libjvm.so LOG: 4110f000-4112b000 rw-p 003fb000 03:05 8634864 /usr/lib/jre/lib/i386/client/libjvm.so LOG: 4113d000-4114b000 r-xp 00000000 03:05 3759308 /lib/libpthread-0.10.so LOG: 4114b000-4114e000 rw-p 0000e000 03:05 3759308 /lib/libpthread-0.10.so LOG: 4118e000-41196000 r-xp 00000000 03:05 8733367 /usr/lib/jre/lib/i386/native_threads/libhpi.so LOG: 41196000-41197000 rw-p 00007000 03:05 8733367 /usr/lib/jre/lib/i386/native_threads/libhpi.so LOG: 41197000-411a7000 r-xp 00000000 03:05 8060343 /usr/lib/jre/lib/i386/libverify.so LOG: 411a7000-411a9000 rw-p 0000f000 03:05 8060343 /usr/lib/jre/lib/i386/libverify.so LOG: 411a9000-411c9000 r-xp 00000000 03:05 8060329 /usr/lib/jre/lib/i386/libjava.so LOG: 411c9000-411cb000 rw-p 0001f000 03:05 8060329 /usr/lib/jre/lib/i386/libjava.so LOG: 411cb000-411df000 r-xp 00000000 03:05 8060344 /usr/lib/jre/lib/i386/libzip.so LOG: 411df000-411e2000 rw-p 00013000 03:05 8060344 /usr/lib/jre/lib/i386/libzip.so LOG: 411e2000-428cc000 r--s 00000000 03:05 1362607 /usr/lib/jre/lib/rt.jar LOG: 42916000-4292c000 r--s 00000000 03:05 1362608 /usr/lib/jre/lib/sunrsasign.jar LOG: 4292c000-42a05000 r--s 00000000 03:05 1362600 /usr/lib/jre/lib/jsse.jar LOG: 42a05000-42a16000 r--s 00000000 03:05 1362599 /usr/lib/jre/lib/jce.jar LOG: 42a16000-42f5f000 r--s 00000000 03:05 1362536 /usr/lib/jre/lib/charsets.jar LOG: 4d090000-4d14b000 r--s 00000000 03:05 7452902 /usr/lib/jre/lib/ext/localedata.jar LOG: 4d14b000-4d158000 r--s 00000000 03:05 7452901 /usr/lib/jre/lib/ext/ldapsec.jar LOG: 4d158000-4d174000 r--s 00000000 03:05 7452903 /usr/lib/jre/lib/ext/sunjce_provider.jar LOG: 4d174000-4d193000 r--s 00000000 03:02 409684 /var/lib/pgsql/pljava/pljava.jar LOG: LOG: Heap at VM Abort: LOG: LOG: Heap LOG: def new generation LOG: total 576K, used 217K LOG: [0x45010000, 0x450b0000, 0x454f0000) LOG: eden LOG: space 512K, 291087438054sed LOG: [0x45010000, 0x45036638, 0x45090000) LOG: from LOG: space 64K, 1001087438054sed LOG: [0x45090000, 0x450a0000, 0x450a0000) LOG: to LOG: space 64K, 01087438054sed LOG: [0x450a0000, 0x450a0000, 0x450b0000) LOG: tenured generation LOG: total 1408K, used 178K LOG: [0x454f0000, 0x45650000, 0x49010000) LOG: the LOG: space 1408K, 121087438054sed LOG: [0x454f0000, 0x4551cba0, 0x4551cc00, 0x45650000) LOG: compacting perm gen LOG: total 4096K, used 2170K LOG: [0x49010000, 0x49410000, 0x4d010000) LOG: the LOG: space 4096K, 521087438054sed LOG: [0x49010000, 0x4922e8b8, 0x4922ea00, 0x49410000) LOG: LOG: Local Time = Tue Mar 29 05:41:53 2005 LOG: Elapsed Time = 0 LOG: # LOG: # The exception above was detected in native code outside the VM LOG: # LOG: # Java VM: Java HotSpot(TM) Client VM (1.4.2_06-b03 mixed mode) LOG: # LOG: # An error report file has been saved as hs_err_pid2317.log. LOG: # Please refer to the file for further information. LOG: # LOG: server process (PID 2317) was terminated by signal 6 LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted at 2005-03-29 05:40:41 EST LOG: checkpoint record is at 0/12574B8C LOG: redo record is at 0/12574B8C; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 39667; next OID: 176603 LOG: database system was not properly shut down; automatic recovery in progress LOG: record with zero length at 0/12574BC8 LOG: redo is not required LOG: database system is ready Now, if I run the function again (without logging out) I get no errors, but I don't get my results either. I look at my log and I see this: ***Exception: java.sql.SQLException: Cannot derive a value of class java.lang.String from an object of class java.lang.Boolean java.sql.SQLException: Cannot derive a value of class java.lang.String from an object of class java.lang.Boolean at org.postgresql.pljava.jdbc.ObjectResultSet.getValue(ObjectResultSet.java:417) at org.postgresql.pljava.jdbc.ObjectResultSet.getString(ObjectResultSet.java:205) at PGtoXML.OWDBtoXML.makeDBXML(OWDBtoXML.java:62) at PGtoXML.OWDBtoXML.makeDBXML(OWDBtoXML.java:34) at PGtoXML.PGtoXML.getXmlString(PGtoXML.java:8) Does the pljava JDBC work diffrently than the postgresql JDBC I was using originally? Again you guys have been tremendous hlep.