From: pierce at hogranch.com (John R Pierce)
Date: Thu, 11 Oct 2012 19:15:13 -0700
Subject: [Pljava-dev] pljava on AIX for postgres 9.1.x and IBM AIX Java
 6?
In-Reply-To: <50776924.6080504@hogranch.com>
References: <50651F8A.1080704@hogranch.com> <50660523.5050503@hogranch.com>
	<50660A90.3020308@hogranch.com> <5069E7C8.4090004@hogranch.com>
	<5073DEED.8030504@hogranch.com> <507472B6.3060100@hogranch.com>
	<507474C0.1010304@hogranch.com> <50749A49.8060003@hogranch.com>
	<5075C351.1010101@hogranch.com> <5075C9D9.9080303@ejurka.com>
	<5075FE04.4020407@hogranch.com> <50775D08.9030409@hogranch.com>
	<5077662B.2000607@ejurka.com> <50776924.6080504@hogranch.com>
Message-ID: <50777D31.70707@hogranch.com>

On 10/11/12 5:49 PM, John R Pierce wrote:
> On 10/11/12 5:36 PM, Kris Jurka wrote:
>> Is there a libpljava.a in your build tree that didn't get installed? 
>> If so you could try copying it over to where pljava.so is located.
>
>
> libpljava.a is built en route to building pljava.so... in fact, 
> pljava.so is pretty much libpljava.a ld'd into a .so


and... oh wow.   I thought .a files were just used at link time?!? 
anyways, yeah, I copied it to the target too, and now the deployer runs.

so...

$ psql -c "SELECT 
sqlj.install_jar('file:///opt/xxx/pljava/examples.jar', 'samples', true);"
INFO:  JVMJ9VM011W Unable to load jclscar_23: No such file or directory
ERROR:  Failed to create Java VM

$ find /usr/java5_64 -name \*jclscar_23\*
/usr/java5_64/jre/bin/libjclscar_23.so

hoookay....   in my postgres server init.d script, I have...

export PATH=/usr/bin:/opt/pgsql91/bin
export PGDATA=/u01/pgsql91/data
#### pljava stuff...
export JAVA_HOME=/usr/java5_64
export 
LIBPATH=$JAVA_HOME/jre/lib/ppc64:$JAVA_HOME/jre/bin:/opt/xxx/pljava:/opt/pgsql91/lib
export PATH=$PATH:$JAVA_HOME/bin

and, in my postgresql.conf I have...


dynamic_library_path = '$libdir:/opt/xxx/pljava:/usr/java5_64/jre/bin'
custom_variable_classes = 'pljava'
pljava.classpath = '/opt/xxx/pljava/pljava.jar'


color me stumped.... again.



-- 
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast