From: vclark at globalera.com (Vince Clark) Date: Tue, 07 Jun 2005 19:08:58 -0600 Subject: [Pljava-dev] [Fwd: Unable to load class org/postgresql/plsql/internal/Backend] In-Reply-To: <1118190465.5061.497.camel@laptop01.jaztek.co.uk> References: <1118185878.5061.457.camel@laptop01.jaztek.co.uk> <42A62AE9.8060309@globalera.com> <1118190465.5061.497.camel@laptop01.jaztek.co.uk> Message-ID: <42A6452A.3000503@globalera.com> Here is my dynamic_library_path in postgresql.conf dynamic_library_path = '/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/' Note that I am running an AMD64 so things will look slightly different. The key in this line is that this path points to a directory that contains a file called libjvm.so. In some JVM's I have seen that file under jre/lib/client (rather than /server) Here is what my LD_LIBRARY_PATH looks like: LD_LIBRARY_PATH=/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/ export LD_LIBRARY_PATH In my case the pljava build placed pljava.so.1.1 in /usr/lib64 and created soft links with the proper file name of pljava.so Also, you may run into another problem once you get past the library path issue. I was unable to install pljava using a 1.5.x JDK. I ended up using Blackdown 1.4.2. It has something to do with being able to spawn a VM from within Postgres. I don't remember exactly. Finally, I'm serious about restarting postgres. I did two installations where the path settings were right but I had to restart postgres before I could successfully add pljava as a language in the database. Michael Judd wrote: >Hi, > >At your recommendation I changed my LD_LIBRARY_PATH (via /etc/profile) >to /usr/java/jdk1.5.0_03/jre/lib:/usr/java/jdk1.5.0_03/jre/lib/server:/usr/java/jdk1.5.0_03/jre/lib/native_threads:/opt/pgsql/lib >This now matches my dynamic_library_path in postgresql.conf >in /opt/pgsql/pg_data (or should I use this in my pljava.classpath ? > >I'm still getting exactly the same problem. > >Thanks for your help. > > > >On Tue, 2005-06-07 at 17:16 -0600, 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 >>>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 >>www.globalera.com >> >> > > > -- Vince Clark Global Era The freedom of open source. (303) 493-6723 (303) 455-2409 fax vclark at globalera.com www.globalera.com -------------- next part -------------- An HTML attachment was scrubbed... URL: