[Pljava-dev] pljava on AIX for postgres 9.1.x and IBM AIX Java 6?

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