[Pljava-dev] 32bit Windows binaries are up

Dear PL/Java users,

The 32bit Windows binaries are (finally) up. Please let me know if there
are
any problems.

Installation points:

* If you are using the EnterpriseDB built server, be sure to remove the
previous binaries, typically in

C:\Program Files\PostgreSQL\x.y\lib

where x.y is the version number of the server. Delete PLJAVA.DLL and
PLJAVA.JAR from there.

* Add the Java bin directories to your system PATH. In Windows 7 this is
done in Control Panel, System, Advanced System Settings where you press the
[Environment Variables...] button.

Add to Path the following directories (substitue your Java version numbers
and installation path as appropriate)

C:\Program Files\Java\jdk1.5.0_22\jre\bin
C:\Program Files\Java\jdk1.5.0_22\jre\bin\server

Instead of bin\server you may choose bin\client. Note that path elements
are separated by ; semi-comma.

* For the Path settings to take effect, you need to restart the server.
This is done by running All Programs -> PostgreSQL x.y -> Restart Server
as administrator. Right click and choose "Run as Administrator."

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

Great news!!.Johann, thanks a lot for the Windows binaries.
Are you planning to build it for 64 bits too?
I think you mentioned (or another user) in a previous email about uploading the docs to be able to build the Windows binaries. Is it included?
One more time thanks, many users were waiting for that.
Best,Jose

----------------------------------------
> To: pljava-dev at pgfoundry.org
> Date: Mon, 18 Apr 2011 21:05:56 +0000
> From: johann at 2ndquadrant.com
> Subject: [Pljava-dev] 32bit Windows binaries are up
>
> Dear PL/Java users,
>
> The 32bit Windows binaries are (finally) up. Please let me know if there
> are
> any problems.
>
> Installation points:
>
> * If you are using the EnterpriseDB built server, be sure to remove the
> previous binaries, typically in
>
> C:\Program Files\PostgreSQL\x.y\lib
>
> where x.y is the version number of the server. Delete PLJAVA.DLL and
> PLJAVA.JAR from there.
>
> * Add the Java bin directories to your system PATH. In Windows 7 this is
> done in Control Panel, System, Advanced System Settings where you press the
> [Environment Variables...] button.
>
> Add to Path the following directories (substitue your Java version numbers
> and installation path as appropriate)
>
> C:\Program Files\Java\jdk1.5.0_22\jre\bin
> C:\Program Files\Java\jdk1.5.0_22\jre\bin\server
>
> Instead of bin\server you may choose bin\client. Note that path elements
> are separated by ; semi-comma.
>
> * For the Path settings to take effect, you need to restart the server.
> This is done by running All Programs -> PostgreSQL x.y -> Restart Server
> as administrator. Right click and choose "Run as Administrator."
>
>
> --
> 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

Hi Jose,

On Tue, 19 Apr 2011 14:01:13 -0000, JOSE CARLOS MARTINEZ LLARIO
<jcllario at hotmail.com> wrote:

> Great news!!.Johann, thanks a lot for the Windows binaries.
> Are you planning to build it for 64 bits too?

I'm working on it.

> I think you mentioned (or another user) in a previous email about
> uploading the docs to be able to build the Windows binaries. Is it
> included?

Do you mean a howto for it? No, I've not written any directions for that.

It is pretty straight forward but does require some prerequisites:

* Install MingW32 (or, if available, the 64bit version) with MSYS.

* Configure and install the relevant Postgres server in the MSYS shell.
You
do not need to run that server though. It is only required for the build
process.

* Install JDK 1.5 (or 1.4) where you can put in in your PATH in the MSYS
shell. This does not need to be the Java you use to run it so it does
not
need to be in your system path.

* Set JAVA_HOME to point to the previously installed JDK.

* Set the previously built Postgres server to your PATH in the MSYS shell.

* Run "make" in the PL/Java source directory.

> One more time thanks, many users were waiting for that.
> Best,Jose

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

