agora inbox for pljava-dev@postgresql.org  
help / color / mirror / Atom feed
Subject: [Pljava-dev] pljava on AIX for postgres 9.1.x and IBM AIX Java 6?
Date: Thu, 11 Oct 2012 19:15:13 -0700
Message-ID: <50777D31.70707@hogranch.com> (raw)
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>

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





view thread (17+ messages)  latest in thread

Message-ID: <50777D31.70707@hogranch.com>
Permalink:  ../50777D31.70707@hogranch.com/
Also on:    postgresql.org/message-id/50777D31.70707@hogranch.com

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] pljava on AIX for postgres 9.1.x and IBM AIX Java 6?
  In-Reply-To: <50777D31.70707@hogranch.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox