From: | Jon(dot)Roberts at asurion(dot)com (Roberts, Jon) |
---|---|
To: | |
Subject: | [Pljava-dev] plJava installation problems in Windows 7 |
Date: | 2010-06-17 15:30:22 |
Message-ID: | 8661B041D452404E8088FBD47D2443BE02037762@NDCEXCUS703.int.asurion.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
I use Windows 7 64 bit with PostgreSQL 8.3 and Java 1.6. I have the
following settings:
Environment Variables
CLASSPATH=C:\Program Files (x86)\PostgreSQL\8.3\share\pljava.jar
JAVA_HOME=C:\Program Files (x86)\Java\jre6
LD_LIBRARY_PATH=C:\Program Files (x86)\PostgreSQL\8.3\lib;C:\Program
Files (x86)\Java\jre6\lib\i386
PATH includes: C:\Program Files (x86)\Java\jre6\bin;C:\Program Files
(x86)\Java\jre6\bin\client;C:\Program Files (x86)\Java\jdk1.6.0_20\bin;
And in my postgresql.conf file
custom_variable_classes = 'pljava'
pljava.classpath = 'C:\Program Files
(x86)\PostgreSQL\8.3\share\pljava.jar'
Jon
From: pljava-dev-bounces at pgfoundry.org
[mailto:pljava-dev-bounces at pgfoundry.org] On Behalf Of swaroop
Sent: Thursday, June 17, 2010 10:19 AM
To: pljava-dev at pgfoundry.org
Subject: [Pljava-dev] plJava installation problems in Windows 7
Hi
I installed postgresql on windows 7 usign the standard installer. The
document at "http://wiki.tada.se/index.php/Windows_Installation" says
that pljava will be automatically installed.
I doubt if it was installed. I tried running install.sql script in
C:\Project\Postgre_installer\share\pljava. The following sql fails with
the error "ERROR: could not load library
"C:/Project/Postgre_installer/lib/pljava.dll": The specified module
could not be found."
I made sure that jvm.dll is on my path.I am using jdk1.6. "C:\"Program
Files (x86)"\Java\jdk1.6.0_11\jre" Please help me here. I have been
trying a lot of workarounds but nothing seems to work.
CREATE FUNCTION sqlj.java_call_handler()
RETURNS language_handler AS 'pljava'
LANGUAGE C;
Regards
Swaroop
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20100617/e4b44dc1/attachment.html>
From | Date | Subject | |
---|---|---|---|
Next Message | swaroop | 2010-06-17 16:04:17 | [Pljava-dev] plJava installation problems in Windows 7 |
Previous Message | swaroop | 2010-06-17 15:19:22 | [Pljava-dev] plJava installation problems in Windows 7 |