[Pljava-dev] Starting PostgreSQL 8.1 database server: mainError: Invalid line 435 in /etc/postgresql/8.1/main/postgresql.conf

From: gabriel(dot)velo at gmail(dot)com (Gabriel Velo)
To:
Subject: [Pljava-dev] Starting PostgreSQL 8.1 database server: mainError: Invalid line 435 in /etc/postgresql/8.1/main/postgresql.conf
Date: 2006-11-25 16:18:08
Message-ID: a6a62eeb0611250818m72aeddb3r2c00cc4e1ecc73d3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

On 11/23/06, Alex Stienstra <Alex.Stienstra at zonnet.nl> wrote:
>
> Hi,
>
> I am using pl/java stored procedures. So far only on windows. I am now
> moving it to Linux (debian). I managed to get the LD_LIBRARY_PATH set
> appropriately. But calling a java function I get the message:
>
> WARNING: java.lang.NoClassDefFoundError:
> org/postgresql/pljava/internal/Backend
>
> ERROR: Unable to load class org/postgresql/pljava/internal/Backend using
> CLASSPATH 'null'
>
> I guess it has something todo with an other error the server gives when it
> reads the postgresql.conf file. It complains about the
> pljava.classpath='/usr/share/pljava/pljava.jar'
>
> Starting PostgreSQL 8.1 database server: mainError: Invalid line 435 in
> /etc/postgresql/8.1/main/postgresql.conf
>

You must set the classpath in postgresql.conf:
ie: pljava.classpath = '/usr/local/pljava/pljava.jar'

Does any one have an idea what the reason of these error message are?
>

please, show us the line to see what is wrong with your configuration.

Best regards,
>
> Alex Stienstra.
>
>
>
>
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
>

Gabriel.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20061125/f1c8965a/attachment.html>

In response to

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Gabriel Velo 2006-11-25 20:58:06 [Pljava-dev] Starting PostgreSQL 8.1 database server:mainError: Invalid line 435 in/etc/postgresql/8.1/main/postgresql.conf
Previous Message Thomas Hallgren 2006-11-25 16:16:34 [Pljava-dev] java.sql.SQLException: SPI function SPI_prepare failed with error SPI_ERROR_UNCONNECTED