agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

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

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

view thread (3+ messages)

Message-ID: <dhb65g$2lq$1@sea.gmane.org>
Permalink:  ../dhb65g$2lq$1@sea.gmane.org/
Also on:    postgresql.org/message-id/dhb65g$2lq$1@sea.gmane.org

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] Re: Error while installing jar
  In-Reply-To: <dhb65g$2lq$1@sea.gmane.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox