From: johann at 2ndquadrant.com (Johann 'Myrkraverk' Oskarsson)
Date: Mon, 05 Dec 2011 12:00:09 +0000
Subject: [Pljava-dev] CVS HEAD is now Java 6.
In-Reply-To: <4ED91C50.5030201@hogranch.com> (John R. Pierce's message of
 "Fri,
	02 Dec 2011 10:43:28 -0800")
References: <x6r51s1vrt.fsf@2ndquadrant.com> <4ED7E5DE.7040703@hogranch.com>
	<C1A6B6FC8196CF43B9B4D0D2C63BFA5A18CB4FCF39@SPR3V9.office.local>
	<4ED91C50.5030201@hogranch.com>
Message-ID: <x6obvnw7na.fsf@2ndquadrant.com>

John R Pierce <pierce at hogranch.com> writes:

> On 12/02/11 1:17 AM, David Gradwell wrote:
>> Just so you know, I'm using the current version of pljava against
>> 64 bit postgres 9.0 and jdk1.6.0_26.

I tried reproducing your whole setup as you explained it on #pljava.

On CentOS 5 (I don't have CentOS 6) 64bit.

* PGDG Postgres 9.0 installed with yum.

* Oracle Java installed from RPM.  1.6.0_29 though.

* PL/Java compiled from HEAD with JAVA_HOME=/usr/java/latest and
  USE_LD_RPATH=1.

* PL/Java installed in /usr/share/pljava

* dynamic_library_path = '$libdir:/usr/share/pljava'
  
  custom_variable_classes = 'pljava'

  pljava.classpath = '/usr/share/pljava.jar'

And my smoke test works fine:

postgres=# create function sysprop( text ) returns text as
           'java.lang.System.getProperty' language java;

CREATE FUNCTION
postgres=# select sysprop( 'java.home' );

          sysprop
---------------------------
 /usr/java/jdk1.6.0_29/jre
(1 row)

Can you try upgrading your Java and rebuild again?  Please make sure
/usr/java/latest/bin and /usr/pgsql-9.0/bin are prefixed to your PATH.

Or you can use /usr/java/1.6.0_xx eplicitly for both JAVA_HOME and
your path.


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