From: marc+pljava at milestonerdl.com (marc+pljava at milestonerdl.com)
Date: Tue, 19 Aug 2008 20:09:04 GMT
Subject: [Pljava-dev] Install of PL/Java - Undefined symbol "SetUserId"
Message-ID: <200808192009.m7JK947F031189@tandem.milestonerdl.com>

I used:
cvs -d :pserver:anonymous at cvs.pgfoundry.org:/cvsroot/pljava checkout org.postgresql.pljava
To get the latest version (this I should have avoided the 2008.txt chatter 
about SetUserId being a version issue )

I try an install:

java  org.postgresql.pljava.deploy.Deployer -install -database template1
org.postgresql.util.PSQLException: ERROR: schema "sqlj" already exists
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
        at org.postgresql.pljava.deploy.Deployer.createSQLJSchema(Deployer.java:351)
        at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:268)


Then a re-install:

java  org.postgresql.pljava.deploy.Deployer -reinstall -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: /usr/local/lib/postgresql/pljava.so: Undefined symbol "SetUserId"
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
        at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474)
        at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)


 ls -l /usr/local/lib/postgresql/pljava.so
-rwxr-xr-x  1 root  wheel  1272419 Aug 19 16:52 /usr/local/lib/postgresql/pljava.so


 env
USER=pgsql
MAIL=/var/mail/pgsql
LD_LIBRARY_PATH=/usr/local/diablo-jdk1.5.0/jre/lib/i386:/usr/local/diablo-jdk1.5.0/jre/lib/i386/client
HOME=/usr/local/pgsql
PGLIB=/usr/local/lib:/usr/local/lib/postgresql
TERM=xterm
BLOCKSIZE=K
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin:/usr/local/pgsql/bin
SHELL=/bin/sh
CLASSPATH=/usr/local/share/java/classes/postgresql.jar:/usr/local/pljava/deploy.jar
JAVA_HOME=/usr/local/diablo-jdk1.5.0
PGDATA=/usr/local/pgsql/data
FTP_PASSIVE_MODE=YES



So - what did I miss?  
And I expect this sequence will output results once I have things correct - is that assumption correct?


template1=# SELECT sqlj.install_jar('file:///usr/local/pljava/examples.jar ', 'samples',  true);
ERROR:  function sqlj.install_jar("unknown", "unknown", boolean) does not exist
LINE 1: SELECT sqlj.install_jar('file:///usr/local/pljava/examples.j...
               ^
HINT:  No function matches the given name and argument types. You may need to add explicit type casts.
template1=#