Installing Java Stored Procedures on PostgreSQL 8.0 (Win)   November 17th, 2007

February 2005

look at the page PL Java Website.
change the file C:\Program Files\PostgreSQL\8.0\data\postgresql.conf:

dynamic_library_path = '$libdir;C:/Program Files/PostgreSQL/8.0/pljava'
custom_variable_classes = 'pljava'
pljava.classpath = 'C:/Program Files/PostgreSQL/8.0/pljava/pljava.jar'

Set the classpath:

set CLASSPATH=%CLASSPATH%;deploy.jar;..\jdbc\postgresql-8.0.309.jdbc2.jar;pljava.jar

change into directory “Program Files\PostgreSQL\8.0\pljava” and execute

java org.postgresql.pljava.deploy.Deployer -install -database mydatabase -user somesuperuser -password mypasswd

I got the error:

java.sql.SQLException: ERROR: could not load library "C:/Programme/PostgreSQL/8.0/lib/libpljava.dll": dynamic load error

This page helped me a lot: Debugging PostgreSQL.

runas /user:postgres cmd.exe
postmaster -d 5 -D ../data/

I started postmaster in one command line box, and then psql in another DOS box. That told me that jvm.dll could not be found. Finally I realised, that the path needs to be set before the postmaster is started.

Tags: , , ,
This entry was posted on Saturday, November 17th, 2007 at 11:39 pm and is filed under Software Development. You can follow any responses to this entry through the RSS 2.0 feed.Both comments and pings are currently closed.

No Responses