agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Newbie: unable to get pl/JAVA running
4+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Newbie: unable to get pl/JAVA running
@ 2005-09-11 18:30
2005-09-11 19:51 ` [Pljava-dev] Re: Newbie: unable to get pl/JAVA running
0 siblings, 1 reply; 4+ messages in thread
From: @ 2005-09-11 18:30 UTC (permalink / raw)
Hi all,
I am trying to install pljava on postgres 8.0.3 (Windows XP) by running
install.sql, however I am getting the following error:
* ERROR: could not load library "C:/Program
Files/PostgreSQL/8.0/jdbc/PLJava/libpljava.dll": dynamic load error
I have made the following changes to the postgresql.conf file:
* dynamic_library_path = '$libdir;C:\\Program
Files\\PostgreSQL\\8.0\\jdbc\\PLJava'
* log_min_messages = info
* custom_variable_classes = 'pljava'
* pljava.classpath = 'C:\\Program
Files\\PostgreSQL\\8.0\\jdbc\\PLJava\\pljava.jar'
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'
Can anyone enlighten me on what the cause of the above mentioned error could
be?
Thanks,
MJC
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050911/d3d8cee9/attachment.html;
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] Re: Newbie: unable to get pl/JAVA running
2005-09-11 18:30 [Pljava-dev] Newbie: unable to get pl/JAVA running
@ 2005-09-11 19:51 `
0 siblings, 0 replies; 4+ messages in thread
From: @ 2005-09-11 19:51 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] Re: Newbie: unable to get pl/JAVA running
@ 2005-09-11 23:00
0 siblings, 0 replies; 4+ messages in thread
From: @ 2005-09-11 23:00 UTC (permalink / raw)
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
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] Re: Newbie: unable to get pl/JAVA running
@ 2005-09-12 16:55
0 siblings, 0 replies; 4+ messages in thread
From: @ 2005-09-12 16:55 UTC (permalink / raw)
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
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-09-12 16:55 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-11 18:30 [Pljava-dev] Newbie: unable to get pl/JAVA running
2005-09-11 19:51 `
2005-09-11 23:00 [Pljava-dev] Re: Newbie: unable to get pl/JAVA running
2005-09-12 16:55 [Pljava-dev] Re: Newbie: unable to get pl/JAVA running
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox