From: johann at 2ndquadrant.com (Johann 'Myrkraverk' Oskarsson) Date: Sat, 19 Feb 2011 01:02:58 -0000 Subject: [Pljava-dev] Pl/JAVA Windows XP In-Reply-To: References: Message-ID: Hi Alexandre, On Fri, 18 Feb 2011 16:21:16 -0000, Alexandre Teixeira wrote: > 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. What exactly are you doing that fails? Can you give us the steps that reproduce the error for you? > 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); Did that succeed? Does CREATE FUNCTION f(TEXT) RETURNS TEXT AS 'java.lang.System.getProperty' LANGUAGE JAVA; SELECT f( 'user.home' ); work? -- Johann Oskarsson http://www.2ndquadrant.com/ |[] PostgreSQL Development, 24x7 Support, Training and Services --+-- | Blog: http://my.opera.com/myrkraverk/blog/