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
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 |