Subject: [Pljava-dev] PL/JAVA on Windows
Date: Tue, 14 Jun 2005 15:07:30 +0200
Message-ID: <thhal-0FW+KA3G4zjY1kyKUGl5jkJ1loCmYnm@mailblocks.com> (raw)
In-Reply-To: <20050614115538.48253.qmail@web54706.mail.yahoo.com>
References: <20050614115538.48253.qmail@web54706.mail.yahoo.com>
<42AED692.9070105@mailblocks.com>
<thhal-0FG+KA2+4zjYgG9MoAQ8a5ZBzUcZipe@mailblocks.com>
Danny Gaethofs wrote:
>After defining the CLASSPATH as an user environment
>variable that contains:
>C:\ProgramFiles\PostgreSQL\8.0\jdbc\postgresql-8.0-310.jdbc2.jar;C:\ProgramFiles\PostgreSQL\8.0\pljava\deploy.jar
>
>The deployer now works. When I create a database and
>issue the command:
>C:\>java org.postgresql.pljava.deploy.Deployer
>-install -user compiere -password
> compiere -database cmpcs
>
>I get the message
>java.sql.SQLException: ERROR: could not access file
>"libpljava": No such file or
> directory
>
>But strange is that when I look at the database I find
>the schema sqlj is created.
>
>Is this what should happen? If yes why am i getting
>this error message about not finding libjava?
>
>And what should I do to solve it.
>
>
The schema is created before the functions in that schema are created
and called. The error you see is when a java function is called and
tries to instantiate the pljava binary module. Your postgresql.conf file
contains the following line:
dynamic_library_path = '$libdir:C:\\ProgramFiles\\PostgreSQL\\8.0\\pljava'
Change the first colon to a semicolon. Windows use semicolon as the path separator (it has too since colon is part of the drive designator).
Now run the deployer again with option -uninstall. You will see an error (since the language is not installed) but you can ignore it. Then try to install again.
Regards,
Thomas Hallgren
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] PL/JAVA on Windows
In-Reply-To: <thhal-0FW+KA3G4zjY1kyKUGl5jkJ1loCmYnm@mailblocks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox