agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] Windows binaries
Date: Sun, 23 Jan 2011 11:14:24 -0800
Message-ID: <4D3C7E10.7080906@gmail.com> (raw)
In-Reply-To: <op.vpryofceuxs6vk@asuka>
References: <C1A6B6FC8196CF43B9B4D0D2C63BFA5A18C4E39967@SPR3V9.office.local>
<4D3A3076.4070905@gmail.com>
<op.vporvh2cuxs6vk@asuka>
<COL116-W28471A0A9040F98339CD80D3FB0@phx.gbl>
<4D3C6777.10708@gmail.com>
<op.vprvlq0cuxs6vk@asuka>
<4D3C6B11.3010706@gmail.com>
<op.vprv75equxs6vk@asuka>
<4D3C6F68.9060304@gmail.com>
<op.vprxbo05uxs6vk@asuka>
<4D3C7606.5080205@gmail.com>
<op.vpryofceuxs6vk@asuka>
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
view thread (42+ messages) latest in thread
Message-ID: <4D3C7E10.7080906@gmail.com>
Permalink: ../4D3C7E10.7080906@gmail.com/
Also on: postgresql.org/message-id/4D3C7E10.7080906@gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Windows binaries
In-Reply-To: <4D3C7E10.7080906@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox