From: Tim.Clarke at manifest.co.uk (Tim Clarke)
Date: Tue, 21 Feb 2006 14:50:13 -0000
Subject: [Pljava-dev] Java calling other jars
Message-ID: <44D9FC40FD695B4E85F1C59965C27E0FAA4D56@man3>

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