pg.ddx.io pljava-dev@postgresql.org mailing list archive help / color / mirror / Atom feed Subject: [Pljava-dev] Windows binaries
Date: Fri, 28 Jan 2011 23:02:42 +0100
Message-ID: <COL116-W2864527E19D11F5B20DFF4D3E10@phx.gbl> (raw )
In-Reply-To: <AANLkTinfYnLExCnscrRNxjsbn5tCc487Vk3zbj4rHXHg@mail.gmail.com >
References: <C1A6B6FC8196CF43B9B4D0D2C63BFA5A18C4E39967@SPR3V9.office.local >
<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 >
<4D3DB4FA.4090001@gmail.com >
<op.vptpwn1ouxs6vk@asuka >
<4D3DC136.8010709@gmail.com >
<op.vptr1pfeuxs6vk@asuka >
<AANLkTikurAO4_RfSUzU53uYRpuHSz56cPBoQGaV1JmDC@mail.gmail.com >
<4D3DE471.8040801@gmail.com >
<AANLkTinv44uzq0kS+dS_Dt0RN0bBDiKbB_yEQra41eOG@mail.gmail.com >
<op.vpub7pghuxs6vk@asuka >
<op.vpuf4bz9uxs6vk@asuka >
<AANLkTinfYnLExCnscrRNxjsbn5tCc487Vk3zbj4rHXHg@mail.gmail.com >
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> wrote:
On Tue, 25 Jan 2011 00:31:44 -0000, Eric Kolotyluk
<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
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/faac524b/attachment.html ;
view thread (42+ messages) latest in thread
Message-ID: <COL116-W2864527E19D11F5B20DFF4D3E10@phx.gbl>
Permalink: ../COL116-W2864527E19D11F5B20DFF4D3E10@phx.gbl/
Also on: postgresql.org/message-id/COL116-W2864527E19D11F5B20DFF4D3E10@phx.gbl
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Windows binaries
In-Reply-To: <COL116-W2864527E19D11F5B20DFF4D3E10@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox