[Pljava-dev] Java calling other jars

[Tim Clarke]

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