[Pljava-dev] Windows binaries

In this particular case I was using 32-bit PostgreSQL on 64-bit Windows
Ultimate - I could not get pljava.dll to load. According to Dependency
Walker the DLL is trying to resolve all kinds of 64-bit DLLs which are
not compatible with the 32-bit pljava.

When I ran the same download of 32-bit PostgreSQL on 32-bit Windows
Professional - the pljava.dll loaded fine presumably because there are
no 64-bit DLLs to resolve to.

Enterprise DB do not seem to have a binary release of 64-bit Postgres
Plus for me to try.

At the moment this is a bit of a showstopper for us as we need to be
able to deploy on both 32-bit and 64-bit Windows.

Off hand neither me nor my colleagues have heard of a situation where a
32-bit DLL does not run on 64-bit windows, so we cannot imagine what is
wrong with pljava.dll.

Cheers, Eric

On 2011-01-28 2:02 PM, JOSE CARLOS MARTINEZ LLARIO wrote:
> Hi Eric,
> When you said pljava does not work on 64-bit Windows, you are using
> postgres 64 bits or postgres 32 bits on 64-bit Windows?
> Regards,
> Jose
>
> ------------------------------------------------------------------------
> Date: Tue, 25 Jan 2011 07:26:16 -0800
> From: eric.kolotyluk at gmail.com
> To: johann at 2ndquadrant.com
> CC: pljava-dev at pgfoundry.org
> Subject: Re: [Pljava-dev] Windows binaries
>
> Thanks, that did the trick. I am able to run helloworld()
>
> Phew - nice to finally get something working.
>
> Thanks enormously everyone for helping.
>
> Who can I talk to about the reason pljava does not work on 64-bit
> Windows? I have never come across 32-bit software that does not run on
> 64-bit windows before. There must be something funny about how they
> built the DLL.
>
> Cheers, Eric
>
> On Mon, Jan 24, 2011 at 7:03 PM, Johann 'Myrkraverk' Oskarsson
> <johann at 2ndquadrant.com <mailto:johann at 2ndquadrant.com>> wrote:
>
>
> On Tue, 25 Jan 2011 00:31:44 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com <mailto:eric.kolotyluk at gmail.com>> wrote:
>
>
> but now when I try to do
>
> SELECT helloWorld();
>
> I get
>
> ERROR: java.lang.ClassNotFoundException:
> org.postgis.pljava.HelloWorld
>
>
> Seems you forgot (or did not know to) to set the classpath.
>
> SELECT sqlj.set_classpath( <schema>, <jar name> );
>
> In your case, I believe it is
>
> SELECT sqlj.set_classpath( 'public', 'postgis_pljava_jar' );
>
> You can see the proper schema to use with
>
> SHOW search_path;
>
> which, if you haven't set it to anything, will be the public one
> as in my
> example.
>
>
> --
> 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 <mailto: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/20110128/8bb1c087/attachment.html>

On Sat, 29 Jan 2011 00:51:34 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:

> Enterprise DB do not seem to have a binary release of 64-bit Postgres
> Plus for me to try.
>
> At the moment this is a bit of a showstopper for us as we need to be
> able to deploy on both 32-bit and 64-bit Windows.

That is unfortunate. At the moment I do not envision having the time to
build Windows binaries until after February 11th. There are mainly two
things that stop me. First is the complete lack of the Windows operating
system license and installation media. The second is a computer/cpu with
virtualization support so I can run 64bit Windows in a virtual machine.

> Off hand neither me nor my colleagues have heard of a situation where a
> 32-bit DLL does not run on 64-bit windows, so we cannot imagine what is
> wrong with pljava.dll.

And neither can I. I have heard of incompatible libraries such as Python
2.7 components that refused to work together. As I understood the story
that had nothing to do with 32 vs. 64 bits and had to do with incompatible
compilers or compilation settings.

>> Who can I talk to about the reason pljava does not work on 64-bit
>> Windows? I have never come across 32-bit software that does not run on
>> 64-bit windows before. There must be something funny about how they
>> built the DLL.

In an ideal world that would be I. And I have no idea who to talk to at
Enterprise DB about this.

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

On Fri, 28 Jan 2011, Eric Kolotyluk wrote:

