agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Pl/JAVA Windows XP
Date: Fri, 18 Feb 2011 16:21:16 +0000
Message-ID: <BLU149-W355BD4CED6BCC8C01C6B8EE9D40@phx.gbl> (raw)


Hi there,

I'm trying to install PL/JAVA in windows XP and I tryed all the  possibles variations, from PostgreSQL 8.1 to 9.0 and JDK 1.4 to 6.
I succced in creating sqlj scheme but it gives me an error when I try to run the PL/Java sample tests. It takes 3 seconds processing and after this it crashes with this message: "********** Erro **********".
I'm using PostgreSQL 8.3 and jdk1.5.0_22. I tryed PLJAVA that is included in the postgres installation and the pljava-i686-pc-mingw32-pg8.3-1.4.0 PLJAVA instalation. 

Here is my configuration for:

PATH=C:\Program Files\Java\jdk1.5.0_22\lib;C:\Program Files\Java\jdk1.5.0_22\bin;C:\Program Files\Java\jdk1.5.0_22\jre\bin\client;C:\Program Files\Java\jdk1.5.0_22\jre\bin;C:\Program Files\PostgreSQL\8.3\bin;c:\Program Files\PostgreSQL\8.3\lib;C:\Program Files\PostgreSQL\8.3\share\pljava

postgresql.conf file:

custom_variable_classes = 'pljava'
pljava.classpath = 'C:\\Program Files\\PostgreSQL\\8.3\\share\\pljava\\pljava.jar'
pljava.statement_cache_size = 10
pljava.release_lingering_savepoints = true
pljava.vmoptions = '-Xmx64M'
pljava.debug = false
dynamic_library_path = '$libdir;C:\\Program Files\\PostgreSQL\\8.3\\share\\pljava'
log_min_messages = info

CLASSPATH:
C:\Program Files\PostgreSQL\8.3\jdbc\postgresql-8.3-606.jdbc4.jar;C:\Program Files\PostgreSQL\8.3\share\pljava\deploy.jar

I use this command in prompt to create the sqlj scheme:

C:\>java -cp "C:\Program Files\PostgreSQL\8.3\share\pljava\deploy.jar;C:\Program Files\PostgreSQL\8.3\jdbc\postgresql-8.3-606.jdbc4.jar" org.postgresql.pljava.deploy.Deployer -install -user postgres -database teste -password postgres

This is the command to run the PL/Java sample tests

SELECT sqlj.install_jar('C:/Program Files/PostgreSQL/8.3/share/pljava/examples.jar', 'samples',  true);

Thanks for the attention,

Alex


 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110218/5dfb4657/attachment.html;

view thread (2+ messages)  latest in thread

Message-ID: <BLU149-W355BD4CED6BCC8C01C6B8EE9D40@phx.gbl>
Permalink:  ../BLU149-W355BD4CED6BCC8C01C6B8EE9D40@phx.gbl/
Also on:    postgresql.org/message-id/BLU149-W355BD4CED6BCC8C01C6B8EE9D40@phx.gbl

reply

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 Windows XP
  In-Reply-To: <BLU149-W355BD4CED6BCC8C01C6B8EE9D40@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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