From: essaid.kharrazen at noos.fr (EsSaid Kharrazen) Date: Fri, 21 Jul 2006 12:56:04 +0200 Subject: [Pljava-dev] problems installing PL/Java under Mac OS 10.3.9 In-Reply-To: <44BF561F.6070109@tada.se> References: <44BF561F.6070109@tada.se> Message-ID: <44C0B2C4.8090009@noos.fr> Hello Joachim, I have the same platform (MacOS X 10.3.9, Postgres 8.1.4 PL/Java 1.3) and did not experienced any problem in installing and running PL/Java. I compared your installation parametter with mine and see only one difference is: in my configuration the files pljava.so an pljava.jar are installed in the standard postgres lib directory $libdir which in my configuration is located in /usr/local/pgsql/lib. Those two files belongs to the postgres user which in my installation is named postgres. So, I didn't add any dynamic_library_path in the postgres.conf file. I have only the two lines: custom_variable_classes = 'pljava' pljava.classpath = '/usr/local/pgsql/lib/pljava.jar' Also, I did not set any LD_LIBRARY_PATH environnement variable because I just thought that if Postgres is able to find its own dynamic or shared libraries from $libdir then no need to set any thing for it to find the pljava.so. I would like to here from you if you could check if changing installation to make it looks like mine make things works. However in my installation I have a problem in the last step which consist in running the pljava tests. On my platform all plajava tests succeds excpet two of them testSavepointSanity and testTransactionRecovery. I am interested in seeing if the tests produce the same result on your platform. Hope this will help Thomas Hallgren wrote: >Hi Joachim, >Aside from what's in the docs >(http://wiki.tada.se/wiki/display/pljava/Posix+Installation) I have no >clue. I've never used Mac OS. Does anyone else on this list have some >advice for Joachim? > >Regards, >Thomas Hallgren > >Joachim Hammer wrote: > > >>I have Postgres v. 8.1.4 and PL/Java 1.3. I build PL/Java from source >>(JDK 1.4) and I am >>ready to install it in Postgres. I modified the postgresql.conf file >>according to the readme >>instructions and also installed the latest version JDBC on my system: >> >>dynamic_library_path ='$libdir:/usr/share/pljava/pljava' >> >>custom_variable_classes = 'pljava' >> >>pljava.classpath='/usr/share/pljava/pljava.jar' >> >> >>Can anybody tell me what the settings for LD_LIBRARY_PATH >>should be? >> >>When I execute the PL/Java deployer, I get the following error: >> >>java.sql.SQLExeption: ERROR: could not access file "pljava": No such >>file or directory. >> >>Thanks, >> >>Joachim >> >>_______________________________________________ >>Pljava-dev mailing list >>Pljava-dev at gborg.postgresql.org >>http://gborg.postgresql.org/mailman/listinfo/pljava-dev >> >> >> > >_______________________________________________ >Pljava-dev mailing list >Pljava-dev at gborg.postgresql.org >http://gborg.postgresql.org/mailman/listinfo/pljava-dev > > > > -------------- next part -------------- An HTML attachment was scrubbed... URL: