From: camilo at png.com.co (=?iso-8859-1?Q?Camilo_Andr=E9s_Soto_Montoya?=)
Date: Wed, 6 Apr 2005 15:23:54 -0500
Subject: [Pljava-dev] libpljava.dll
Message-ID: <003501c53ae6$91f29350$3f00a8c0@camilo>

Hello all.

I'm having this problem deployin PLJava in Postgresql 8.0

C:\Archivos de programa\PostgreSQL\8.0\pljava>java -cp "C:\Archivos de
programa\
PostgreSQL\8.0\jdbc\postgresql-8.0.309.jdbc3.jar;C:\Archivos de
programa\Postgre
SQL\8.0\pljava\deploy.jar"
org.postgresql.pljava.deploy.Deployer -install -user
postgres -database cmpcs -password postgres
java.sql.SQLException: ERROR: could not load library "C:/Archivos de
programa/Po
stgreSQL/8.0/pljava/libpljava.dll": dynamic load error
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:1365)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1160)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:172)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:387)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:312)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:304)
        at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:
419)
        at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)


My path is:

PATH=C:\ant\bin\;C:\Archivos de
programa\Java\jdk1.5.0_01\bin\;D:\WINDOWS\system
32;D:\WINDOWS;D:\WINDOWS\System32\Wbem;C:\php4;C:\Archivos de
programa\PostgreSQ
L\8.0\bin;C:\Archivos de programa\Java\jre1.5.0_01\bin;C:\Archivos de
programa\J
ava\jre1.5.0_01\bin\client;C:\JOnAS-4.2.3\bin\nt

and the pljava configuration part in the postgresql.conf file is:

# define "pljava" as a custom variable class. This is a comma separated
# list of names.
#
custom_variable_classes = 'pljava'

# define the class path that the JVM will use when loading the
# initial library. Only meaningful for non GJC installations
#
pljava.classpath = 'C:/Archivos de
programa/PostgreSQL/8.0/pljava/pljava.jar'

# Set the size of the prepared statement MRU cache
#
pljava.statement_cache_size = 10

# If true, lingering savepoints will be released on function exit. If false,
# the will be rolled back
#
pljava.release_lingering_savepoints = true

# Define startup options for the Java VM.
#
pljava.vmoptions = '-Xmx64M -Dbackchannel.port=48'

# Setting debug to true will cause the postgres process to go
# into a sleep(1) loop on its first call to java. This is
# only useful if you want to debug the PLJava internal C code.
#
pljava.debug = false

dynamic_library_path = '$libdir;C:/Archivos de
programa/PostgreSQL/8.0/pljava/'



Thank you for your help

Camilo Soto