From: thhal at mailblocks.com (Thomas Hallgren)
Date: Wed, 08 Jun 2005 08:29:04 +0200
Subject: [Pljava-dev] Re: [Fwd: Unable to load class
	org/postgresql/plsql/internal/Backend]
In-Reply-To: <42A62AE9.8060309@globalera.com>
References: <1118185878.5061.457.camel@laptop01.jaztek.co.uk>
	<42A62AE9.8060309@globalera.com>
Message-ID: <42A69030.6090708@mailblocks.com>

Michael,
If you get so far that a complaint about "Unable to load class" is 
issued, then your LD_LIBRARY_PATH and dynamic_library_path are both 
correct. Your problem is in the CLASSPATH. It ends with 
"build.pljava.jar", i.e. you have a dot before pljava.jar. It should end 
with "build/pljava.jar".

Regards,
Thomas Hallgren


Vince Clark wrote:
> Michael
> 
> You said you were having trouble installing plsql. Do you mean pljava?
> 
> Be sure you also have LD_LIBRARY_PATH set with the same values.
> 
> Once the library path is established in both places (LD_LIBRARY_PATH) 
> and postgresql.conf) I found that restarting postgres before trying to 
> install pljava solved the problem.
> 
> Michael Judd wrote:
> 
>>
>> ------------------------------------------------------------------------
>>
>> Subject:
>> Unable to load class org/postgresql/plsql/internal/Backend
>> From:
>> Michael Judd <michael.judd at jaztek.co.uk>
>> Date:
>> Tue, 07 Jun 2005 23:46:25 +0100
>> To:
>> pljava-dev at gborg.postgresql.org
>>
>> To:
>> pljava-dev at gborg.postgresql.org
>>
>>
>>Hi,
>>
>>I'm having trouble installing plsql and I'm getting the following:
>>
>>Unable to load class org/postgresql/plsql/internal/Backend using
>>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
>>
>>when issuing the command to pgsql:
>>
>>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
>>
>>I have checked that:
>>- pljava.jar is in /opt/pgsql/pljava/build
>>- sqlj.jar is in  /opt/pgsql/lib
>>
>>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
>>$libdir' where libpljava.so, plpgsql.so resides.
>>
>>my paths are:
>> - postgres /opt/pgsql
>> - pljava /opt/pgsql/pljava
>> - data /opt/pgsql/pg_data
>>
>>Fedora Core 3 x86_64smp
>>
>>I've double checked that Backend is located in the jar exactly where it
>>is supposed to be - so the error being displayed doesn't seem to point
>>in the 'right' direction.
>>
>>Any ideas ?
>>
>>
>>
>>
>>
>>  
>>
>>------------------------------------------------------------------------
>>
>>_______________________________________________
>>Pljava-dev mailing list
>>Pljava-dev at gborg.postgresql.org
>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>  
>>
> 
> -- 
> Vince Clark
> Global Era
> The freedom of open source.
> (303) 493-6723
> (303) 455-2409 fax
> vclark at globalera.com <mailto:vclark at globalera.com>
> www.globalera.com
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev