Joves Luo wrote:
> Someone please help me, this is driving me crazy.
>
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