[Pljava-dev] Install of PL/Java - Undefined symbol "SetUserId"

From: marc+pljava at milestonerdl(dot)com (marc+pljava at milestonerdl(dot)com)
To:
Subject: [Pljava-dev] Install of PL/Java - Undefined symbol "SetUserId"
Date: 2008-08-19 20:09:04
Message-ID: 200808192009.m7JK947F031189@tandem.milestonerdl.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

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=#

Browse pljava-dev by date

  From Date Subject
Next Message marc+pljava at milestonerdl.com 2008-08-20 13:38:48 [Pljava-dev] java.net.SocketException: Invalid argument
Previous Message Daniel Tamm 2008-08-14 13:57:38 [Pljava-dev] How to compile 1.4.0 pljava.so from source?