[Pljava-dev] Windows cannot access file pljava file

From: blakemiller at cdmplus(dot)com (Blake Miller)
To:
Subject: [Pljava-dev] Windows cannot access file pljava file
Date: 2007-04-10 16:29:40
Message-ID: B16355EE-CB9F-4B79-B3E8-EEC89FD71535@cdmplus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

I've done a lot of searching around and followed the advice of nearly
every post out there and I still cannot get pljava installed.

I am installing on PostgreSQL 8.2 on Windows XP.

The settings in postgresql.conf are:
dynamic_library_path = '$libdir;C:\\Documents and Settings\\All Users\
\Documents\\Sandbox\\tools\\pljava\\pljava.dll'
pljava.classpath = 'C:\\Documents and Settings\\All Users\\Documents\
\Sandbox\\tools\\pljava\\pljava.jar'
custom_variable_classes = 'pljava'

The environment variables are set as:

System level:
CLASSPATH
%CLASSPATH%;C:\Documents and Settings\All Users\Documents\Sandbox
\drivers\postgresql-8.2-504.jdbc3.jar;C:\Documents and Settings\All
Users\Documents\Sandbox\tools\pljava\deploy.jar;C:\Documents and
Settings\All Users\Documents\Sandbox\tools\pljava\pljava.jar;.;C:
\Program Files\Java\jre1.5.0_06\lib\ext\QTJava.zip

PATH
%PATH%;%JAVA_HOME%\bin;%JAVA_HOME%\bin\client;%SystemRoot%\system32;%
SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\QuickTime
\QTSystem\;C:\Program Files\MySQL\MySQL Server 5.0\bin

JAVA_HOME
C:\Program Files\Java\jre1.5.0_11

I've tried running the install.sql script AND tried using the
deploy.jar method and both return the same error:
ERROR: could not access file "pljava": No such file or directory

Additional info:
The postgres service runs as a user called 'postgres'
When I log onto my database to run the install script, I log on as admin

The admin user has a normal windows account; however, it does not
seem that the postgres user does (because he doesn't show up under
user accounts, although when I tried to create a postgres account
implicitly, windows says that user already exists).

Any ideas?

Thanks for any help,
Blake Miller
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20070410/5b6a183b/attachment.html>

Browse pljava-dev by date

  From Date Subject
Next Message Thomas Hallgren 2007-04-14 22:28:46 [Pljava-dev] ?pljava wiki is not available for a time
Previous Message Joshua Ross 2007-03-30 03:03:46 [Pljava-dev] Help with pljava on centos 4.4, java 1.5.09, cvs pljava. with src rpm of postgresql 8.2.1