On 20/04/11 14:58, Johann 'Myrkraverk' Oskarsson wrote:
> Hi Jose,
>
> On Tue, 19 Apr 2011 14:01:13 -0000, JOSE CARLOS MARTINEZ LLARIO
> <jcllario at hotmail.com> wrote:
>
>> Great news!!.Johann, thanks a lot for the Windows binaries.
>> Are you planning to build it for 64 bits too?
>
> I'm working on it.
>
>> I think you mentioned (or another user) in a previous email about
>> uploading the docs to be able to build the Windows binaries. Is it
>> included?
>
> Do you mean a howto for it? No, I've not written any directions for
> that.
>
> It is pretty straight forward but does require some prerequisites:
>
> * Install MingW32 (or, if available, the 64bit version) with MSYS.
>
> * Configure and install the relevant Postgres server in the MSYS
> shell. You
> do not need to run that server though. It is only required for the
> build
> process.
>
> * Install JDK 1.5 (or 1.4) where you can put in in your PATH in the MSYS
> shell. This does not need to be the Java you use to run it so it
> does not
> need to be in your system path.
>
> * Set JAVA_HOME to point to the previously installed JDK.
>
> * Set the previously built Postgres server to your PATH in the MSYS
> shell.
>
> * Run "make" in the PL/Java source directory.
>
>> One more time thanks, many users were waiting for that.
>> Best,Jose
>
>

May I add my thanks to the pile.

--
Tim Clarke AMBCS
IT Director
Manifest
9 Freebournes Court
Newland Street
Witham, Essex
CM8 2BL
England

Phone: +44 1376 503500
Direct: +44 1376 504510
Fax: +44 1376 503550
Email: tim.clarke at manifest.co.uk <mailto:tim.clarke at manifest.co.uk>
Web: http://www.manifest.co.uk
Skype: callto:tim.clarke

Manifest is the trading name of: Manifest Information Services Ltd: Registered in England Number 3401145 & The Manifest Voting Agency Ltd:
Registered in England Number 2920820. Registered Office at above address. VAT Registration Number: GB 700 1880 77
Copyright: This e-mail may contain confidential or legally privileged information.
If you are not the named addressee you must not use or disclose such information, instead please report it to: admin at manifest.co.uk
Please see http://www.manifest.co.uk/legal/legal_notices.htm for further information.

Forgive me for being stupid, but where are the binaries?

I'm looking at
http://pgfoundry.org/frs/?group_id=1000038&release_id=1750 but I cannot
see anything recent.

Cheers, Eric

On 2011-04-18 2:05 PM, Johann 'Myrkraverk' Oskarsson wrote:
> Dear PL/Java users,
>
> The 32bit Windows binaries are (finally) up. Please let me know if
> there are
> any problems.
>
> Installation points:
>
> * If you are using the EnterpriseDB built server, be sure to remove the
> previous binaries, typically in
>
> C:\Program Files\PostgreSQL\x.y\lib
>
> where x.y is the version number of the server. Delete PLJAVA.DLL and
> PLJAVA.JAR from there.
>
> * Add the Java bin directories to your system PATH. In Windows 7 this is
> done in Control Panel, System, Advanced System Settings where you
> press the
> [Environment Variables...] button.
>
> Add to Path the following directories (substitue your Java version
> numbers
> and installation path as appropriate)
>
> C:\Program Files\Java\jdk1.5.0_22\jre\bin
> C:\Program Files\Java\jdk1.5.0_22\jre\bin\server
>
> Instead of bin\server you may choose bin\client. Note that path elements
> are separated by ; semi-comma.
>
> * For the Path settings to take effect, you need to restart the server.
> This is done by running All Programs -> PostgreSQL x.y -> Restart Server
> as administrator. Right click and choose "Run as Administrator."
>
>

On Fri, 29 Apr 2011 16:55:08 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:

> Forgive me for being stupid, but where are the binaries?
>
> I'm looking at
> http://pgfoundry.org/frs/?group_id=1000038&release_id=1750 but I cannot
> see anything recent.

You are looking at:

pljava-i686-pc-mingw32-pg8.2-1.4.2.tar.gz 448 KB 5 i386 .gz
pljava-i686-pc-mingw32-pg8.3-1.4.2.tar.gz 448 KB 3 i386 .gz
pljava-i686-pc-mingw32-pg8.4-1.4.2.tar.gz 448 KB 17 i386 .gz
pljava-i686-pc-mingw32-pg9.0-1.4.2.tar.gz 448 KB 22 i386 .gz

I did not change the release date for 1.4.2 itself when I uploaded the
binaries.

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

