[Pljava-dev] java.sql.SQLException: ERROR: could not load library undefined symbol: JNI_CreateJavaVM

Hi guys!

I try install pljava unsuccesfully, my problem is :

vpj:/app/PostgreSQL/pljava # java
-cp ../postgresql-8.0-310.jdbc3.jar:deploy.jar
org.postgresql.pljava.deploy.Deployer -install -user postgres -password
postgres -database cmpcs -host vpj
java.sql.SQLException: ERROR: could not load library
"/usr/local/pgsql/lib/libpljava.so": /usr/local/pgsql/lib/libpljava.so:
undefined symbol: JNI_CreateJavaVM
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:388)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:313)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:305)
at
org.postgresql.pljava.deploy.Deployer.initJavaHandler(Deployer.java:389)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:273)

my enveroment :

Linux vpj 2.6.8-24.11-default #1 Fri Jan 14 13:01:26 UTC 2005 x86_64
x86_64 x86_64 GNU/Linux

java version "1.4.2_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_06-b03)
Java HotSpot(TM) Client VM (build 1.4.2_06-b03, mixed mode)

Postgresql 8.0.1

export
LD_LIBRARy_PATH=/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/jre/lib/i386:/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/jre/lib/i386/client:/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/jre/lib/i386/native_threads:/usr/local/pgsql/lib/libpljava.so

Some one can help me with this problem?

Best regards

Victor P?rez Ju?rez
e-Evolutiuon, S.C.
www.e-evolution.com
victor.perez at e-evolution.com
Tel: (52)7711070937