I tried to install the MinHo stats package for my test instance but hit a
snag when I tried to install the pljava package, I tried to proceed
according to your install instructions. since the link provided to
http://wiki.tada.se/display/pljava/Download+Page didn't respond I googled
pljava and found
http://gborg.postgresql.org/project/pljava/genpage.php?readme I proceeded
according to their instructions but do get error messages when I try
toexecute the
install.sql scripts.
I run on Ubuntu, with java version "1.5.0_08", psql 8.1.8
Below is a what gives me grief:
Monika
ls -l /usr/local/pljava
total 372
-rw-rw-r-- 1 500 500 4858 2005-11-20 13:25 deploy.jar
drwxrwxr-x 4 500 500 4096 2005-11-20 13:25 docs/
-rw-rw-r-- 1 500 500 33028 2005-11-20 13:25 examples.jar
-rw-rw-r-- 1 500 500 2378 2005-11-20 13:25 install.sql
-rwxrwxr-x 1 500 500 167513 2005-11-20 13:25 libpljava.so*
-rw-rw-r-- 1 500 500 125428 2005-11-20 13:25 pljava.jar
-rw-rw-r-- 1 500 500 18674 2005-11-20 13:25 test.jar
-rw-rw-r-- 1 500 500 83 2005-11-20 13:25 uninstall.sql
file /usr/local/pljava/libpljava.so
/usr/local/pljava/libpljava.so: ELF 32-bit LSB shared object, Intel 80386,
version 1 (SYSV), not stripped
file /usr/lib/jvm/jdk/jre/lib/i386/client/libjvm.so
/usr/lib/jvm/jdk/jre/lib/i386/client/libjvm.so: ELF 32-bit LSB shared
object, Intel 80386, version 1 (SYSV), not stripped
echo $LD_LIBRARY_PATH
/usr/lib/jvm/jdk/jre/lib/i386:/usr/lib/jvm/jdk/jre/lib/i386/client:/usr/lib/jvm/jdk/jre/lib/i386/native_thread
psql -d smartech
Welcome to psql 8.1.8, 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
smartech=# \i uninstall.sql
psql:uninstall.sql:1: ERROR: language "java" does not exist
psql:uninstall.sql:2: ERROR: language "javau" does not exist
psql:uninstall.sql:3: NOTICE: drop cascades to table sqlj.classpath_entry
psql:uninstall.sql:3: NOTICE: drop cascades to table sqlj.jar_entry
psql:uninstall.sql:3: NOTICE: drop cascades to constraint
jar_repository_deploymentdesc_fkey on table sqlj.jar_repository
psql:uninstall.sql:3: NOTICE: drop cascades to table sqlj.jar_repository
DROP SCHEMA
smartech=# \i install.sql
CREATE SCHEMA
GRANT
psql:install.sql:6: ERROR: could not load library
"/usr/local/pljava/libpljava.so": libjvm.so: cannot open shared object file:
No such file or directory
psql:install.sql:8: ERROR: function sqlj.java_call_handler() does not exist
psql:install.sql:12: ERROR: could not load library
"/usr/local/pljava/libpljava.so": libjvm.so: cannot open shared object file:
No such file or directory
psql:install.sql:14: ERROR: function sqlj.javau_call_handler() does not
exist
psql:install.sql:22: NOTICE: CREATE TABLE will create implicit sequence
"jar_repository_jarid_seq" for serial column "jar_repository.jarid"
psql:install.sql:22: NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit index "jar_repository_pkey" for table "jar_repository"
psql:install.sql:22: NOTICE: CREATE TABLE / UNIQUE will create implicit
index "jar_repository_jarname_key" for table "jar_repository"
CREATE TABLE
GRANT
psql:install.sql:31: NOTICE: CREATE TABLE will create implicit sequence
"jar_entry_entryid_seq" for serial column "jar_entry.entryid"
psql:install.sql:31: NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit index "jar_entry_pkey" for table "jar_entry"
psql:install.sql:31: NOTICE: CREATE TABLE / UNIQUE will create implicit
index "jar_entry_jarid_key" for table "jar_entry"
CREATE TABLE
GRANT
ALTER TABLE
psql:install.sql:42: NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit index "classpath_entry_pkey" for table "classpath_entry"
CREATE TABLE
GRANT
psql:install.sql:47: ERROR: language "java" does not exist
psql:install.sql:51: ERROR: language "java" does not exist
psql:install.sql:55: ERROR: language "java" does not exist
psql:install.sql:59: ERROR: language "java" does not exist
psql:install.sql:63: ERROR: language "java" does not exist
psql:install.sql:67: ERROR: language "java" does not exist
psql:install.sql:71: ERROR: language "java" does not exist
smartech=# \q
--
Monika Mevenkamp
Georgia Institute of Technology
Library and Information Center
Phone: 404.385.0108
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
