From: eric.kolotyluk at gmail.com (Eric Kolotyluk)
Date: Sun, 23 Jan 2011 10:40:06 -0800
Subject: [Pljava-dev] Windows binaries
In-Reply-To: <op.vprxbo05uxs6vk@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>
Message-ID: <4D3C7606.5080205@gmail.com>

On 2011-01-23 10:22 AM, Johann 'Myrkraverk' Oskarsson wrote:
> On Sun, 23 Jan 2011 18:11:52 -0000, Eric Kolotyluk 
> <eric.kolotyluk at gmail.com> wrote:
>
>> The pljava.dll file is certainly in the lib directory, so I can't 
>> understand why it is complaining it cannot find it.
>
> Try putting it in a directory without any spaces and add it to 
> dynamic_library_path in postgresql.conf.  Also make sure your JVM dll 
> is in the path of your server process.  I believe that's how they're 
> located on Windows.  Otherwise you may have to look up how it's located.
>
> If all else fails, I believe the full path to the dll can be set 
> within the install.sql.  Let me know how the other tips work out 
> before I spend time to confirm or deny it.
>
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'

I do not know how to confirm

"Also make sure your JVM dll is in the path of your server process."

Also, per the instructions I added the following to my postgresql.conf 
file earlier - is this correct?

# define "pljava" as a custom variable class. This is a comma separated
# list of names.
#
custom_variable_classes = 'pljava'

# define the class path that the JVM will use when loading the
# initial library. Only meaningful for non GCJ installations
#
pljava.classpath = 'C:\Program Files 
(x86)\PostgresPlus\9.0SS\PostGIS\java\pljava\postgis_pljava.jar'

# Set the size of the prepared statement MRU cache
#
pljava.statement_cache_size = 10

# If true, lingering savepoints will be released on function exit. If false,
# the will be rolled back
#
pljava.release_lingering_savepoints = true

# Define startup options for the Java VM.
#
pljava.vmoptions = '-Xmx64M'

# Setting debug to true will cause the postgres process to go
# into a sleep(1) loop on its first call to java. This variable is
# only useful if you want to debug the PL/Java internal C code.
#
pljava.debug = false