From: marc+pljava at milestonerdl.com (Marc Rassbach)
Date: Fri, 29 Aug 2008 14:29:50 GMT
Subject: [Pljava-dev] Undefined symbol "SetUserId"
Message-ID: <200808291429.m7TEToQl092667@tandem.milestonerdl.com>


Last time I went and got the CVS and got the same error.   This time I got 
the 1.4.0 tarball version. 


This is the error:

$ java org.postgresql.pljava.deploy.Deployer -install -database template1
org.postgresql.util.PSQLException: ERROR: could not load library "/usr/local/lib
/postgresql/pljava.so": dlopen (/usr/local/lib/postgresql/pljava.so) failed: /us
r/local/lib/postgresql/pljava.so: Undefined symbol "SetUserId"
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:1592)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1327)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:192)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:336)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:328)
        at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:
474)
        at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)
$ 



This is the environment:
FreeBSD 6.3 
$ postmaster --version
postgres (PostgreSQL) 8.2.7
$ 
 java -version
java version "1.5.0_14-p8"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_14-p8-marc_01_may_
2008_23_54)
Java HotSpot(TM) Server VM (build 1.5.0_14-p8-marc_01_may_2008_23_54, mixed mode
)

$ ldd /usr/local/lib/postgresql/pljava.so
/usr/local/lib/postgresql/pljava.so:
        libjvm.so => /usr/local/jdk1.5.0/jre/lib/i386/client/libjvm.so (0x281970
00)
        libm.so.4 => /lib/libm.so.4 (0x28571000)