From: eric.kolotyluk at gmail.com (Eric Kolotyluk) Date: Sun, 23 Jan 2011 11:14:24 -0800 Subject: [Pljava-dev] Windows binaries In-Reply-To: References: <4D3A3076.4070905@gmail.com> <4D3C6777.10708@gmail.com> <4D3C6B11.3010706@gmail.com> <4D3C6F68.9060304@gmail.com> <4D3C7606.5080205@gmail.com> Message-ID: <4D3C7E10.7080906@gmail.com> On 2011-01-23 10:51 AM, Johann 'Myrkraverk' Oskarsson wrote: > On Sun, 23 Jan 2011 18:40:06 -0000, Eric Kolotyluk > wrote: > >> Sorry, please bear with me, I am new to PostgreSQL as I am evaluating >> it for possible use, so nothing is familiar. >> >> In my postgresql.conf file I have >> >> #dynamic_library_path = '$libdir' >> >> So would I change it to something like >> >> #dynamic_library_path = '$libdir;c:\postgres' > > Yes, assuming you've moved the pljava.dll to c:\postgres. The you > just have to uncomment it by removing the #. > > dynamic_library_path = '$libdir;c:\postgres' > >> I do not know how to confirm > > After this change it's probably best to restart the server. If you > used pg_ctl to start it you can use the restart command, or stop and > then start. See the reference for pg_ctl for the details. > >> "Also make sure your JVM dll is in the path of your server process." > > As long as JVM.DLL (or maybe LIBJVM.DLL) is in your path, such as in > either %JAVA_HOME%\jre\bin or %JAVA_HOME%\jre\bin\client you'll be fine. > >> Also, per the instructions I added the following to my >> postgresql.conf file earlier - is this correct? > > Everything seems fine to me. > >> pljava.classpath = 'C:\Program Files >> (x86)\PostgresPlus\9.0SS\PostGIS\java\pljava\postgis_pljava.jar' > > Perhaps it's worthwhile to set this to a path without spaces as well. > Took me a while to figure out how to stop/start the service. I forgot I had to run pgAdmin III as Administrator. I stopped and started the server. Here is what I put in the .config file dynamic_library_path = '$libdir;c:\postgres' and here is the error when I run install.sql C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>psql -f install.sql Password: CREATE SCHEMA GRANT psql:install.sql:6: ERROR: component in parameter "dynamic_library_path" is not an absolute path psql:install.sql:8: ERROR: function sqlj.java_call_handler() does not exist psql:install.sql:12: ERROR: component in parameter "dynamic_library_path" is not an absolute path psql:install.sql:14: ERROR: function sqlj.javau_call_handler() does not exist psql:install.sql:23: NOTICE: CREATE TABLE will create implicit sequence "jar_re pository_jarid_seq" for serial column "jar_repository.jarid" psql:install.sql:23: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit in dex "jar_repository_pkey" for table "jar_repository" psql:install.sql:23: NOTICE: CREATE TABLE / UNIQUE will create implicit index " jar_repository_jarname_key" for table "jar_repository" CREATE TABLE GRANT psql:install.sql:32: NOTICE: CREATE TABLE will create implicit sequence "jar_en try_entryid_seq" for serial column "jar_entry.entryid" psql:install.sql:32: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit in dex "jar_entry_pkey" for table "jar_entry" psql:install.sql:32: NOTICE: CREATE TABLE / UNIQUE will create implicit index " jar_entry_jarid_entryname_key" for table "jar_entry" CREATE TABLE GRANT ALTER TABLE psql:install.sql:43: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit in dex "classpath_entry_pkey" for table "classpath_entry" CREATE TABLE GRANT psql:install.sql:50: NOTICE: CREATE TABLE will create implicit sequence "typema p_entry_mapid_seq" for serial column "typemap_entry.mapid" psql:install.sql:50: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit in dex "typemap_entry_pkey" for table "typemap_entry" CREATE TABLE GRANT 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 psql:install.sql:75: ERROR: language "java" does not exist psql:install.sql:79: ERROR: language "java" does not exist psql:install.sql:83: ERROR: language "java" does not exist psql:install.sql:87: ERROR: language "java" does not exist