[Pljava-dev] Windows binaries

On 2011-01-23 10:51 AM, Johann 'Myrkraverk' Oskarsson wrote:
> On Sun, 23 Jan 2011 18:40:06 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> 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