[Pljava-dev] Java calling other jars

[Thomas Hallgren]

Hi Tim,
It seems you have either a CLASSPATH environment variable or the 
postgresql.conf variable 'pljava.classpath' setup so that the System 
Classloader makes attempts to read the log4j-1.2.13.jar file. Please 
make sure that:

a). No CLASSPATH environment variable is visible to the PostgreSQL backend.
b). the pljava.classpath *only* contains the full path to pljava.jar.

Kind regards,
Thomas Hallgren

Tim Clarke wrote:
> I fully understand the Postgres trusted language issue, but how can a
> "sqlj.install_jar"'d jar file of mine call another jar? I'm trying to
> use the Apache log4j but keep getting the error:
>
> ERROR:  java.lang.SecurityException: read on
> /usr/java/logging-log4j-1.2.13/dist/lib/log4j-1.2.13.jar
>
> The log4j jar is world-readable and in a world-readable folder.
>
> I have tried:
>
> select sqlj.replace_jar('file:///home/timc/java.postgres.vote/vote.jar',
>   'vote', false);
> select
> sqlj.install_jar('file:///usr/java/logging-log4j-1.2.13/dist/lib/log4j-1
> .2.13.jar',
>   'logging', false);
> SELECT sqlj.set_classpath('voting', 'vote:logging');
>
> But that makes no difference since I'm not calling any functions in the
> log4j jar directly from Postgres.
>
> Help!
>
> TIA
> Tim Clarke
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>