[Pljava-dev] installing pl/Java on Windows

[Peter Henderson]

sami jan wrote:
> 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

C drive here


> 
> 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)
> 

Download the postgresql jdbc driver.
then run something link (not tried this so correct as needed, not this 
is all on one line)
java -cp deploy.jar;postgresql-8.1-407.jdbc3.jar 
org.postgresql.pljava.deploy.Deployer -install




> =======================
> 
> 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'

D drive here. Did you mean C?

> custom_variable_classes = 'pljava'
> pljava.classpath='D:\\installers\\pljava-i686-pc-mingw32-pg8.1-1.3.0\pljava.jar'
> #local_preload_libraries = ''
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>