> In this particular case I was using 32-bit PostgreSQL on 64-bit Windows
> Ultimate - I could not get pljava.dll to load. According to Dependency
> Walker the DLL is trying to resolve all kinds of 64-bit DLLs which are not
> compatible with the 32-bit pljava.

Do you have a 32 or 64 bit java? You would need a 32bit java version to
run in the same process as 32bit postgresql and 32bit plajva.

> Enterprise DB do not seem to have a binary release of 64-bit Postgres Plus
> for me to try.

EnterpriseDB does offer 64 bit versions of 9.0 for windows of the base
postgresql release. I don't know what postgres plus offers above that or
if you need it or not.

http://www.enterprisedb.com/products-services-training/pgdownload#windows

A further complication is that building a 64bit version is only
supported using MSVC at the moment. Just this week Andrew Dunstan has
gotten a 64bit mingw(the build system that pljava supports) build running.

http://archives.postgresql.org/pgsql-hackers/2011-01/msg02692.php

So to really get this all to work to run a 64 bit server, you'd have to
backpatch Andrew's patch to 9.0 and build a mingw server version and then
build pljava against that. You wouldn't necessarily need to deploy your
self-built server version, but you need it to build pljava.

> At the moment this is a bit of a showstopper for us as we need to be able to
> deploy on both 32-bit and 64-bit Windows.
>

I would stick with trying to get the 32bit server version running on 64bit
windows.

Kris Jurka

On 2011-01-28 5:38 PM, Johann 'Myrkraverk' Oskarsson wrote:
> On Sat, 29 Jan 2011 00:51:34 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> Enterprise DB do not seem to have a binary release of 64-bit Postgres
>> Plus for me to try.
>>
>> At the moment this is a bit of a showstopper for us as we need to be
>> able to deploy on both 32-bit and 64-bit Windows.
>
> That is unfortunate. At the moment I do not envision having the time
> to build Windows binaries until after February 11th. There are mainly
> two things that stop me. First is the complete lack of the Windows
> operating system license and installation media. The second is a
> computer/cpu with virtualization support so I can run 64bit Windows in
> a virtual machine.

Well, we do not need to deploy until well after Feb 11. But it would be
nice to be able to test on 64-bit windows. I do have a high end
workstation with VMWare Workstation, and Windows 7 installation ISOs
with MSDN licenses. If there is any way I could help please let me know.
I can certainly test any DLLs you want me to.

>
>> Off hand neither me nor my colleagues have heard of a situation where a
>> 32-bit DLL does not run on 64-bit windows, so we cannot imagine what is
>> wrong with pljava.dll.
>
> And neither can I. I have heard of incompatible libraries such as
> Python 2.7 components that refused to work together. As I understood
> the story that had nothing to do with 32 vs. 64 bits and had to do
> with incompatible compilers or compilation settings.

I was wondering about the compiler and linker environment you were using
for Windows. Is it GNU or Microsoft?

>
>>> Who can I talk to about the reason pljava does not work on 64-bit
>>> Windows? I have never come across 32-bit software that does not run on
>>> 64-bit windows before. There must be something funny about how they
>>> built the DLL.
>
> In an ideal world that would be I. And I have no idea who to talk to
> at Enterprise DB about this.
>

I have raised the issue on the Enterprise support forum, but have heard
nothing in a week. For the most part I have been trying to avoid having
to build the binaries myself, but I have been able to test my proof of
concept in the allotted time, so I may have an opportunity to go this
route later.

Cheers, Eric

On 2011-01-28 6:02 PM, Kris Jurka wrote:
>
>
> On Fri, 28 Jan 2011, Eric Kolotyluk wrote:
>
>> In this particular case I was using 32-bit PostgreSQL on 64-bit Windows
>> Ultimate - I could not get pljava.dll to load. According to Dependency
>> Walker the DLL is trying to resolve all kinds of 64-bit DLLs which
>> are not
>> compatible with the 32-bit pljava.
>
> Do you have a 32 or 64 bit java? You would need a 32bit java version
> to run in the same process as 32bit postgresql and 32bit plajva.

I only have the 32-bit Java in my PATH.

>
>> Enterprise DB do not seem to have a binary release of 64-bit Postgres
>> Plus
>> for me to try.
>
> EnterpriseDB does offer 64 bit versions of 9.0 for windows of the base
> postgresql release. I don't know what postgres plus offers above that or
> if you need it or not.

