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

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

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

Best regards,

Alex Stienstra.

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

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>

Hi Alex.

Your configuration file looks fine, I think the error is related to a bug in
postgress server (http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=352524)
If you have a package version older than 8.1.3 you have to update it.

Gabriel.

On 11/25/06, Alex Stienstra <Alex.Stienstra at zonnet.nl> wrote:
>
> Hi Gabriel,
>
> Thanks for your response. I attached the complete postgresql.conf file. At
> the end you will see that I set the pljava.classpath setting.
> The line number of the error message points to this line.
>
> Alex.
>
> -----Original Message-----
> *From:* pljava-dev-bounces at gborg.postgresql.org [mailto:
> pljava-dev-bounces at gborg.postgresql.org] *On Behalf Of *Gabriel Velo
> *Sent:* zaterdag 25 november 2006 17:18
> *To:* Alex Stienstra
> *Cc:* pljava-dev at gborg.postgresql.org
> *Subject:* Re: [Pljava-dev] Starting PostgreSQL 8.1 database
> server:mainError: Invalid line 435
> in/etc/postgresql/8.1/main/postgresql.conf
>
>
>
> 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/122b2a12/attachment.html>