[Pljava-dev] java.lang.SecurityException

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>