Version: 8.3
Platform: Windows=20
Installation: Clicked the pl/java checkbox on installation
Postgresql.conf changes
custom_variable_classes =3D 'pljava'
pljava.classpath=3D'C:\\Program
Files\\PostgreSQL\\8.3\\share\\pljava.jar'
OS Path: I added C:\Program Files\Java\jdk1.6.0_02\jre\bin\client and
this is where my jvm.dll file is.
Executing:
CREATE SCHEMA sqlj;
CREATE FUNCTION sqlj.java_call_handler()
RETURNS language_handler AS 'pljava'
LANGUAGE C;
ERROR: could not load library "C:/Program
Files/PostgreSQL/8.3/lib/pljava.dll": The specified module could not be
found.
********** Error **********
ERROR: could not load library "C:/Program
Files/PostgreSQL/8.3/lib/pljava.dll": The specified module could not be
found.
SQL state: 58P01
I confirmed that pljava.dll is in that directory so it must be a
dependency problem.
Bug #3897 indicates this was a problem for 8.3RC3. Was this fixed in
the final release?=20=20
Jon