From: pierce at hogranch.com (John R Pierce)
Date: Thu, 15 Apr 2010 15:03:14 -0700
Subject: [Pljava-dev] building pljava for solaris 10 sparc 64bit
Message-ID: <4BC78D22.7020809@hogranch.com>

so I've been having fun getting pl/java 'HEAD' working with Postgres 
8.4.3 64bit on Solaris Sparc, with JDK 1.5.0_23 64bit...

solved bunches of problems, have it built, I think, and am trying to 
figure out how to load things...

first, I had to manually fudge the pgxs/src/Makefile.global as its 
missing from the 64bit build of postgres for solaris, so I took the 
files from the 32bit build and copied/edited them to suit.  I used the 
vlaues displayed by pg_config to adjust whats in that Makefile.global 
...   so I built it, and fixed up the postgres environment.  fwiw, my 
built modules sit in /opt/FIS/pljava/

this is whats happening now...


$ export CLASSPATH=/usr/share/java/postgresql.jar:/opt/FIS/pljava/deploy.jar
$ $JAVA_HOME/bin/sparcv9/java org.postgresql.pljava.deploy.Deployer 
-install -password XXXXX
org.postgresql.util.PSQLException: ERROR: could not load library 
"/opt/FIS/pljava/pljava.so": ld.so.1: postgres: fatal: libjvm.so: open 
failed: No such file or directory
        at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
        at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
        at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:332)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:324)
        at 
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474)
        at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)

-bash-3.00$ tail server.log
...
ERROR:  could not load library "/opt/FIS/pljava/pljava.so": ld.so.1: 
postgres: fatal: libjvm.so: open failed: No such file or directory
STATEMENT:  CREATE FUNCTION sqlj.java_call_handler() RETURNS 
language_handler AS 'pljava' LANGUAGE C
LOG:  unexpected EOF on client connection


These are in the postgres server 'start' method script (I'm running 
postgres under SMF control)

    JAVA_HOME=/usr/jdk/jdk1.5.0_23
    
LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/sparcv9:$JAVA_HOME/jre/lib/sparcv9/server:/opt/FIS/pljava
    PATH=$JAVA_HOME/bin/sparcv9:$PATH


and that LD_LIBRARY_PATH *is* the right JVM

$ ls -l /usr/jdk/jdk1.5.0_23/jre/lib/sparcv9/server
total 24439
-rw-r--r--   1 root     bin         1423 Dec  3 01:49 Xusage.txt
lrwxrwxrwx   1 root     root          13 Dec 18  2008 libjsig.so -> 
../libjsig.so
-rwxr-xr-x   1 root     bin      12402328 Dec  3 01:49 libjvm.so
-rwxr-xr-x   1 root     bin        46656 Dec  3 01:49 libjvm_db.so
$ file /usr/jdk/jdk1.5.0_23/jre/lib/sparcv9/server/libjvm.so
/usr/jdk/jdk1.5.0_23/jre/lib/sparcv9/server/libjvm.so:  ELF 64-bit MSB 
dynamic lib SPARCV9 Version 1, dynamically linked, not stripped, no 
debugging information available


I'm not sure what to try next.