From: joves.luo at gmail.com (Joves Luo)
Date: Tue, 29 Mar 2005 12:12:09 -0500
Subject: [Pljava-dev] java.lang.SecurityException
In-Reply-To: <424987A4.8090301@mailblocks.com>
References: <efe8db08050329075236e487f0@mail.gmail.com>
	<42497E58.4060001@mailblocks.com>
	<efe8db08050329082059d8fb6d@mail.gmail.com>
	<42498174.2090501@mailblocks.com>
	<efe8db08050329084154a13479@mail.gmail.com>
	<424987A4.8090301@mailblocks.com>
Message-ID: <efe8db08050329091222f04343@mail.gmail.com>

> Thanks. Unfortunately that log didn't reveal anything at all. What exact
> version of PL/Java are you using? Is it a pre-compiled binary? Would it
> be possible for you to try the latest CVS?

I am using 1.1.0b1.  I changed my code from:

data.getString(i);

to:

data.getObject(i).toString();

And it seems to work.  It still crashes the first time I run the
function when I log into postgresql though.  But it'll work if I just
restart postgresql, which I will add to my script.  And randomly I
will get this:

LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: Stale Handle to native structure
	at org.postgresql.pljava.internal.Tuple._getObject(Native Method)
	at org.postgresql.pljava.internal.Tuple.getObject(Tuple.java:32)
	at org.postgresql.pljava.jdbc.SPIResultSet.peekNext(SPIResultSet.java:172)
	at org.postgresql.pljava.jdbc.SPIResultSet.next(SPIResultSet.java:80)
	at org.postgresql.pljava.sqlj.Loader.getSchemaLoader(Loader.java:88)
ERROR:  java.sql.SQLException: Stale Handle to native structure

Also, although I get my xml string, there is alot of junk in front of it.


-- 
Joves Luo
Georgia Tech Senior
CS Major
School Email: gtg861b at mail.gatech.edu
Personal Email: Joves.Luo at gmail.com