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://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20080721/29e7f857/attachment.html>