PL/Java now supports both PostgreSQL 8.0 and 7.4 [LWN.net]

From:		Thomas Hallgren <thhal-AT-mailblocks.com>
To:		pgsql-announce-AT-postgresql.org
Subject:		[ANNOUNCE] PL/Java now supports both PostgreSQL 8.0 and 7.4
Date:		Fri, 20 Aug 2004 23:54:36 +0200

The 1.0.0.b4 release of PL/Java is out. It takes full advantage of the 
new exception handling and custom variables introduced in PostgreSQL 8.0 
and a native Windows port is included in the distribution (7.4 still 
supported with Cygwin on Windows).

On Linux, PL/Java 1.0.0.b4 includes binary distributions compiled using 
GCJ (the GNU Java) to take full advantage of Postgres capability of 
using preloaded modules.

Please visit http://gborg.postgresql.org/project/pljava for more info.

Regards,

Thomas Hallgren



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

(Log in to post comments)

PL/Java now supports both PostgreSQL 8.0 and 7.4

Posted Apr 4, 2005 14:41 UTC (Mon) by tory (guest, #29021) [Link]

If i try to call some function from "examples.jar" in schema "javatest" I had SecurityException such as:
-------------------------------------------------------------------------------
2005-04-01 12:03:36 ERROR: java.lang.SecurityException: read on D:\Program Files\PostgreSQL\8.0\java\examples.jar
2005-04-01 12:03:58 LOG: Exception
2005-04-01 12:03:58 LOG: in thread "main"
java.lang.SecurityException: read on \D:\Program Files\PostgreSQL\8.0\java\examples.jar
at org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:184)
at org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck( Backend.java:125)
at org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Ba ckend.java:103)
at java.net.URLClassLoader$4.run(URLClassLoader.java:490)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.getPermissions(URLClassLoader.java:488)
at sun.misc.Launcher$AppClassLoader.getPermissions(Launcher.java:276)
at java.security.SecureClassLoader.getProtectionDomain(SecureClassLoader.java:192)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:260)
at java.net.URLClassLoader.access$100(URLClassLoader.java:56)
at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
-------------------------------------------------------------------------------
Of course, before calling function I set CLASSPATH to this .jar, create it in this way

CREATE FUNCTION javatest.listSupers()
RETURNS SETOF pg_user
AS 'org.postgresql.pljava.example.Users.listSupers'
LANGUAGE java;

-------------------------------------------------------------------------------
Function was created without any causes.
Then I call it:
----------------------------------------------------
SELECT * FROM javatest.listSupers();
-----------------------------------------------------
And get an exception wrote above.