From: thhal at mailblocks.com (Thomas Hallgren)
Date: Mon, 12 Sep 2005 18:55:35 +0200
Subject: [Pljava-dev] Re: Newbie: unable to get pl/JAVA running
References: <4325B307.4020705@mailblocks.com>
	<thhal-0kEsBBHns8LQp/VRWzIJTKLctAGylYs@mailblocks.com>
Message-ID: <thhal-0kUsBBHvs8LQTkcLB712jYGAugwyLwd@mailblocks.com>

Ok, that rules out item #1. How do you start your postmaster? Is it a 
windows service? If so, is the PATH setting a System path? If it is, I'm 
short of explanations. If you have a valid JRE installation at 
C:\Program Files\JAVA\jre1.5.0_04 and you have a PATH that includes both 
bin\client and bin of that directory, and the postmaster is using that 
PATH, then it should work.

Regards,
Thomas Hallgren


Mark J Camilleri wrote:

>Thomas, alas I think that neither of your reasons is the cause of this
>error.  I have renamed the libpljava.dll and the error returned is
>different:
>
>  
>
>>ERROR:  could not access file "libpljava": No such file or directory
>>    
>>
>
>This means that postmaster is actually finding the file but is failing for
>some other, God knows what, blessed reason!
>
>Thanks again for your help
>MJC
>
>-----Original Message-----
>From: Thomas Hallgren [mailto:thhal at mailblocks.com] 
>Sent: 12 September 2005 01:01
>To: Mark J Camilleri
>Cc: Pljava-dev at gborg.postgresql.org
>Subject: Re: Newbie: unable to get pl/JAVA running
>
>I can see two possible reasons for that:
>1. libpljava.dll does not reside in C:\Program 
>Files\PostgreSQL\8.0\jdbc\PLJava
>2. The postgresql backend (i.e. the postmaster) is not aware of your 
>PATH setting.
>
>Regards,
>Thomas Hallgren
>
>Mark J Camilleri wrote:
>
>  
>
>>Thanks for your reply Thomas.  I amended the PATH setting but unfortunately
>>the same error is still being generated.
>>
>>Regs,
>>MJC
>>
>>-----Original Message-----
>>From: Thomas Hallgren [mailto:thhal at mailblocks.com] 
>>Sent: 11 September 2005 21:51
>>To: Mark J Camilleri
>>Subject: Re: Newbie: unable to get pl/JAVA running
>>
>>Mark J Camilleri wrote:
>> 
>>
>>    
>>
>>>Additionally, given that I am installing pljava on Windows I have also 
>>>updated the PATH system variable with 'C:\Program 
>>>Files\JAVA\jre1.5.0_04\lib\i386'
>>>
>>>   
>>>
>>>      
>>>
>>The PATH setting doesn't look correct. On windows all the binary stuff 
>>is under <jre root>\bin\client and <jre root>\bin. So instead of your 
>>addition, try adding 'C:\Program 
>>Files\JAVA\jre1.5.0_04\bin\client;C:\Program Files\JAVA\jre1.5.0_04\bin'
>>
>>Regards,
>>Thomas Hallgren
>>
>>
>>		
>>___________________________________________________________ 
>>How much free photo storage do you get? Store your holiday 
>>snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com
>> 
>>
>>    
>>
>
>
>
>	
>	
>		
>___________________________________________________________ 
>Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com
>  
>