[Pljava-dev]PL/JAVA on Windows

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

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