[Pljava-dev] Help on installing pljava on Windows (no cgwin)

Juan Manuel Diaz Lara wrote:

> I am having roubles with this:
>
> From install.sql:
> ----------------------------
> CREATE FUNCTION sqlj.java_call_handler()
> RETURNS language_handler AS 'libpljava'
> LANGUAGE C;
>
> returns the following error:
>
> ERROR: could not load library "C:/Archivos de
> programa/PostgreSQL/8.0/pljava/libpljava.dll": dynamic load error
>
> Binaries:
> --------------
> pljava-i686-pc-mingw32-pg8.0-1.1.0.tar.gz
>
> System Enviroment:
> --------------------
> JAVA_HOME=C:\j2sdk1.4.2_02
> PATH=%JAVA_HOME%\bin;%JAVA_HOME%\jre\bin;%JAVA_HOME%\jre\bin\client
> CLASSPATH=C:\Archivos de programa\PostgreSQL\8.0\pljava\pljava.jar
>
> postgresql.conf:
> --------------------
> custom_variable_classes = 'pljava'
> pljava.classpath = 'C:\\Archivos de
> programa\\PostgreSQL\\8.0\\pljava\\pljava.jar'
> pljava.statement_cache_size = 10
> pljava.release_lingering_savepoints = true
> pljava.vmoptions = '-Xmx64M'
> pljava.debug = false
>
> Tanks to any body that could help me.

1. It seems your path is lacking the very essential entries %SystemRoot%
and %SystemRoot%\system32 (SystemRoot is probably C:\Windows or similar)
You won't get much working on Windows without those entries.
2. You don't need to have the CLASSPATH setting since you run PostgreSQL
8.0 or later and already have this setting in postgresql.conf
3. Your Java is very old. Consider an upgrade to either the latest 1.4.2
(1.4.2_08) or to a J2SE 5.0

Regards,
Thomas Hallgren