agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Help on installing pljava on Windows (no cgwin)
2+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Help on installing pljava on Windows (no cgwin)
@ 2005-05-16 16:08
0 siblings, 1 reply; 2+ messages in thread
From: @ 2005-05-16 16:08 UTC (permalink / raw)
I am having roubles with this:
From install.sql:
----------------------------
CREATE FUNCTION sqlj.java_call_handler()
RETURNS language_handler AS 'libpljava'
LANGUAGE C;
returns the following error:
ERROR: could not load library "C:/Archivos de programa/PostgreSQL/8.0/pljava/libpljava.dll": dynamic load error
Binaries:
--------------
pljava-i686-pc-mingw32-pg8.0-1.1.0.tar.gz
System Enviroment:
--------------------
JAVA_HOME=C:\j2sdk1.4.2_02
PATH=%JAVA_HOME%\bin;%JAVA_HOME%\jre\bin;%JAVA_HOME%\jre\bin\client
CLASSPATH=C:\Archivos de programa\PostgreSQL\8.0\pljava\pljava.jar
postgresql.conf:
--------------------
custom_variable_classes = 'pljava'
pljava.classpath = 'C:\\Archivos de programa\\PostgreSQL\\8.0\\pljava\\pljava.jar'
pljava.statement_cache_size = 10
pljava.release_lingering_savepoints = true
pljava.vmoptions = '-Xmx64M'
pljava.debug = false
Tanks to any body that could help me.
---------------------------------
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050516/544592fe/attachment.html;
^ permalink raw reply [nested|flat] 2+ messages in thread
* [Pljava-dev] Help on installing pljava on Windows (no cgwin)
@ 2005-05-16 16:40
parent:
0 siblings, 0 replies; 2+ messages in thread
From: @ 2005-05-16 16:40 UTC (permalink / raw)
Juan Manuel Diaz Lara wrote:
> I am having roubles with this:
>
> From install.sql:
> ----------------------------
> CREATE FUNCTION sqlj.java_call_handler()
> RETURNS language_handler AS 'libpljava'
> LANGUAGE C;
>
> returns the following error:
>
> ERROR: could not load library "C:/Archivos de
> programa/PostgreSQL/8.0/pljava/libpljava.dll": dynamic load error
>
> Binaries:
> --------------
> pljava-i686-pc-mingw32-pg8.0-1.1.0.tar.gz
>
> System Enviroment:
> --------------------
> JAVA_HOME=C:\j2sdk1.4.2_02
> PATH=%JAVA_HOME%\bin;%JAVA_HOME%\jre\bin;%JAVA_HOME%\jre\bin\client
> CLASSPATH=C:\Archivos de programa\PostgreSQL\8.0\pljava\pljava.jar
>
> postgresql.conf:
> --------------------
> custom_variable_classes = 'pljava'
> pljava.classpath = 'C:\\Archivos de
> programa\\PostgreSQL\\8.0\\pljava\\pljava.jar'
> pljava.statement_cache_size = 10
> pljava.release_lingering_savepoints = true
> pljava.vmoptions = '-Xmx64M'
> pljava.debug = false
>
> Tanks to any body that could help me.
1. It seems your path is lacking the very essential entries %SystemRoot%
and %SystemRoot%\system32 (SystemRoot is probably C:\Windows or similar)
You won't get much working on Windows without those entries.
2. You don't need to have the CLASSPATH setting since you run PostgreSQL
8.0 or later and already have this setting in postgresql.conf
3. Your Java is very old. Consider an upgrade to either the latest 1.4.2
(1.4.2_08) or to a J2SE 5.0
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-05-16 16:40 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-16 16:08 [Pljava-dev] Help on installing pljava on Windows (no cgwin)
2005-05-16 16:40 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox