[Pljava-dev] java.lang.SecurityException

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.