pljava failed to install in x64 Windows 7

From: Kelvin Lai <kelvin(dot)lai(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: pljava failed to install in x64 Windows 7
Date: 2010-06-14 19:57:15
Message-ID: AANLkTilmu28uFcf_HgYojtB8FnxqQDyRlje5IthjDxVJ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jean-Yves F. Barbier 2010-06-14 20:14:18 (not so?) silly question
Previous Message Kelvin Lai 2010-06-14 19:52:46 pljava failed to install in x64 Windows 7