I wanted PostgresPlus so I could use the pljava support, and the
standard PostgreSQL binaries don't have that. In reality, we do not need
64-bit PostgreSQL at this time. I only mentioned it in case it might
help in troubleshooting the current pljava issues.

>
> http://www.enterprisedb.com/products-services-training/pgdownload#windows
>
> A further complication is that building a 64bit version is only
> supported using MSVC at the moment. Just this week Andrew Dunstan has
> gotten a 64bit mingw(the build system that pljava supports) build
> running.
>
> http://archives.postgresql.org/pgsql-hackers/2011-01/msg02692.php
>
> So to really get this all to work to run a 64 bit server, you'd have
> to backpatch Andrew's patch to 9.0 and build a mingw server version
> and then build pljava against that. You wouldn't necessarily need to
> deploy your self-built server version, but you need it to build pljava.
>
>> At the moment this is a bit of a showstopper for us as we need to be
>> able to
>> deploy on both 32-bit and 64-bit Windows.
>>
>
> I would stick with trying to get the 32bit server version running on
> 64bit windows.

Exactly! :-)

>
> Kris Jurka

Cheers, Eric

I'm running 64 bit Postgresql 9.0.1.1 on Windows 7 b(64 bit) with either Java 1.5 or Java 1.6 (1.6 preferred).

I'd be happy to test pljava against that configuration.

Regards

David

David JL Gradwell, M.A. (Cantab), F.B.C.S.
Chartered IT Professional
Head of Consulting
VocaLink
?
t: ?+44 (0)870 920 8516
m:+44 (0)7920 143 639
e: ?david.gradwell at vocalink.com
w: http://www.vocalink.com

-----Original Message-----
From: pljava-dev-bounces at pgfoundry.org [mailto:pljava-dev-bounces at pgfoundry.org] On Behalf Of Eric Kolotyluk
Sent: 29 January 2011 23:11
To: Kris Jurka
Cc: pljava-dev at pgfoundry.org
Subject: Re: [Pljava-dev] Fwd: Re: Windows binaries

On 2011-01-28 6:02 PM, Kris Jurka wrote:
>
>
> On Fri, 28 Jan 2011, Eric Kolotyluk wrote:
>
>> In this particular case I was using 32-bit PostgreSQL on 64-bit Windows
>> Ultimate - I could not get pljava.dll to load. According to Dependency
>> Walker the DLL is trying to resolve all kinds of 64-bit DLLs which
>> are not
>> compatible with the 32-bit pljava.
>
> Do you have a 32 or 64 bit java? You would need a 32bit java version
> to run in the same process as 32bit postgresql and 32bit plajva.

I only have the 32-bit Java in my PATH.

>
>> Enterprise DB do not seem to have a binary release of 64-bit Postgres
>> Plus
>> for me to try.
>
> EnterpriseDB does offer 64 bit versions of 9.0 for windows of the base
> postgresql release. I don't know what postgres plus offers above that or
> if you need it or not.

I wanted PostgresPlus so I could use the pljava support, and the
standard PostgreSQL binaries don't have that. In reality, we do not need
64-bit PostgreSQL at this time. I only mentioned it in case it might
help in troubleshooting the current pljava issues.

>
> http://www.enterprisedb.com/products-services-training/pgdownload#windows
>
> A further complication is that building a 64bit version is only
> supported using MSVC at the moment. Just this week Andrew Dunstan has
> gotten a 64bit mingw(the build system that pljava supports) build
> running.
>
> http://archives.postgresql.org/pgsql-hackers/2011-01/msg02692.php
>
> So to really get this all to work to run a 64 bit server, you'd have
> to backpatch Andrew's patch to 9.0 and build a mingw server version
> and then build pljava against that. You wouldn't necessarily need to
> deploy your self-built server version, but you need it to build pljava.
>
>> At the moment this is a bit of a showstopper for us as we need to be
>> able to
>> deploy on both 32-bit and 64-bit Windows.
>>
>
> I would stick with trying to get the 32bit server version running on
> 64bit windows.

Exactly! :-)

>
> Kris Jurka

Cheers, Eric
_______________________________________________
Pljava-dev mailing list
Pljava-dev at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pljava-dev

