From: eric.kolotyluk at gmail.com (Eric Kolotyluk)
Date: Mon, 24 Jan 2011 09:20:58 -0800
Subject: [Pljava-dev] Windows binaries
In-Reply-To: <4D3CBAF8.6080006@gmail.com>
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>	<4D3C7E10.7080906@gmail.com>
	<op.vpr0nfoauxs6vk@asuka>	<4D3CA4BD.3010206@gmail.com>
	<op.vpr76nenuxs6vk@asuka>	<4D3CAF3D.2060802@hogranch.com>
	<4D3CB385.6010403@gmail.com>	<4D3CB623.2060409@hogranch.com>
	<4D3CB765.709@gmail.com> <4D3CB76D.2040407@hogranch.com>
	<4D3CBAF8.6080006@gmail.com>
Message-ID: <4D3DB4FA.4090001@gmail.com>

On 2011-01-23 3:34 PM, Eric Kolotyluk wrote:
> On 2011-01-23 3:19 PM, John R Pierce wrote:
>> On 01/23/11 3:19 PM, Eric Kolotyluk wrote:
>>>
>>> And in what context do I execute the cacl command? Can you please 
>>> give an example.
>>
>> its a command line, executed from a Windows CMD ('DOS prompt') window.
>>
>>
> Ah, I guess you meant cacls?
>
> C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>cacls 
> c:\postgres\pljava.dll
> c:\postgres\pljava.dll BUILTIN\Administrators:(ID)F
>                        NT AUTHORITY\SYSTEM:(ID)F
>                        BUILTIN\Users:(ID)R
>                        NT AUTHORITY\Authenticated Users:(ID)C
>
> Yes, postgres is a member of Users.
>
> I even added postgres to the Administrator group, but I still get the 
> same error message.
>
> Anything else I can try?
>
> Cheers, Eric

I installed Dependency Walker to look at the pljava.dll file. It 
complained that it could not find jvm.dll, msvcr71.dll, and msvcr90.dll 
- so I put them all in the postgres lib directory where pljava.dll is. 
That problem went away.

However, Dependency Walker is still complaining about

Error: At least one module has an unresolved import due to a missing 
export function in an implicitly dependent module.
Error: Modules with different CPU types were found.
Warning: At least one module has an unresolved import due to a missing 
export function in a delay-load dependent module.

Is this a problem because I am running on a 64-bit version of Windows 7?

When I try to run install.sql I still get

C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>psql -f install.sql
Password:
CREATE SCHEMA
GRANT
psql:install.sql:6: ERROR:  could not load library "C:/Program Files 
(x86)/PostgresPlus/9.0SS/lib/pljava.dll": The specified module could not 
be found.

Does anyone else have any ideas?

Cheers, Eric