From: eric.kolotyluk at gmail.com (Eric Kolotyluk) Date: Wed, 04 May 2011 16:01:13 -0700 Subject: [Pljava-dev] Fwd: Re: Calling it a day In-Reply-To: References: <4DBB58FD.3090004@gmail.com>, , <4DC0E8AB.4000105@gmail.com> Message-ID: <4DC1DAB9.1020105@gmail.com> 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: