From: list at jaztek.co.uk (Michael Judd) Date: Wed, 08 Jun 2005 08:08:44 +0100 Subject: [Pljava-dev] [Fwd: Unable to load class org/postgresql/plsql/internal/Backend] In-Reply-To: <42A6452A.3000503@globalera.com> References: <1118185878.5061.457.camel@laptop01.jaztek.co.uk> <42A62AE9.8060309@globalera.com> <1118190465.5061.497.camel@laptop01.jaztek.co.uk> <42A6452A.3000503@globalera.com> Message-ID: <1118214525.5061.575.camel@laptop01.jaztek.co.uk> pljava placed my pljava.so.1.1 in /opt/pgsql/lib so I've used that instead of your /usr/lib64 I still have the same issue. I have restarted - I'm running it in a shell at the moment and I've closed the shell to ensure that the environment is reset and the started up postgres again with: pg_ctl start -D /opt/pgsql/pg_data -l /var/log/pgsql.log -o "-i" The log file confirms this. The problem may well be as you suggest java 1.5 I'll try blackdown as I'm on dual opterons (amd64 too) which is the reason I didn't go with java1.4 to start. Thanks again for you help. Mike On Tue, 2005-06-07 at 19:08 -0600, Vince Clark wrote: > 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