When I open

pljava-i686-pc-mingw32-pg9.0-1.4.2.tar.gz 448 KB 22 i386 .gz

I cannot find any pljava.dll and pljava.jar is dated 2011-01-20

Sorry, I'm still not understanding.

Also, if I remove pljava.dll and pljava.jar from the Enterprise DB
release, then where do your binaries go?

Cheers, Eric

On 2011-04-29 10:58 AM, Johann 'Myrkraverk' Oskarsson wrote:
> On Fri, 29 Apr 2011 16:55:08 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> Forgive me for being stupid, but where are the binaries?
>>
>> I'm looking at
>> http://pgfoundry.org/frs/?group_id=1000038&release_id=1750 but I
>> cannot see anything recent.
>
> You are looking at:
>
> pljava-i686-pc-mingw32-pg8.2-1.4.2.tar.gz 448 KB 5 i386 .gz
> pljava-i686-pc-mingw32-pg8.3-1.4.2.tar.gz 448 KB 3 i386 .gz
> pljava-i686-pc-mingw32-pg8.4-1.4.2.tar.gz 448 KB 17 i386 .gz
> pljava-i686-pc-mingw32-pg9.0-1.4.2.tar.gz 448 KB 22 i386 .gz
>
> I did not change the release date for 1.4.2 itself when I uploaded the
> binaries.
>
>

On Fri, 29 Apr 2011 19:02:36 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:

> When I open
>
> pljava-i686-pc-mingw32-pg9.0-1.4.2.tar.gz 448 KB 22 i386 .gz

When I list the file contents I get

% star tf ~/Downloads/PostgreSQL/pljava-i686-pc-mingw32-pg9.0-1.4.2.tar.gz
-z
./
./deploy.jar
./docs.tar
./examples.jar
./install.sql
./pljava.dll
./pljava.jar
./uninstall.sql
star: 306 blocks + 0 bytes (total of 3133440 bytes = 3060.00k).

Are you sure you are able to read the file? I was suspicious that Windows
unzip utilities would not be able to read .tar.gz files, but I have heard
the later versions can.

> I cannot find any pljava.dll and pljava.jar is dated 2011-01-20

The files are there, pljava.jar and pljava.dll.

> Also, if I remove pljava.dll and pljava.jar from the Enterprise DB
> release, then where do your binaries go?

Just put them exactly where the Enterprise DB ones were. Of course,
it's prudent to take a backup or just rename them instead of deleting
them.

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

I use 7zip for archives - it reads everything and runs faster than
anything else I've seen.

Sorry, I downloaded pljava-i686-pc-linux-gnu-pg9.0-1.4.2 by mistake.

I can see the files in pljava-i686-pc-mingw32-pg9.0-1.4.2, and the dates
look better too.

OK, I thought the files went back in the Postgres/lib directory, but
when you said "remove" instead of "replace" I was confused.

Thanks for indulging me in a slow moment.

Cheers, Eric

On 2011-04-29 12:45 PM, Johann 'Myrkraverk' Oskarsson wrote:
> On Fri, 29 Apr 2011 19:02:36 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> When I open
>>
>> pljava-i686-pc-mingw32-pg9.0-1.4.2.tar.gz 448 KB 22 i386 .gz
>
> When I list the file contents I get
>
> % star tf
> ~/Downloads/PostgreSQL/pljava-i686-pc-mingw32-pg9.0-1.4.2.tar.gz -z
> ./
> ./deploy.jar
> ./docs.tar
> ./examples.jar
> ./install.sql
> ./pljava.dll
> ./pljava.jar
> ./uninstall.sql
> star: 306 blocks + 0 bytes (total of 3133440 bytes = 3060.00k).
>
> Are you sure you are able to read the file? I was suspicious that
> Windows
> unzip utilities would not be able to read .tar.gz files, but I have heard
> the later versions can.
>
>> I cannot find any pljava.dll and pljava.jar is dated 2011-01-20
>
> The files are there, pljava.jar and pljava.dll.
>
>> Also, if I remove pljava.dll and pljava.jar from the Enterprise DB
>> release, then where do your binaries go?
>
> Just put them exactly where the Enterprise DB ones were. Of course,
> it's prudent to take a backup or just rename them instead of deleting
> them.
>