From: | sami(dot)jan at gmail(dot)com (sami jan) |
---|---|
To: | |
Subject: | [Pljava-dev] installing pl/Java on Windows |
Date: | 2007-03-12 17:51:23 |
Message-ID: | b9e5d0c40703121051p69d04070va9e4d36e6a87d8b4@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Hi
I have been trying to nail down this problem by looking at all the
various ways people have figured it out but it still doesn't work for
me, I would really appreciate some help, thanks
I have downloaded - pljava-i686-pc-mingw32-pg8.1-1.3.0 - and am trying
to install it in a PG 8.2.3 database
Neither:
1. install.sql
2. >java -cp .\deploy.jar org.postgresql.pljava.deploy.Deployer -install
- work for me
1. Running install.sql gives me:
=====================
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:1: ERROR: sch
ema "sqlj" already exists
GRANT
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:6: ERROR: cou
ld not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll": The specif
ied module could not be found.
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:8: ERROR: fun
ction sqlj.java_call_handler() does not exist
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:12: ERROR: co
uld not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll": The speci
fied module could not be found.
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:14: ERROR: fu
nction sqlj.javau_call_handler() does not exist
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:23: NOTICE: C
REATE TABLE will create implicit sequence "jar_repository_jarid_seq1" for serial
column "jar_repository.jarid"
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:23: ERROR: re
lation "jar_repository" already exists
GRANT
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:32: NOTICE: C
REATE TABLE will create implicit sequence "jar_entry_entryid_seq1" for serial co
lumn "jar_entry.entryid"
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:32: ERROR: re
lation "jar_entry" already exists
GRANT
ALTER TABLE
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:43: ERROR: re
lation "classpath_entry" already exists
GRANT
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:50: NOTICE: C
REATE TABLE will create implicit sequence "typemap_entry_mapid_seq1" for serial
column "typemap_entry.mapid"
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:50: ERROR: re
lation "typemap_entry" already exists
GRANT
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:55: ERROR: la
nguage "java" does not exist
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:59: ERROR: la
nguage "java" does not exist
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:63: ERROR: la
nguage "java" does not exist
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:67: ERROR: la
nguage "java" does not exist
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:71: ERROR: la
nguage "java" does not exist
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:75: ERROR: la
nguage "java" does not exist
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:79: ERROR: la
nguage "java" does not exist
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:83: ERROR: la
nguage "java" does not exist
psql:D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql:87: ERROR: la
nguage "java" does not exist
=====================
C:/Program Files/PostgreSQL/8.2/lib/pljava.dll DOES exist
2. Running the Deployer gives me:
=======================
D:\installers\pljava-i686-pc-mingw32-pg8.1-1.3.0>java -cp .\deploy.jar
org.postgresql.pljava.deploy.Deployer -install
java.lang.ClassNotFoundException: org.postgresql.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:238)
=======================
These are my env var settings:
JAVA_HOME = D:\Program Files\Java\jdk1.5.0_05
JRE_HOME = D:\Program Files\Java\jdk1.5.0_05\jre
PATH = C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;D:\Program
Files\Java\jdk1.5.0_05\bin;D:\Program
Files\Java\jdk1.5.0_05\jre\bin\client;D:\Program
Files\Java\jdk1.5.0_05\jre\bin
LD_LIBRARY_PATH = D:\Program
Files\Java\jdk1.5.0_05\jre\lib\i386;D:\Program
Files\Java\jdk1.5.0_05\jre\bin\client;D:\Program
Files\Java\jdk1.5.0_05\jre\bin\
=======================
I have added the following to postgresql.conf -
dynamic_library_path =
'$libdir;D:\\installers\\pljava-i686-pc-mingw32-pg8.1-1.3.0'
custom_variable_classes = 'pljava'
pljava.classpath='D:\\installers\\pljava-i686-pc-mingw32-pg8.1-1.3.0\pljava.jar'
#local_preload_libraries = ''
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Henderson | 2007-03-12 20:23:15 | [Pljava-dev] installing pl/Java on Windows |
Previous Message | Eugen Ermantraut | 2007-02-27 16:17:35 | [Pljava-dev] PL/JAVA Installation |