From: thhal at mailblocks.com (Thomas Hallgren)
Date: Mon, 01 Aug 2005 12:18:36 +0200
Subject: [Pljava-dev]PL/JAVA on Windows
In-Reply-To: <20050801100343.28718.qmail@web26507.mail.ukl.yahoo.com>
References: <20050801100343.28718.qmail@web26507.mail.ukl.yahoo.com>
	<42EDF6FC.1000504@mailblocks.com>
	<thhal-0f4/JA2Fc77Q/AqpErj79TFfNragGql@mailblocks.com>
Message-ID: <thhal-0gI/JA2Nc77Q3Zzh5FiDQ1FT4GFfi+P@mailblocks.com>

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
>  
>