*****************************************************
This email is issued by a VocaLink group company. It is confidential and intended for the exclusive use of the addressee only. You should not disclose its contents to any other person. If you are not the addressee (or responsible for delivery of the message to the addressee), please notify the originator immediately by return message and destroy the original message. The contents of this email will have no contractual effect unless it is otherwise agreed between a specific VocaLink group company and the recipient.

The VocaLink group companies include, among others: VocaLink Limited (Company No 06119048, VAT No. 907 9619 87) which is registered in England and Wales at registered office Drake House, Homestead Road, Rickmansworth, WD3 1FX. United Kingdom, Voca Limited (Company no 1023742, VAT No. 907 9619 87) which is registered in England and Wales at registered office Drake House, Three Rivers Court, Homestead Road, Rickmansworth, Hertfordshire. WD3 1FX. United Kingdom, LINK Interchange Network Limited (Company No 3565766, VAT No. 907 9619 87) which is registered in England and Wales at registered office Arundel House, 1 Liverpool Gardens, Worthing, West Sussex, BN11 1SL and VocaLink Holdings Limited (Company No 06119036, VAT No. 907 9619 87) which is registered in England and Wales at registered office Drake House, Homestead Road, Rickmansworth, WD3 1FX. United Kingdom.

The views and opinions expressed in this email may not reflect those of any member of the VocaLink group. This message and any attachments have been scanned for viruses prior to leaving the VocaLink group network; however, VocaLink does not guarantee the security of this message and will not be responsible for any damages arising as a result of any virus being passed on or arising from any alteration of this message by a third party. The VocaLink group may monitor emails sent to and from the VocaLink group network.

This message has been checked for all email viruses by MessageLabs.
*************************************************************

Hi,
As I said in an email before I got the pljava binaries from the postgres plus installation, then I installed the
standard PostgreSQL from:
http://www.enterprisedb.com/products-services-training/pgdownload#windows

Windows 7 64 bits / Postres 9.0.2 32 bits -> WORKED
Windows 7 64 bits / Postres 8.4.7 32 bits -> WORKED
Windows 7 64 bits / Postres 9.0.2 64 bits -> FAILED as expected (showing pljava is not a a valid win32 application, should have said 'not valid win64 application' ?).

I didnt try it on but I guess Windows 7 32 bits is working with pljava too.

Anyone can tell me what pljava version is distributing postgres plus?..I guess it is 1.4.0 but not sure.

I am still kind of surprised that I have to take the pljava dlls from postgres plus and not from the pljava official web site. Maybe the Postgres plus guys should share their knowledge about building pljava in Windows or to give the binaries directly to the pljava project?.

Still I think we need 1.4.2 pljava binaries and the 64 bit version.

Cheers,
Jose

In my case I simply installed the latest version of "Postgres Plus" (not
standard PostgreSQL), and used the pljava that was embedded in it. That
seems to be a slight variation on what you tried.

Cheers, Eric

On Tue, Feb 1, 2011 at 9:01 AM, JOSE CARLOS MARTINEZ LLARIO <
jcllario at hotmail.com> wrote:

>
> Hi,
> As I said in an email before I got the pljava binaries from the postgres
> plus installation, then I installed the
> standard PostgreSQL from:
> http://www.enterprisedb.com/products-services-training/pgdownload#windows
>
>
> Windows 7 64 bits / Postres 9.0.2 32 bits -> WORKED
> Windows 7 64 bits / Postres 8.4.7 32 bits -> WORKED
> Windows 7 64 bits / Postres 9.0.2 64 bits -> FAILED as expected (showing
> pljava is not a a valid win32 application, should have said 'not valid win64
> application' ?).
>
> I didnt try it on but I guess Windows 7 32 bits is working with pljava too.
>
> Anyone can tell me what pljava version is distributing postgres plus?..I
> guess it is 1.4.0 but not sure.
>
> I am still kind of surprised that I have to take the pljava dlls from
> postgres plus and not from the pljava official web site. Maybe the Postgres
> plus guys should share their knowledge about building pljava in Windows or
> to give the binaries directly to the pljava project?.
>
> Still I think we need 1.4.2 pljava binaries and the 64 bit version.
>
> Cheers,
> Jose
>
>
>
> _______________________________________________
> 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/20110201/5368f577/attachment.html>