Re: stored function (possible to access file system or call java program)?

On 10/03/11 2:18 PM, Merlin Moncure wrote:
> hm -- care to comment in more detail?

I've had to custom build it for each platform I've deployed it on, and
it then has dependencies on the exact JDK version and location. It
currently doesn't work with JDK 6, only 1.5. It also requires custom
lines be added to postgresql.conf and environment variables defined by
the postgres service startup script.

My first attempt to get it working with 64bit CentOS 6, Sun JDK
1.5.0_22, and PG 9.0.5 failed, although I need to start over and make
sure I didn't mess up a step.

The idea of dragging a whole JVM into the process context of the
postgres server also bothers me, but I must say, that once you DO get it
working, the developers in another division of $job were able to move
some code over from Oracle pljava to Postgres pljava without any
modifications at all.

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