[Pljava-dev] Building from source for PG 8.2.4

[Eric Faulhaber]

For months, I have been running PL/Java successfully with PostgreSQL 
8.1.8 on Kubuntu Linux using the PL/Java 1.3.0 binary distribution.  I 
recently upgraded to PG 8.2.4 and found that the 1.3.0 pljava.so binary 
would no longer work, due to the version check mechanism 
(PG_MAGIC_MODULE) introduced for extensions in 8.2.  So, I set out to 
compile PL/Java from source with the newer version of PostgreSQL 
installed...

I have now rebuilt PL/Java from the latest CVS source tree, using Sun's 
Java 1.5.0_11 (had to drop back from Java 6 due to some unimplemented 
JDBC 4 methods).  Simply running make from the top level directory 
seemed to work.  Curiously, I ended up with a pljava.so that was nearly 
5 times larger than the version which was distributed with the PL/Java 
1.3.0 release.  Any idea why this would be?  Does the default build 
included debug symbols?

Anyway, when I try to deploy to a database using install.sql, it 
complains that it is unable to locate the JVM:

psql:install.sql:6: ERROR:  could not load library 
"/usr/lib/postgresql/8.2/lib/pljava.so": 
/usr/lib/postgresql/8.2/lib/pljava.so: undefined symbol: JNI_CreateJavaVM

I've made all the same changes to postgresql.conf that were necessary to 
get this to work with my previous PG 8.1.8 installation.  Likewise, I 
have set LD_LIBRARY_PATH in exactly the same way as was working before.  
For Kubuntu, this is set in /etc/postgresql/8.2/<mycluster>/environment, 
as in:

LD_LIBRARY_PATH = 
'/usr/lib/jvm/java-1.5.0-sun/jre/lib/i386:/usr/lib/jvm/java-1.5.0-sun/jre/lib/i386/server'

And yes, I've double checked that these are valid paths to the Sun 1.5 
JVM on my system.

So, I'm not sure why I'm now seeing this JVM load error, but the extra 
large pljava.so has me wondering if the build really worked properly 
after all.  Any suggestions on what to try next?

Thanks in advance,
Eric Faulhaber