[Pljava-dev] libpljava.dll

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

Camilo,

>pljava.classpath = 'C:/Archivos de
>programa/PostgreSQL/8.0/pljava/pljava.jar'
>
>dynamic_library_path = '$libdir;C:/Archivos de
>programa/PostgreSQL/8.0/pljava/'
>
>
You need to use backslash on Windows and since backslash is also the
escape in postgresql.conf, you need double backslash. This is true for
both the dynamic_library_path and pljava.classpath. Try this:

pljava.classpath = 'C:\\Archivos de programa\\PostgreSQL\\8.0\\pljava\\pljava.jar'

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

Regards,
Thomas Hallgren

Maybe you have already a same problem that occour with me few days ago
during installation process.

Just, see my previous message on the maillist and change your path
acording your java instalation, off course ;-)

[]'s
Edson Luis Gon?alez
Developer

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.3 - Release Date: 5/4/2005