From: deamorim2 at hotmail.com (Alexandre Teixeira) Date: Fri, 18 Feb 2011 16:21:16 +0000 Subject: [Pljava-dev] Pl/JAVA Windows XP Message-ID: 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: