From: blakemiller at cdmplus.com (Blake Miller) Date: Tue, 10 Apr 2007 12:29:40 -0400 Subject: [Pljava-dev] Windows cannot access file pljava file Message-ID: 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: