From: | david(dot)sahagian at emc(dot)com (david(dot)sahagian at emc(dot)com) |
---|---|
To: | |
Subject: | [Pljava-dev] Failed to create Java VM, WinXP |
Date: | 2011-06-24 19:49:59 |
Message-ID: | F3CBFBA88397EA498B22A05FFA9EC49D295E9189@MX22A.corp.emc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
I am trying to get pljava set up on my Windows XP machine.
()
I am running
"PostgreSQL 9.0beta4, compiled by Visual C++ build 1500, 32-bit"
()
I downloaded: pljava-i686-pc-mingw32-pg9.0-1.4.2.tar.gz
()
I made these changes to postgresql.conf . . .
custom_variable_classes = 'pljava'
pljava.classpath = 'C:\\Program Files\\PostgreSQL\\9.0\\lib\\pljava.jar'
()
I replaced the files "pljava.dll" and "pljava.jar",
which were in C:\Program Files\PostgreSQL\9.0\lib,
with the files in the pljava download.
()
I added the following entries to the PATH var:
set PATH=%PATH%;C:\Program Files\Java\jre6\bin;C:\Program Files\Java\jre6\bin\client
()
I restarted my laptop.
()
I applied "install.sql" to the db, using psql.
and saw:
CREATE SCHEMA
GRANT
CREATE FUNCTION
CREATE LANGUAGE
. . .
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
()
I did
CREATE or Replace FUNCTION getsysprop(VARCHAR)
RETURNS VARCHAR
AS 'java.lang.System.getProperty'
LANGUAGE java;
This worked, it created the function in the "public" schema.
()
But when I ran this:
SELECT getsysprop('user.home');
I got:
ERROR: Failed to create Java VM
Can somebody help me troubleshoot my failed attempt at installing ?
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | janardhan.prabhakara at emc.com | 2011-06-24 21:10:01 | [Pljava-dev] Failed to create Java VM, WinXP |
Previous Message | Eric Kolotyluk | 2011-05-21 18:23:39 | [Pljava-dev] Extension libraries are required to use the PG_MODULE_MAGIC macro |