[Pljava-dev] problem installing pljava 1.4.0

[Teresa Quintanilla]

Hi All,

I try to install pljava. I am using:
binari pljava-i686-pc-linux-gnu-pg8.2-1.4.0
java1.5_015
postgresql-8.2.6

When I run the deployer with the command:

java org.postgresql.pljava.deploy.Deployer -install

following error message is displayed:

org.postgresql.util.PSQLException: ERROR: could not load library 
"/usr/local/pljava/libpljava.so": /usr/local/pljava/libpljava.so: 
undefined symbol: SetUserId
        at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1499)
        at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
        at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:429)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:334)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:326)
        at 
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:432)
        at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)


and the error message in the log is:

<postgresql%dspace%CREATE FUNCTION%47fb41b4.cf5%2008-04-08 11:58:12 
CEST%>ERROR:  could not load library "/usr/local/pljava/libpljava.so": 
/usr/local/pljava/libpljava.so: undefined symbol: SetUserId
<postgresql%dspace%CREATE FUNCTION%47fb41b4.cf5%2008-04-08 11:58:12 
CEST%>STATEMENT:  CREATE FUNCTION sqlj.java_call_handler() RETURNS 
language_handler AS 'libpljava' LANGUAGE C
<postgresql%dspace%idle%47fb41b4.cf5%2008-04-08 11:58:12 CEST%>LOG:  
unexpected EOF on client connection


Any ideas, or anything I could try?

I will appreciate any help!!!


--------------------------------------------
Teresa Quintanilla
Universidad Carlos III de Madrid