[Pljava-dev] CVS HEAD is now Java 6.

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/