[Pljava-dev] java.lang.NoClassDefFoundError

[Terence Ng]

Hi Kris,
 
I suppose I have installed pljava adequately.  But I discover that something wrong and want to re-install it again...but fail to install.  I do not know where should I start.  Please give me some suggestions.
 
How do I know the installation is okay?
 
# JAVA_HOME=/usr/jdk/instances/jdk1.5.0# export JAVA_HOME# java -cp /usr/postgres/8.2/lib/deploy.jar:/usr/postgres/8.2/jdbc/postgresql.jar org.postgresql.pljava.deploy.Deployer -install -user adempiere -database adempiere -password adempiereorg.postgresql.util.PSQLException: ERROR: schema "sqlj" already exists        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329)        at org.postgresql.pljava.deploy.Deployer.createSQLJSchema(Deployer.java:351)        at org.pos
 tgresql.pljava.deploy.Deployer.main(Deployer.java:268)
# psql -d adempiere -U adempierePassword for user adempiere:Welcome to psql 8.2.6, the PostgreSQL interactive terminal.
Type:  \copyright for distribution terms       \h for help with SQL commands       \? for help with psql commands       \g or terminate with semicolon to execute query       \q to quit
adempiere=# SELECT sqlj.install_jar('file:///opt/Adempiere/lib/sqlj.jar','sqlj',true);ERROR:  function sqlj.install_jar("unknown", "unknown", boolean) does not existLINE 1: SELECT sqlj.install_jar('file:///opt/Adempiere/lib/sqlj.jar'...               ^HINT:  No function matches the given name and argument types. You may need to add explicit type casts.adempiere=# \qcould not save history to file "//.psql_history": Permission denied
# psql -d adempiere -U adempiere -f /usr/postgres/8.2/share/install.sqlPassword for user adempiere:psql:/usr/postgres/8.2/share/install.sql:1: ERROR:  schema "sqlj" already existsGRANTpsql:/usr/postgres/8.2/share/install.sql:6: ERROR:  could not load library "/usr/postgres/8.2/lib/pljava.so": ld.so.1: postgres: fatal: libjvm.so: open failed: No such file or directorypsql:/usr/postgres/8.2/share/install.sql:8: ERROR:  function sqlj.java_call_handler() does not existpsql:/usr/postgres/8.2/share/install.sql:12: ERROR:  could not load library "/usr/postgres/8.2/lib/pljava.so": ld.so.1: postgres: fatal: libjvm.so: open failed: No such file or directorypsql:/usr/postgres/8.2/share/install.sql:14: ERROR:  function sqlj.javau_call_handler() does not existpsql:/usr/postgres/8.2/share/install.sql:23: NOTICE:  CREATE TABLE will create implicit sequence "jar_repository_jarid_seq1" for serial column "jar_repository.jarid"psql:/usr/postgres/8.2/share/install.sql:23: ERROR:  relation "jar_r
 epository" already existsGRANTpsql:/usr/postgres/8.2/share/install.sql:32: NOTICE:  CREATE TABLE will create implicit sequence "jar_entry_entryid_seq1" for serial column "jar_entry.entryid"psql:/usr/postgres/8.2/share/install.sql:32: ERROR:  relation "jar_entry" already existsGRANTALTER TABLEpsql:/usr/postgres/8.2/share/install.sql:43: ERROR:  relation "classpath_entry" already existsGRANTpsql:/usr/postgres/8.2/share/install.sql:50: NOTICE:  CREATE TABLE will create implicit sequence "typemap_entry_mapid_seq1" for serial column "typemap_entry.mapid"psql:/usr/postgres/8.2/share/install.sql:50: ERROR:  relation "typemap_entry" already existsGRANTpsql:/usr/postgres/8.2/share/install.sql:55: ERROR:  language "java" does not existpsql:/usr/postgres/8.2/share/install.sql:59: ERROR:  language "java" does not existpsql:/usr/postgres/8.2/share/install.sql:63: ERROR:  language "java" does not existpsql:/usr/postgres/8.2/share/install.sql:67: ERROR:  language "java" does not existpsql:
 /usr/postgres/8.2/share/install.sql:71: ERROR:  language "java" does not existpsql:/usr/postgres/8.2/share/install.sql:75: ERROR:  language "java" does not existpsql:/usr/postgres/8.2/share/install.sql:79: ERROR:  language "java" does not existpsql:/usr/postgres/8.2/share/install.sql:83: ERROR:  language "java" does not existpsql:/usr/postgres/8.2/share/install.sql:87: ERROR:  language "java" does not exist# 
Regards,
Terence
_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pljava-dev/attachments/20080721/29e7f857/attachment.html