From: sami.jan at gmail.com (sami jan) Date: Tue, 13 Mar 2007 03:15:04 +0500 Subject: [Pljava-dev] installing pl/Java on Windows In-Reply-To: <402928603.591173730996845.JavaMail.root@starjar01> References: <402928603.591173730996845.JavaMail.root@starjar01> Message-ID: 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 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 > > > > >