From: Jon.Roberts at asurion.com (Roberts, Jon)
Date: Thu, 17 Jun 2010 11:09:18 -0500
Subject: [Pljava-dev] plJava installation problems in Windows 7
In-Reply-To: <AANLkTimlh3Y3ObJ42JnY5xAA34XxcmZkS2e_XVMrGfQi@mail.gmail.com>
References: <AANLkTil_Ss8GFeZyvzebX-uvYfzZB1fKnHhEeCrzsVep@mail.gmail.com>
	<8661B041D452404E8088FBD47D2443BE02037762@NDCEXCUS703.int.asurion.com>
	<AANLkTimlh3Y3ObJ42JnY5xAA34XxcmZkS2e_XVMrGfQi@mail.gmail.com>
Message-ID: 
 <8661B041D452404E8088FBD47D2443BE020377B6@NDCEXCUS703.int.asurion.com>

Do you have pljava.dll in C:\Program Files (x86)\PostgreSQL\8.3\lib ?

 

 

Jon

From: swaroop [mailto:rath.swaroop at gmail.com] 
Sent: Thursday, June 17, 2010 11:04 AM
To: Roberts, Jon; pljava-dev at pgfoundry.org
Subject: Re: [Pljava-dev] plJava installation problems in Windows 7

 

Hi Jon

 

 Thanks for the instructions. I tried everything below but no luck. It
still says cannot find pljava.dll.

 

Jon/Guys - Any other suggestion ?

 

Regards
Swaroop



On Thu, Jun 17, 2010 at 4:30 PM, Roberts, Jon <Jon.Roberts at asurion.com>
wrote:

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/3c7c6433/attachment.html>