The following bug has been logged online: Bug reference: 3897 Logged by: David Gradwell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3rc2 Operating system: Windows Server 2003 Description: plJava dll still doesn't load Details:
I've successfully installed plJava on postgres 8.2.6 using Kris Jurka's version at http://www.ejurka.com/pgsql/pljava/826/. Note that I failed to get the standard distribution download to work. I've now tried to get plJava running on 8.3rc2 (having failed on rc1 - already reported) using the pljava.dll and pljava.jar in the distribution. I can't get these to work, despite having followed the installation instructions carefully and having got them to work for 8.2.6. Error message is ERROR: could not load library "C:/pljava/pljava.dll": The specified module could not be found. (to be clear, I've set pljava.classpath='C:\\pljava\\pljava.jar' If I leave pljava.classpath unset then I get a similar error with the default library location identified.) I've checked that a copy of the distributed dll is indeed in C:\pljava ! I've got a clean machine available with only Postgres 8.3 rc2 and Netbeans IDE on it so I'm very happy to test an alternative pljava.dll and pljava.jar combination. I have a version of the Deploy code built to run under Netbeans and with some of my own diagnostics - so I can see exactly which call it is failing on (see below) and can run repeat tests for you if useful. Regards David Gradwell Failing call is in initJavaHandlers(): stmt.execute( "CREATE OR REPLACE FUNCTION sqlj.java_call_handler()" + " RETURNS language_handler" + " AS 'pljava'" + " LANGUAGE C"); ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings