From: dgaethofs at yahoo.com (Danny Gaethofs)
Date: Tue, 14 Jun 2005 04:55:38 -0700 (PDT)
Subject: [Pljava-dev] PL/JAVA on Windows
In-Reply-To: <thhal-0y3mJA9+xzjYjyljX0VODpnLrE6BAKu@mailblocks.com>
Message-ID: <20050614115538.48253.qmail@web54706.mail.yahoo.com>

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. 

regards,
Danny






--- Thomas Hallgren <thhal at mailblocks.com> wrote:

> Danny Gaethofs wrote:
> 
> >Dear all,
> >
> >I have been reading the different mails about
> >installing PL/Java on Postgres under Windows Xp.
> >
> >It is still not clear what exactly needs to be
> done.
> >Let me explain the steps I took till I got
> stranded.
> >
> >I am running java 1.5 with JAVA_HOME at C:\Program
> >Files\Java\jre1.5.0_02.
> >
> >My path is defined as follows:
>
>%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\ProgramFiles\apache-ant-1.6.5\bin
> >
> >Step 1: Download and install PostgreSQL
> >Install the data directory on e:
> >Install the software on c:
> >Do not forget to Install Procedural Language
> >(pl/pgsql)
> >
> >
> >Step 2: Download and install PLJAVA
> >- Download pljava from the website 
> >
> >- Create a directory PLJAVA under
> >C:\ProgramFiles\PostgreSQL\8.0\pljava
> >
> >- Extract the content of the file into this
> directory.
> >
> >- Edit the contents of the postgresql.conf file
> which
> >can be found in the \data directory.
> >
> >Added the following lines:
> >custom_variable_classes = 'pljava'
> >pljava.classpath =
> >'C:\ProgramFiles\PostgreSQL\8.0\pljava\pljava.jar'
> >
> >pljava.statement_cache_size = 10
> >
> >pljava.release_lingering_savepoints = true
> >
> >pljava.vmoptions = '-Xmx64M'
> >
> >pljava.debug = false
> >
> >dynamic_library_path =
> >'$libdir:C:\\ProgramFiles\\PostgreSQL\\8.0\\pljava'
> >
> >log_min_messages = info
> >
> >Step 3:  Deploy the PL/JAVA
> >Now I should deploy the PL/Java but it is not clear
> to
> >me how this should be done. I read something about
> >executing this command: 
> >java org.postgresql.pljava.deploy.Deployer
> >
> >But when I do so nothing happens.
> >Can anyone help me out here, what steps am I
> missing.
> >  
> >
> Most things seems to be correct so far. What do you
> mean when you say 
> "nothing happens"? A succesfull installation is
> typically silent. There 
> will be lots of output in the backend log though. If
> you simply got a 
> new prompt and no other output, then my guess is
> that everything went OK.
> 
> Regards,
> Thomas Hallgren
> 
> 
> 



		
__________________________________ 
Discover Yahoo! 
Have fun online with music videos, cool games, IM and more. Check it out! 
http://discover.yahoo.com/online.html