[Pljava-dev] installing pl/Java on Windows

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

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
>

Peter

Postgres is installed in: C:/Program Files/PostgreSQL/8.2/
I have unzipped plJava in: D:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/

I am running C:/Program Files/PostgreSQL/8.2/bin/psql.exe and trying to execute:

\i d:/installers/pljava-i686-pc-mingw32-pg8.1-1.3.0/install.sql

and

D:\installers\pljava-i686-pc-mingw32-pg8.1-1.3.0>java -cp .\deploy.jar
org.postgresql.pljava.deploy.Deployer -install

After reading from the docs.tar shipped with plJava, I have updated my
path setting and it now has:

%JAVA_HOME%\\jre\\bin;%JAVA_HOME%\\jre\\bin\\client

instead of:

%JAVA_HOME%\jre\bin;%JAVA_HOME%\jre\bin\client

(notice the double \\ now) - is putting in double \'s make a difference?

I have restarted the server and PATH shows up as with:

;D:\Program Files\Java\jdk1.5.0_05\jre\\bin\\client;D:\Program
Files\Java\jdk1.5.0_05\jre\\bin;

but I still get the same problem and cannot *deploy* or insert the sql script

Thanks

Sami

On 3/13/07, Peter Henderson <peter.henderson at starjar.com> wrote:
> 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
> >
>
>
>