agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

[Pljava-dev] libpljava.dll
4+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] libpljava.dll
@ 2005-04-06 20:23  
  0 siblings, 1 reply; 4+ messages in thread

From:  @ 2005-04-06 20:23 UTC (permalink / raw)

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





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* [Pljava-dev] libpljava.dll
@ 2005-04-06 20:29  
  0 siblings, 0 replies; 4+ messages in thread

From:  @ 2005-04-06 20:29 UTC (permalink / raw)

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





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* [Pljava-dev] libpljava.dll
@ 2005-04-06 20:33  
  parent: 
  0 siblings, 1 reply; 4+ messages in thread

From:  @ 2005-04-06 20:33 UTC (permalink / raw)

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






^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* [Pljava-dev] libpljava.dll
@ 2005-04-07 01:38  
  parent: 
  0 siblings, 0 replies; 4+ messages in thread

From:  @ 2005-04-07 01:38 UTC (permalink / raw)

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





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

end of thread, other threads:[~2005-04-07 01:38 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-06 20:23 [Pljava-dev] libpljava.dll 
2005-04-06 20:33 ` 
2005-04-07 01:38   ` 
2005-04-06 20:29 [Pljava-dev] libpljava.dll 

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox