[Pljava-dev]PL/JAVA on Windows

PostgreSQL is unable to load the libpljava.dll because it in turn
references dll's present in your Java distribution. Unlike the standard
Java binaries, they do not reside under the %JAVA_HOME%\bin directory.
You need to add:

%JAVA_HOME%\jre\bin\client;%JAVA_HOME%\jre\bin

to your PATH.

Regards,
Thomas Hallgren

Bosch wrote:

>--- Bosch <bosch_1982 at yahoo.fr> a ?crit :
>
> Zied,
> i have a problem with pl/java, i have this
> configuration :
> postgresql version :8.0
> pl/java 1.1
> j2sdk1.4.2
>
> classpath = C:\Program
> Files\PostgreSQL\8.0\pljava\deploy.jar;C:\Program
>Files\PostgreSQL\8.0\jdbc\postgresql-8.0-310.jdbc2.jar
> path =
>
>%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\PROGRA~1\ULTRAE~1;C:\j2sdk1.4.2\bin
> JAVA_HOME = C:\j2sdk1.4.2
>
> postgres.conf :
>
> custom_variable_classes = 'pljava'
> pljava.classpath =
>
>C:\\ProgramFiles\\PostgreSQL\\8.0\\pljava\\pljava.jar'
> pljava.release_lingering_savepoints = true
> pljava.statement_cache_size = 10
> pljava.vmoptions = '-Xmx64M'
> dynamic_library_path =
> '$libdir;C:\\ProgramFiles\\PostgreSQL\\8.0\\pljava\\'
> pljava.debug = false
>
>
> postgresql log:
> 2005-08-01 11:07:23 ERROR: language "java" does not
> exist
> 2005-08-01 11:07:38 ERROR: could not access file
> "libpljava": No such file or directory
> 2005-08-01 11:07:38 LOG: could not receive data
> from
> client: Aucune connexion n'a pu ?tre ?tablie car
> l'ordinateur cible l'a express?ment refus?e.
>
>
> i have run this commnd :
> java org.postgresql.pljava.deploy.Deployer -install
> -user potgres - password admin -database cmpcs
>
> I get this message :
>
> java.sql.SQLException: ERROR: could not access file
> "libpljava": No such file or
> directory
>
> please help me
>
>
>
>
>
>
>
>___________________________________________________________________________
>
> Appel audio GRATUIT partout dans le monde avec le
> nouveau Yahoo! Messenger
> T?l?chargez cette version sur
> http://fr.messenger.yahoo.com
>
>
>
>
>
>
>
>
>___________________________________________________________________________
>Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
>T?l?chargez cette version sur http://fr.messenger.yahoo.com
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>