From: thhal at mailblocks.com (Thomas Hallgren)
Date: Tue, 27 Sep 2005 12:16:16 +0200
Subject: [Pljava-dev] Re: Error while installing jar
In-Reply-To: <433913F6.9030907@gmx.net>
References: <433913F6.9030907@gmx.net>
Message-ID: <dhb65g$2lq$1@sea.gmane.org>

I see another potential problem with your configuration. You're using 
PostgreSQL 8.0.1. It has a bug that doesn't play well with PL/Java. You 
should use at least 8.0.2.

Regards,
Thomas Hallgren

Paul Weinstabl wrote:
> Hello,
> 
> I am new to PL/Java, have some experience with Java in Oracle.
> 
> I have successfully deployed PL/Java after some problems with the 
> installation. But now I wanted to run the example tests as indicated in 
> the user manual. When doing so, I get the following error back from 
> Postgres in psql:
> 
> test_toolbox=# select 
> sqlj.install_jar('file:///home/pauli/office52/Artikel/Toolbox/pl_java/examples.jar', 
> 'samples', true);
> server closed the connection unexpectedly
>       This probably means the server terminated abnormally
>       before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
> 
> My configuration is as follows:
> 
> Linux (Fedora Core 3)
> Java - Standard Installation, Java 1.4.2_05
> [pauli at laptop ~]$ echo $JAVA_HOME
> /usr/java/j2sdk1.4.2_05
> 
> My /etc/ld.so.conf:
> include ld.so.conf.d/*.conf
> /usr/X11R6/lib
> /usr/lib/mysql
> /usr/local/lib
> /usr/local/lib/python2.4
> /usr/local/lib/gtk-2.0
> /usr/java/j2sdk1.4.2_05/jre/lib/i386
> /usr/java/j2sdk1.4.2_05/jre/lib/i386/client
> /usr/java/j2sdk1.4.2_05/jre/lib/i386/native_threads"
> 
> Postgres-Version:
> PostgreSQL 8.0.1
> contains support for command-line editing
> 
> My postgresql.conf:
> custom_variable_classes = 'pljava'
> 
> #--------------------------------------------------------------------------- 
> 
> # SETTINGS FOR PL/Java 1.1
> #--------------------------------------------------------------------------- 
> 
> pljava.classpath = 
> '/home/pauli/office52/Artikel/Toolbox/pl_java/pljava.jar'
> 
> libpljava.so in the same directory where Postgres-libraries reside
> 
> I could deploy PL/Java and I can see the schema and also all the tables 
> and functions therein.
> 
> Please explain to me, what the problem could be.
> 
> I really would need an answer very soon, because I am writing a magazine 
> article for a german developer magazine.
> 
> Thanks in advance.
> 
> Paul