From: jluo at teltronics.com (Joves Luo)
Date: Mon, 28 Mar 2005 12:02:32 -0500
Subject: [Pljava-dev] java.lang.SecurityException
Message-ID: <11C803742910E84E9CDBFD344773B814759F78@srqech02.teltronics.com>

Thomas Hallgren wrote:
 
> 
>You try to load the PGtoXML.jar using the system classloader instead of

>installing it in the database with sqlj.install_jar, or in other words,

>you add the PGtoXML.jar to the PL/Java classpath. This in turn, causes 
>an illegal file access. PL/Java installs "java" as a trusted language. 
>Trusted languages have no access to the file system. Try installing 
>removing PGtoXML.jar from the classpath and instead install it into the

>database using install_jar.
> 
> 
>Regards,
>Thomas Hallgren

> 

 

I'm not sure what you mean, but I did use sqlj.install_jar to install
the jar files.  Here is the sql script I run:

 

------------------------------------------------------------------------
--------

SELECT sqlj.install_jar('file:///var/lib/pgsql/pljava/xercesImpl.jar',
'xercesImpl',  false);

SELECT sqlj.install_jar('file:///var/lib/pgsql/pljava/xml_apis.jar',
'xml_apis',  false);

SELECT sqlj.install_jar('file:///var/lib/pgsql/pljava/JDBC.jar', 'JDBC',
false);

SELECT sqlj.install_jar('file:///var/lib/pgsql/pljava/PGtoXML.jar',
'PGtoXML',  false);

 

SELECT sqlj.set_classpath('public', 'xercesImpl');

SELECT sqlj.set_classpath('public', 'xml_apis');

SELECT sqlj.set_classpath('public', 'JDBC');

SELECT sqlj.set_classpath('public', 'PGtoXML');

 

------------------------------------------------------------------------
--------

CREATE or REPLACE FUNCTION getXmlString()

  RETURNS VARCHAR

  AS 'PGtoXML.PGtoXML.getXmlString()'

  LANGUAGE java;

------------------------------------------------------------------------
--------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050328/9cefd6cf/attachment.html>