pljava failed to install in x64 Windows 7 - Mailing list pgsql-novice

From Kelvin Lai
Subject pljava failed to install in x64 Windows 7
Date
Msg-id AANLkTilmu28uFcf_HgYojtB8FnxqQDyRlje5IthjDxVJ@mail.gmail.com
Whole thread Raw
In response to pljava failed to install in x64 Windows 7  (Kelvin Lai <kelvin.lai@gmail.com>)
List pgsql-novice
I installed PostgreSQL on my Windows 7 64-bit machine. I set my path, classpath as follow:

Path:
   %JAVA_HOME%\bin;%JAVA_HOME%\bin\server

Classpath:
   C:\Program Files (x86)\PostgreSQL\8.4\lib\deploy.jar;C:\Program Files (x86)\PostgreSQL\8.4\lib\pljava.jar;C:\Program Files (x86)\PostgreSQL\pgJDBC\postgresql-8.4-701.jdbc4.jar

I also modified the postgresql.conf by adding the following lines:
   custom_variable_classes = 'pljava'
   pljava.classpath='c:/Program Files (x86)/PostgreSQL/8.4/lib/pljava.jar'

When I run the install.sql to install pljava, I receive the following errors:

------------------------------
CREATE SCHEMA
GRANT
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:6: ERROR:  could not load library "C:/Program Files (x86)/PostgreSQL/8.4/lib/pljava.dll": %1 is not a valid Win32 application.


psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:8: ERROR:  function sqlj.java_call_handler() does not exist
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:12: ERROR:  could not load library "C:/Program Files (x86)/PostgreSQL/8.4/lib/pljava.dll": %1 is not a valid Win32 application.


psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:14: ERROR:  function sqlj.javau_call_handler() does not exist
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:23: NOTICE:  CREATE TABLE will create implicit sequence "jar_repository_jarid_seq" for serial column "jar_repository.jarid"
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:23: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "jar_repository_pkey" for table "jar_repository"
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:23: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "jar_repository_jarname_key" for table "jar_repository"
CREATE TABLE
GRANT
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:32: NOTICE:  CREATE TABLE will create implicit sequence "jar_entry_entryid_seq" for serial column "jar_entry.entryid"
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:32: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "jar_entry_pkey" for table "jar_entry"
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:32: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "jar_entry_jarid_key" for table "jar_entry"
CREATE TABLE
GRANT
ALTER TABLE
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:43: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "classpath_entry_pkey" for table "classpath_entry"
CREATE TABLE
GRANT
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:50: NOTICE:  CREATE TABLE will create implicit sequence "typemap_entry_mapid_seq" for serial column "typemap_entry.mapid"
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:50: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "typemap_entry_pkey" for table "typemap_entry"
CREATE TABLE
GRANT
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:55: ERROR:  language "java" does not exist
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:59: ERROR:  language "java" does not exist
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:63: ERROR:  language "java" does not exist
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:67: ERROR:  language "java" does not exist
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:71: ERROR:  language "java" does not exist
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:75: ERROR:  language "java" does not exist
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:79: ERROR:  language "java" does not exist
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:83: ERROR:  language "java" does not exist
psql:C:/Program Files (x86)/PostgreSQL/8.4/share/pljava/install.sql:87: ERROR:  language "java" does not exist
------------------------------ 

Is there any clue on how to fix this? My guess is that the pljava.dll is not a 64-bit version, either that, or pljava.dll is looking for some dependency DLL that should be in 32-bit instead of 64-bit. Thanks!

--Kelvin


pgsql-novice by date:

Previous
From: Kelvin Lai
Date:
Subject: pljava failed to install in x64 Windows 7
Next
From: "Jean-Yves F. Barbier"
Date:
Subject: (not so?) silly question