From: terencenwk at hotmail.com (Terence Ng) Date: Mon, 21 Jul 2008 16:53:48 +0800 Subject: [Pljava-dev] java.lang.NoClassDefFoundError In-Reply-To: <484FFAE9.9000908@ejurka.com> References: <484B5E37.1080008@ejurka.com> <484C1EBE.40807@ejurka.com> <484FFAE9.9000908@ejurka.com> Message-ID: 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: