[Pljava-dev] Fwd: Re: Calling it a day

OK, after extensive testing I am able to run

1. Windows 7 Ultimate x64, Postgres x86, PLJava x86, Java x86
2. Windows 7 Ultimate x64, Postgres x64, PLJava x64, Java x64

I'm baffled why I could not get (1) to work before. I can only assume
there was some configuration problem somewhere - there are just to many
configuration variables in play.

I also learned that there are two version of Dependency Walker x86 7
x64. You need to be running the right version when you check a DLL. This
probably screwed me up because I only had the x64 version installed
until recently.

Dependency Walker is still complaining about things, but not about CPU
architecture - however the pljava.dll seems to work anyway.

Anyway - it's good to know we can run pljava in both x86 and x64 worlds now.

Thanks for all the effort everyone.

Cheers, Eric

On 2011-05-04 8:14 AM, JOSE CARLOS MARTINEZ LLARIO wrote:
> Hi Erik,
> I just checked it out right now getting the same results than I got some weeks before.
>
> W7 64 - Pg 9 32 - JRE 32 - PLJAVA 32 - Working
> W7 64 - Pg 9 32 - JRE 64 - PLJAVA 32 - not working, with this error:
> ERROR: could not load library "c:/jaspa4pg/lib/pljava.dll": %1 is not a valid Win32 application.
>
> Do not why with JRE 64 is not working but with JRE 32 I can tell you that its working for sure.
>
> Cheers,
> Jose
>
> ________________________________
>> Date: Tue, 3 May 2011 22:48:27 -0700
>> From: eric.kolotyluk at gmail.com
>> To: pljava-dev at pgfoundry.org
>> Subject: Re: [Pljava-dev] Fwd: Re: Calling it a day
>>
>> Jose, did you ever get around to checking 32-bit pljava with 32-bit
>> Postgres and 32-bit Java on 64-bit Windows.
>>
>> I was finally able to get 64-bit pljava with 64-bit Postgres and 64-bit
>> Java to work on 64-bit windows with Johann's latest builds.
>>
>> It makes application deployment a little trickier now, but at least I
>> have solutions for both 32-bit and 64-bit windows.
>>
>> Cheers, Eric
>>
>> On 2011-04-30 4:58 AM, JOSE CARLOS MARTINEZ LLARIO wrote:
>> Hi Eric,
>> Im almost sure I already run 32-bit pljava with 32-bit Postgres and
>> 32-bit Java on 64-bit windows.
>> I wil check it again though.
>> cheers,
>> Jose
>>
>> ________________________________
>> Date: Fri, 29 Apr 2011 17:34:05 -0700
>> From: eric.kolotyluk at gmail.com
>> To: pljava-dev at pgfoundry.org
>> Subject: [Pljava-dev] Fwd: Re: Calling it a day
>>
>> Thanks for trying.
>>
>> So far this is what I have discovered (after hours of hosing around
>> with stuff):
>>
>> 1. It is not possible to run 32-bit pljava with 32-bit Postgres and
>> 32-bit Java on 64-bit windows. I have tried every variation I can think
>> of and DependencyWalker always shows that it is still trying to link
>> against 64-bit DLLs. This could be some sort of build configuration
>> problem with Postgres and/or PLJava.
>> 2. The 64-bit release of Postgres has some bad and missing DLLs in
>> it. You need to add the referenced files to the postgres/bin directory
>> (let me know if you want me to e-mail them to you). DependencyWalker
>> shows one final unresolved function: DatumGetFloat8 that I cannot find
>> anywhere. Anyway, you need to use Microsoft Visual C++ 2008
>> Redistributable Package
>> (x64)
>> instead of the (x86) version, and the version of IEShims.dll from the
>> 64-bit version of IE.
>>
>> What I know to be true is that I can run 32-bit pljava with 32-bit
>> postgres and 32-bit Java on 32-bit windows.
>>
>> The bottom line I know to be true is that Microsoft are fucking
>> assholes and make just about everything 100 times harder than it needs
>> to be for software developers.
>>
>> I'll keep slogging away and see what I can figure out.
>>
>> Cheers, Eric
>>
>> referenced files:
>>
>> * msvcm90.dll
>> * msvcp90.dll
>> * msvcr90.dll
>> * IEShims.dll
>>
>> On 2011-04-29 3:32 PM, JOSE CARLOS MARTINEZ LLARIO wrote:
>> Hi Johann,
>> ok, I will try it again next week. As soon as you get it please send it
>> to me.
>>
>> Have a nice weekend too.
>> Jose
>>
>>
>>> To: eric.kolotyluk at gmail.com;
>> jcllario at hotmail.com
>>> Subject: Calling it a day
>>> Date: Fri, 29 Apr 2011 22:27:49 +0000
>>> From: johann at 2ndquadrant.com
>>>
>>> Hi Eric and Jose,
>>>
>>> Just to let you know I'm calling it a day. I suspect the pljava
>>> binary I gave you does not work because there are no exported sym-
>>> bols in it. If that's the case, it just will not work at all.
>>>
>>> I'll dig further into this on Monday.
>>>
>>> Have a nice weekend,
>>>
>>>
>>> --
>>> Johann Oskarsson http://www.2ndquadrant.com/ |[]
>>> PostgreSQL Development, 24x7 Support, Training and Services --+--
>>> |
>>> Blog: http://my.opera.com/myrkraverk/blog/
>>
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pljava-dev
>>
>> _______________________________________________ Pljava-dev mailing list
>> Pljava-dev at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pljava-dev
>>
>>
>>
>>
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pljava-dev
>>
>> _______________________________________________ Pljava-dev mailing list
>> Pljava-dev at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110504/64d9e59a/attachment.html>